Survey123 Inbox – Is dynamic filtering possible before opening the Inbox (including offline use)?

[FlaynerRessoni]

Hi everyone,

I’m working on a Survey123 workflow where users need to open the Inbox to review and update existing records.
Currently we have a single survey, but the Inbox shows all records. We would like to filter the Inbox based on a “work front” (a category that users belong to or select).

What we need

Before the user opens the Inbox, we want the survey to load only the records associated with a specific work front.

We would like to know if it is possible to:

1. Dynamically filter the Inbox, based on a value the user selects inside the survey (e.g., a select_one front question).

2. Filter the Inbox using a URL parameter, such as ?front=XYZ.

3. Make this work in offline mode (Survey123 mobile app or desktop app).

[ZenMasterZeke]

Not sure S123 supports it, but if it does you could add a LIMIT or TOP statement to the WHERE clause, so they only download n number of rows.

'SELECT column_name(s)FROM table_name
WHERE condition
ORDER BY column_name(s) [ASC | DESC]
LIMIT number_of_rows;'

'SELECT TOP (number | PERCENT) column_name(s)FROM table_name
[WHERE condition]
[ORDER BY column_name(s) [ASC | DESC]];'

 (Quotes added because ESRI flagged the SQL. Remove when using)