foundset.find with array of values

Classic Servoy
1

According to the wiki I can use an array of values in the find:

“record.department_id = [1, 33, 99]”

in my foundset I’ve got a creator field, this is UUID.
I’ve created a variable myCreators = [‘’,‘’]
When I add it to my find like this:

fs.find
fs.creator = myCreators
fs.search()

I do not get a result
But when I add it like this:

fs.find
fs.creator = ['<uuid>','<uuid>']
fs.search()

Then I do get a result.
What am I doing wrong here?

2

Why can’t use createselect?

3

Hi Gianluca,
what do you mean with createselect?

4

Look in the wiki databaseManager.createselect: you build a query that you can use instead of the find. It is very powerful and versatile.
You can replace find command with createselect for complex search.