ExB Filtering records between two tables with a List, and dynamically specifying called view based on field value

557
3
Jump to solution
03-07-2023 08:47 AM
ScottHiggins_PVGIS
New Contributor III

So, quick question. 

We have a master list of reports, with various report types (a la Report A, Report B, Report C in a field called report types). The master table has a field ReportID, and the data sets for Report A, Report B, Report also have a field called ReportID, which handles the filtering).

The button in theory would help direct to the specific view, named the same as View: Report A, Report B, Report C

 

What we are wondering is how we can granularly call a specific View from a List button, the button in the list references dynamically the Report type, using specifically an URL parameter call that is dynamically put together.

So, if the button in master list that says Report A is clicked, it selects that record from the master list, the report ID from that record filters the corresponding Report A record where the ReportID are the same between, and the url parameter in the button will open the view titled "Report A" which is logged into the Master table as the same name/label as the view is named.

I've been following this documentation: https://doc.arcgis.com/en/experience-builder/latest/build-apps/url-parameters.htm

And it works for hardcodes vales, but the dynamic part based on field vales and button clicks is escaping us. Any advisement, or has anyone done granular view calls from ur paramater?

 

0 Kudos
1 Solution

Accepted Solutions
ScottHiggins_PVGIS
New Contributor III

Im just an idiot. Missed an encoded single quote on the filter. 

View solution in original post

0 Kudos
3 Replies
ScottHiggins_PVGIS
New Contributor III

So I can dynamically call the view with the url parameter, but I still need to handle the filter between the List and the table that is called in the dynamic view, as the when the button opens the view it doesnt maintain the record selection when it navigates to the dynamically called view.

To call the view in the List Button, I use this URL expression:tempsnip.png

Following the documentation here: https://doc.arcgis.com/en/experience-builder/latest/build-apps/url-parameters.htm

How would we best expand the URL expression ,

"https://35.188.xxx.xxx:3001/experience/48/page/View-Reports/?views="+{view_Name}

to include the filters between the list selection record using field: ReportID in the List, and record included in the called view, which also would use the field ReportID value in the filter)

per documented formation: https://experience.arcgis.com/experience/<AppId>/?data_filter=ds1:objectid=1,ds2:fielda>

Master List data source ID is: dataSource_2-23%

And one of the tables in the dynamically called view (that needs to be filtered) data source ID is: data_id=dataSource_2-13

I cannot seem to construct this to filter, dynamically, following this example: https://experience.arcgis.com/experience/<AppId>/?data_filter=ds1:objectid=1,ds2:fielda>

0 Kudos
ScottHiggins_PVGIS
New Contributor III

/48/page/View-Reports/?data_filter=dataSource_2-23%3AReport_ID%3D"+{Report ID}+"%2CdataSource_2-13%3AReport_ID%3D"+{Report ID}+"&views="+{view_Name}

Where it breaks down for me, filtering list selected record to the corresponding record in the table in view that opens up.

0 Kudos
ScottHiggins_PVGIS
New Contributor III

Im just an idiot. Missed an encoded single quote on the filter. 

0 Kudos