Focal Point
[CASE-OPENED] Flex data "subgrids"

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/360107223

December 21, 2009, 01:09 PM
Darin Lee
[CASE-OPENED] Flex data "subgrids"
I've done a bit of Flex development now, so I don't know why I haven't run across this before. Hopefully, I'm just totally missing the point on this one - here's the situation.

I have a dataset that intially retrieves all claim data for all years of open claims plus any closed claims for the previous five years. My flex dashboard combines the data on some tabs, while other tabs exclude the open claims older than five years.

The problem is in generating components for some tabs while components in other tabs remain unaffected. For example, I've loaded data into mainGrid, one of the columns being claimyear. On one tab I'm showing trends for the last five years of data, but when I create filter controls, the values also contain those open claims older than five years. So I think to myself "Why not just create a separate clid "subgrid" that ONLY contains the last five years of data? That way I can just create filters from the relevant data and I don't need to keep adding a filter default to every component eliminating older claims." Well for whatever reason, I can make my filters show the appropriate values from the subgrid, but they will not be applied against that subgrid. The only way any filters will work is if they have mainGrid as the parent and are applied there. But if I apply them at that level, all of the components on other tabs are affected by the filters as well and I want to keep each tab's components & filters independent of other tabs.

Is there someone who has created subsets of their data from the main grid and successfully applied filter criteria against those subsets? Sorry if that sounds a little confusing. I can answer additional questions if necessary.

This message has been edited. Last edited by: Kerry,


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
January 05, 2010, 01:27 PM
<csssps07>
Hi there,

Not quite sure what you mean by:

"Well for whatever reason, I can make my filters show the appropriate values from the subgrid, but they will not be applied against that subgrid."

So when you change the filter conditions, it does not show the resulting data in the subgrid? Can you clarify the behavior?

It may be less painful to just create a seperate "main" datagrid with the filtered data instead of the subgrid.
January 08, 2010, 11:36 AM
Darin Lee
quote:
So when you change the filter conditions, it does not show the resulting data in the subgrid

That's right. The filter selected does not get applied so the displayed contents of the subgrid do not change as the filter calue is changed.

The data is being retrieved via a fex as specified in the seturl property. There are eight different tabs that need to be have their own grid, multiplied by the 30,000 user community, so having multiple calls to the WF server to populate separate "main" datagrids isn't an option.

I have opened a case with tech support and they have indicated that this is not the intended behavior. Still waiting on a resolution. I will update when I hear something back.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
January 11, 2010, 10:28 AM
TexasStingray
Have you explored using the FLEX Enable API. I also have a question how many rows of data are you bring back?




Scott