Hi,
My low-code app has a table where the user can select a row in a table.
I want to use the selected row, to feed a trend graph linked to a parameter in another table.
I can use the elements and indices from the selected row feed.
However, the indices in the two tables are different.
There is a foreign key between the table where the user selects a row, and the table containing the parameter I'd like to show on my trend graph.
Is there a way to make this work?
Since there's a foreign key relationship between the selected row in the first table and the data in the parameter table (used for your trend graph), you can use a Parameter table filter to bridge this gap (see docs).
Here's how to do it:
- Enable Advanced Settings
Add?showAdvancedSettings=true
(or&showAdvancedSettings=true
if other parameters are already present) to your app URL to expose the parameter table filters UI. - Create a Parameter Table Filter
- Go to Parameter table filter sections
- Create a filter and give it a name
- Use the foreign key from the selected row in the first table as a filter condition.
- For example, if the first table has a column
name
and the parameter table has aFK
to this first table, your filter might look like:VALUE=FK == [FEED."Current view"."Table 1"."Selected rows".Tables.Name]
- Use the intellisense to assist with the correct syntax and available variables.
- For example, if the first table has a column
- Apply the Filter to the Trend Chart
- Add the protocol parameter to the trend chart as data
- Add an element to it (and apply it as a filter)
- Add the parameter table filter as a filter