Hi, I have an app and in that app, I use a parameter table component.
Using that component’s settings, I can filter data on certain columns.
But I would like to filter a certain column and only show the rows where that column contains a certain string. I don’t want it to be equal, because there are multiple variations containing the string I want to filter on. Is this possible?
I was unable to find it using the following docs:
Hi Dieter,
Could you elaborate on what kind of ‘multiple variations’ you expect to encounter?
If a basic equal operation does not work it could be that the FULLFILTER= together with a Regex expression achieves what you are after.
Hi Dieter,
If you want to have full control of what is displayed in a table, you can create a GQI Operator and than read the desired column and output to the same table the layout that you want (e.g, combination of rows and columns you want).
See GQIOperator
See GQIEditableRow Class
To give you an example:
// Pseudo code
public void HandleRow(GQIEditableRow row)
{
1) There is a method called “row.GetValue<T>(desiredColumnName), where T can be a string, double etc
2) After retrieve this, you can check if the cell of the specified column contains the value you want. If so, you can keep the row in the table.
3) If not, you can do “row.Delete()” and the row will be removed
}
Kind regards,
Thanks, but this was not my question. My question is about the parameter table component and not the normal table component. This is because I still want my write params to be available.
The fullfilter with regex does the trick, thanks.