Hi I have a table and query filter which is associated with same query in LCA, I want to have the values in filter so that it gets filtered out but I dont want them to be shown on the table.
I tried by hiding the columns from query but that removes those columns in query filter too, how to achieve this?
Hi Apurva,
You can achieve this by adding query column data as a filter to the table. Only the columns that are present as a filter will be shown. Note that you can also filter the query filter columns in the same way.
Hi Apurva, that is exactly what my answer achieves. You can still filter on the columns using the query filter component, but they are hidden in the table component. Is there something about your use case that I'm missing?
Hi Thanks, but in your gif I am not able to understand as in your table column I can see only 2 columns and when you added it as filter only name was shown,
So in my case I am unable to understand how to set this,
My query name: Get Bandwith connection (which has 3 fixed columns and rest dynamic)
I want filter on first three, and on the right table with the columns apart from that and filter working
So with your gif in filter I have selected my query it shows filter but for table I selected same query and added filter so remaining columns dontcome up or filter doesn't works somehow
Sorry, might be I am not able to understand properly
Hi it works, but the thing is I have to select all those columns for table in filter except filter columns, but my problem is other columns are dynamic I want them to be add in table filter leaving the ones in filter
Hi Apurva, I cannot think of a way to achieve this without needing to add all necessary columns to the table as a filter. To make this possible, we would need a way to invert the filter data on the table.
Hi thanks, but so as in my image
In Filter you can see Element Name and Key Name as filter and same are available as columns in table too,
So I want those Element Name and Key Name in filter as is, but should not be shown on the table to the right (So it should only one column that is Packet Size)
But if filter is selected it show show only those rows properly although those columns are not visible in table.
The columns apart from the first 3 columns are dynamic which should be shown always