Query -> Table Widget Action Difficulty

[SteveCole]

I'm probably dense because I just find EB workflows too confusing but I'm having difficulty getting an action to do what I want. 

Backstory- I'm developing a very simple EB based front end to allow my users to export S123 records to CSV. The S123 has a feature class with 2 related tables (there are 2 repeat sections in the survey). The EB project only has a Query widget and then a Table widget below it. The Query widget is associated with the S123 web map that contains the feature class and the Table widget also points to the same S123 feature class & related tables.

Desired Workflow- Ideally, my users would select the desired records using the Query widget and then the Query widget would then select the same records in the Table widget using the Query Widget's Action. But it's not happening even if the Action pane infers that it *should* happen-

I've tried developing this initially without a Map widget and now with a map widget (hidden behind the table widget since it's not needed visually) and I can't get the Query widget to auto update / filter the table widget contents.

Before anyone asks, I know you can export records through the Query widget but I don't like how the actual export tool is buried in the interface, especially for the 2 related tables. At least with the Table widget, the user can just switch tabs and the export button is there.,

[JonM32]

@SteveCole 

I recently discovered the Manager Instant App and used it for Survey123 survey management. I was able to set it up with the feature layer associated with a survey, allowing others to edit results. There is a very simple, easy way for end users to export the results to a CSV built in. You may be able to use this out of the box or configure it for what you described above.

Manager—ArcGIS Instant Apps | Documentation

311 Requests - Street Conditions (Esri Example)

[SteveCole]

Thanks Jon for highlighting that Instant App as I wasn't familiar with it. I neglected to mention that I'm attempting all this inside Portal version 11.5. The Manager Instant App is available to me but, right now, I'm just getting a spinning circle when I launch the app. Clearly I'm doing something wrong so I need to read up on it. Only thing I don't like is it being map based. My S123 use isn't map dependent.

[ToddW_stl]

Can you use the Filter widget instead and avoid using query widget actions?  I'm a couple months out from the last time I configured an ArcGIS ExperienceBuilder app, but in theory:

• Filter widget data source is the map (layers/tables)
• Table widget data source is the map (same as above)

When the user sets Filter(s), I think it should automatically update/filter the tables, since they're using the same data source.

Since you don't need the map - have you tried this as an ArcGIS Dashboard using just the layer data as the dashboard source?  Seems like a couple selector filters in the header and a table widget with export enabled would suffice.  Note: I'm not sure how the related tables would be handled though...

[SteveCole]

Hi Todd,

As with most things ESRI, you tend to get most of the way there before stepping on a rake & get hit in the face. Your suggestion seems straightforward enough but it's not working either. I've designed the filter SQL query in the exact same way as what I've done with the Query widget but at runtime, there are no values to select in the pulldown.

Query widget SQL design:

Query widget runtime:

Meanwhile, filter widget SQL design:

and filter widget at runtime:

[ToddW_stl]

It looks like you're trying to set pre-determined filters - I set the Filter widget to use Custom filters in my solution to this other post - and users were able to select from a drop-down after choosing the field of interest.  I still may recommend trying ArcGIS Dashboards, as this is a simple filter, view, export workflow and ExB may be overkill.  Either way I'll try to set aside some time tomorrow to mock up some data and see if I can duplicate what you're trying to do.