Page 1 of 1
FH7 Query "Other Event" events only
Posted: 20 Aug 2021 09:31
by ississi
Hi,
what Row expressions do I need to create a query which shows all "Other Event" events only, please? I'm trying to base this on the "All Events" query, but I can't work out the expression to just show "Other Events". Any help, please?
I've tried
Add if... =FactLabel(%FACT%) matches "Other Event" but that doesn't work.
Any help would be very appreciated

Re: FH7 Query "Other Event" events only
Posted: 20 Aug 2021 09:46
by tatewise
What do you mean by "Other Events"?
Your posted Row filter will only work for a Fact that is specifically labelled "Other Events".
Try omitting the
" string quotes
".
So what other events do you want to be listed?
You must either have multiple Row filters to
Add each one you want to be listed, or multiple Row filters to
Exclude the ones you don't want to be listed.
Have you tried the
All Facts Filter by Label download?
Re: FH7 Query "Other Event" events only
Posted: 20 Aug 2021 12:00
by ississi
I had tried previously removing the quotes but that didn't work. I had to change the operator as well...
The solution is this:
Condition: Add if...
Expression: =FactLabel(%FACT%)
Operator: begins with
Value: Other Event
thanks for the heads-up on the All Facts Filter by Label download
Re: FH7 Query "Other Event" events only
Posted: 20 Aug 2021 14:35
by tatewise
It all depends on the Label of the Fact, or Labels of the Facts, you are trying to list.
If you use the matches operator then the Value must be an exact match for all of one specific Fact Label.
If you use other operators then the Value must begin, end, or be contained in any Fact Labels.
Presumably, you don't have a Fact with a Label of Other Event but do have one or more Labels that begin with Other Event.