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=trueif 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
nameand the parameter table has aFKto 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
Hi Ive,
Maybe a Inner Join between both tables, using the foreign key as link could help you with the filter. If you use the joined table as feed, you should be able to filter the trended parameters table by the index on this table, or by other column useful for you. And then, you could filter the trend graph by the filtered row on your trended parameters table.
I hope it helps you!