I am using the transformation ‘filter field by value’, and using ‘Column name’ is equal to ${variable_name}. However when I’m using “All” option I think the transformation is doing column name is equal to “All” instead of selecting all the values. How do i address this issue?
Step 1 : create variable
Step 2: select datasource and fetch data by query
Step 3: Add transformation
I forgot to mention I am using infinity plugin. Is the syntax still the same?
Using this postgresql query Select * from table name i fetch data from database and display on panel , you can use these data formats to fetch data on panel in infinity plugin.
and then apply transformation simply.
just fetch data and disply on panel then remain step is same for transformation.
What data type are you using? JSON or csv?
hello @vishalpanuganti98 please confirm problem is resolved or still facing issue.
Im using csv
Im still a bit confused. Im using UQL to fetch the data.
Here when I try to write the condition, Business Id is equal to ${BusinessId} and select All option from the drop down. I think it equates Business Id is equal to All, instead of selecting all the values. Because I get No Data on my panels after selecting “All”
follow this doc it will help to filter the data and display on panel.
2 Likes
You need to tick Include All option
Yes, I understand but in my transformations I apply Job Name is equal to “${BusinessId}” when I select “All” option I get no data I think internally the transformation is equating “Job Name” is equal to “All” instead of selecting all the values
One way to find out is click on query inspector of the main dashboard query and see data tab