"Equal to one of" expression

gust

Is there such an expression?

Something like this:

Find Profile WHERE (Profile.Category="one of" NonPersistedObject.Category)

Find Profile WHERE ("one of" NonPersistedObjectObject.Category IN Profile.Category)

aware_support

If it doesn't matter which instance to find, use TAKE BEST 1 in the FIND action

gust

It does matter.
For example, I have

Profile WHERE Profile.Category=A

and

Profile WHERE Profile.Category=B

When I run process

Find Profile WHERE (Profile.Category="one of" NonPersistedObject.Category)

WHERE NonPersistedObject.Category contains category A and B

I want to see in the result both Profiles but not one:

Profile WHERE Profile.Category=A

and

Profile WHERE Profile.Category=B

aware_support

Isn't it just:

FIND Profile WHERE Profile.Category=A OR Profile.Category = B?

Otherwise, I am not sure I understand what you are talking about

gust

The problem is that "one of" NonPersistedObject.Category may contain any number of categories, it contains categories you have added in NonPersistedObject.Category.

Thats why I wrote rule:

Find Profile WHERE (Profile.Category="one of" NonPersistedObject.Category)

aware_support

Is it then FIND Profile WHERE Profile.Category IN NonPersistable.Categories??