Merging searches

[jda]

Hi,

Sorry to revisit this issue, but I thought I had it licked (and don't).

Rather than ask for a feature, I thought I'd outline the problem and 
ask how it might be solved.

I have search queries stored so I can create "smart groups" (a la 
iTunes). I want the user to be able to select multiple groups at once 
(as many as he likes), and have my app return the records common to 
all (AND) or all the records found in any (OR).

I've seen reference to an sql UNION command (which I think Ruslan 
mentioned is supported in v2), which may be good for the records 
common to all. I've also seen that there is a UNION ALL command 
(supported by v2?), which looks like it would be useful for getting 
all the records found in any cursor. Or is there some other way?

My question is, what is the best (simplest and most efficient) way to 
do this in Valentina 2?

Thanks,

Jon