nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

ScottHiggins_PVGIS

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?

Encontre mais publicações marcadas com

Accepted answers

ScottHiggins_PVGIS

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

All comments

ScottHiggins_PVGIS

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:

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.xyz.xyz: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>

ScottHiggins_PVGIS

/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.

ScottHiggins_PVGIS

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

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.