Dear forum,
Since the report creator PDF file does not cover this issue I would like to ask your help.
Due to the different types of datasheets we have I need to use the query filter in report creator to filter out multiple items. We use the short description to filter items on.
What is the correct filter string for this?
I tried
<>'LEVEL GAUGE' <-- Valid but this is only 1 item.....
<>'LEVEL GAUGE' or <>'SAFETYR RELIEF VALVE' <-- INVALID
<>'LEVEL GAUGE' and <>'SAFETYR RELIEF VALVE' <-- INVALID
<>'LEVEL GAUGE' <>'SAFETYR RELIEF VALVE' <-- gives error "eQryErSynUnbalPar"
<>'LEVEL GAUGE' 'SAFETYR RELIEF VALVE' <-- gives error "eQryErSynUnbalPar"
<>'LEVEL GAUGE','SAFETYR RELIEF VALVE' <-- gives error "eQryErSynUnbalPar"
If there is another field that can be used to filter out multiple items please let me know.
Regards
Solved! Go to Solution.
Solved by dave.wolfe. Go to Solution.
Solved by AndyDavisCadline. Go to Solution.
Hi,
If you want to include values, the syntax is: (IN 'LEVEL GAUGE', 'SAFETY RELIEF VALVE' )
To exclude values, the syntax is: (NOT IN 'LEVEL GAUGE', 'SAFETY RELIEF VALVE' )
Regards,
Andy
I tried that and it does not seems to work.
I will make a small screencast for you to see.
Please hold on will make it now.
Dear @AndyDavisCadline
I already found what I was doing wrong...
I forgot to apply the filter at INLINE instruments as well..
I can't tell where you are setting up the filter, but my preference is to use the Filter String property in the Report Designer. To get there, select the Report (top level item) in the Report Explorer, and then open the Filter string property. It's much more powerful/easy to use than modifying the query, so you get a UI that takes care of formatting.
Similar syntax though:
That is also a good solution. Either of them seems to work proper...
Thanks for pointing out
Can't find what you're looking for? Ask the community or share your knowledge.