Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Flex | ibiDatagrid | Changing the data in maindatagrid
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Flex | ibiDatagrid | Changing the data in maindatagrid
 Login/Join
 
Member
posted
Hi,

I would like to change the data on my main datagrid based on an ibiColumnchart with an event itemclick or(hitarea)

I thought saving different XML urls in an Arraycollection and passing this to the "seturl"
parameter & reloading would do.

Unfortunately not..How would you refresh the MainDG or pass this new XML to the main datagrid?

any help would be great...

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


-----------------------------
PROD WF 7.7.02, PMF 5.2.3, MSQL 2005
QA WF 7.7.02, PMF 5.2.3, MSQL 2005
Primarily self-service; adapters: SAP BW, SAP R/3, SQL Server, FlexEnable
Windows, all output
 
Posts: 22 | Location: Germany | Registered: December 17, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Having a little trouble figuring out what it is you're trying to accomplish. Maybe some code would help. The mainGrid can be refreshed with

ibicanvas.reloadData("mainGrid","");

but are you loading this from a procedure or an embedded XML file? The properties for seturl can be "internal" or "{functionFex()}" where functionFex is the function where the URL string is built to call a WF procedure. Is this something similar to a drilldown chart? If you're replacing the data in you primary grid, remember that there's not "going back" without another complete reload of the original data. Maybe try loading different sets of data into multiple grids and let the click event switch between those instead. It appears that you are trying to go and get a whole different data set when the column chart is clicked on, but that seems kind out counter-intuitive to the dashboard purpose. Maybe let the click event apply a filter instead?


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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Reply With QuoteReport This Post
Member
posted Hide Post
yes I am currently trying to use the

ibiCancas.reloadData("MDG",""); command.

Unfortunately with not that much success.

Why trying to reload "drilled data" instead of a filter?

First. Me <- Newbie to Flex. Cool
Second. The ibiColumchart in the end should change its XSeries and YSeries depending on the "direction" of the drill.

With having all viseted drilldowns & paramters in an ArrayCollection I thought creating an back button for the enduser.

private function loadNow():void{
...

MainDG.seturl = "prettylongxmlstring=app/sample_xml_data1";
// MainDG.invalidateDisplayList();
// MainDG.data.refresh();
// MainDG.invalidateList();

MainCanvas.reloadData("MainDG","");
Alert.show("New URL ? ");


-----------------------------
PROD WF 7.7.02, PMF 5.2.3, MSQL 2005
QA WF 7.7.02, PMF 5.2.3, MSQL 2005
Primarily self-service; adapters: SAP BW, SAP R/3, SQL Server, FlexEnable
Windows, all output
 
Posts: 22 | Location: Germany | Registered: December 17, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
So you're not really wanting to reload the data, you're just wanting to change the way that it appears to be sorted.

Along with whatever code you're using in your functions to change the sort values, add

ibicanvas.refreshDP("MDG",true,null);

at the end and see if that does the trick.


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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Reply With QuoteReport This Post
Member
posted Hide Post
No Id like to retrieve new data based on the customers choice.

and traced this:

[14:27:54.357] fetch data from source: https://correct url + this here -> &Rand=95848
[14:27:54.357] Fetching Data
[14:27:54.357] Sending request
[14:27:54.435] Processing Data
[14:27:54.435] processing xml
[14:27:54.435] Data Error
[14:27:54.435]
WebFOCUS-Hinweis: Keine zur Verarbeitung gültige cgi-Anfrage

I wonder where this random number is coming from...


-----------------------------
PROD WF 7.7.02, PMF 5.2.3, MSQL 2005
QA WF 7.7.02, PMF 5.2.3, MSQL 2005
Primarily self-service; adapters: SAP BW, SAP R/3, SQL Server, FlexEnable
Windows, all output
 
Posts: 22 | Location: Germany | Registered: December 17, 2009Reply With QuoteReport This Post
Member
posted Hide Post
ok the &Rand URL is fine to me so far.

Unfortunately still not for the DataGrid.seturl when I trie to refresh it

with: ibiCanvas.refreshDP("MDG",true,null);

Any other ideas to refresh data??


-----------------------------
PROD WF 7.7.02, PMF 5.2.3, MSQL 2005
QA WF 7.7.02, PMF 5.2.3, MSQL 2005
Primarily self-service; adapters: SAP BW, SAP R/3, SQL Server, FlexEnable
Windows, all output
 
Posts: 22 | Location: Germany | Registered: December 17, 2009Reply With QuoteReport This Post
Member
posted Hide Post
ok with mainCanvas.reloadData('MDG',null);

and the wright url it works fine...


-----------------------------
PROD WF 7.7.02, PMF 5.2.3, MSQL 2005
QA WF 7.7.02, PMF 5.2.3, MSQL 2005
Primarily self-service; adapters: SAP BW, SAP R/3, SQL Server, FlexEnable
Windows, all output
 
Posts: 22 | Location: Germany | Registered: December 17, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Glad you got it working and thanks for the update. Sorry I didn't follow-up - was out of the office for a while.


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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Flex | ibiDatagrid | Changing the data in maindatagrid

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.