Filtering in a dynamic sheet using a URL parameter (static)

If I want to filter a dynamic list of type User, Org. Unit, or Role to a specific value, there are multiple options available.

One of them is to define it directly in the variable in the URL parameter in the variable definition.

This is a static variable setting that does not address any changes in processes (different headers, dynamic changes, etc.)

The URL parameter calls the TAS API directly. Therefore, we can pre-filter the values ​​directly in the roles table and then use the filter in the URL definition.

  1. To find out the URL filter, it is a good idea to turn on DevTool in the browser (F12 key) and open the Network tab.
  1. Then I filter the value, e.g. by category
  1. In the network tab I then see the call to the application backend and I can copy it, I just need the part after the last slash

roles?offset=0&limit=22&filter=role_category%3Clike%3E%22%25TST%25%22&order=role_name,id&sort=asc,asc

  1. Then I paste the copied code into this tool and use Decode

https://meyerweb.com/eric/tools/dencoder/

Decode value:

roles?offset=0&limit=22&filter=role_category<like>"%TST%"&order=role_name,id&sort=asc,asc

  1. I can delete the offset and limit from the code and insert them into the URL definition of the variable. By default, the limit limits the selection to 27 values ​​and it might not display everything.

roles?filter=role_category<like>"%TST%"&order=role_name,id&sort=asc,asc

  1. The variable now only displays values ​​from the "TST" category

Frantisek Brych Updated by Frantisek Brych

Search in a dynamic table by column value

Contact

Syca (opens in a new tab)

Powered by HelpDocs (opens in a new tab)