I am building a new report in the reporting module.
I want to filter the data in a table with a key word. (the query selects all data and i want to display this data per engine in a separate table)
Displaying all the data is no problem but when i use the Filter key i cant filter the data.
Example data collected with query:
Engine 1
Engine 2
Engine 3
Filter key: Engine 1
Result: No data displayed.
See also the attachment.
Thanks for the detailed picture. If only every question was so clearly illustrated!
The Filter Key is an expression that evaluates to true/false (see the docs on tables). I would try using something along the lines of engine = "Engine 1"
[quote=“KathyApplebaum”]Thanks for the detailed picture. If only every question was so clearly illustrated!
The Filter Key is an expression that evaluates to true/false (see the docs on tables). I would try using something along the lines of engine = "Engine 1"
[/quote]
Thanks for the response and the manual lookup.
I tried your suggestion but the filtering still does not work.
With the filter setup to:
engine = “Engine 1”
I get the same data as without the filter.
Think Kathy forgot an “=” sign. Just tried out a filter on a table and it worked using standard Java style notation. The keychain expression docs have a breakdown of the different operators.
Give this a shot:
engine == "Engine 1"
Sorry, that’s what I get for posting code before sufficient caffeine intake.
Thanks all for the support.
The last tip did the trick.