stupid forall question, fix the AND statement in the code.

[Kurry]

I had this result in another question in this community here

But I get this as an error.

Invalid argument type (Table). Expecting a Boolean value instead.

the code: 

ClearCollect(
    ColFilteredClubInfo,
    Filter(
        VarEvents,
        And(
            ForAll(
                ColSearchWords As SEARCHWORD,
                SEARCHWORD.Value in title
            )
        )
    )
);

Any toughts on a fix?

Thx for helping me out!

[anandm08 · Accepted solution]

hi @Kurry ,

try this:

ClearCollect(
    ColFilteredClubInfo,
    Filter(
        VarEvents,
        And(
            CountRows(
                Filter(
                    ColSearchWords,
                    SEARCHWORD.Value in title
                )
            ) > 0
        )
    )
);

[WarrenBelz]

Hi @Kurry ,

Unless I am misreading this, I think the solution is much simpler

ClearCollect(
   ColFilteredClubInfo,
   Filter(
      VarEvents,
      Title in TextInputFilterEvents.Text
   )
);

[Kurry]

This seems to be harder than I thought... 😉

I would like to get the resultset to be the records that contain all the searchwords in the ColSearchWords.

Your code changes that to only 1 word apperantly.

[Kurry]

As I stated above in my comment, and as you replied on my previous post also, I would like the records to be filtered on all words in the ColSearchWords collection.

any toughts?

[Kurry]

After some testing from my side, I found the solution to my problem with your code here:

You stated that the result should be more then 0, but then you match with any 1 of the given words in the collection.

CountRows(
                Filter(
                    ColSearchWords,
                    SEARCHWORD.Value in title
                )
            ) > 0

I changed that code to match all of the words in the ColSearchWords.

Filter(
        VarEvents,
        And(
            CountRows(
                Filter(
                    ColSearchWords As SEARCHWORD,
                    SEARCHWORD.Value in title
                )
            ) = CountRows(ColSearchWords)
        )
    )

using = CountRows(ColSearchWords).

Thanks for helping me out! 

BTW, You gave me the option to specify the amount of words that have to match! SUPER.