* FH7 Query "Other Event" events only

[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

[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?

[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

[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.