conditional filtering in dropdown filtering defined

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

conditional filtering in dropdown filtering defined

Post by swiftinitpvtltd »

I have a dropdown in aware im form where I need conditional filtering in dropdown filtering defined property.
Right now it can only have one condition. I need dropdown to show data from same BO but with different condition if and then else..

if(x>2)
find mybo where...cond1
else
find myby where...cond2

This in conditional filters
customaware
Posts: 2431
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: conditional filtering in dropdown filtering defined

Post by customaware »

How about something like.....

FIND X WHERE ( (COUNT y WHERE (y=Blah AND y IN Blah Blah AND X>2)>0) OR (COUNT z WHERE (z=Blah AND X<=2)>0)))
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

Re: conditional filtering in dropdown filtering defined

Post by swiftinitpvtltd »

great thank you Mark, let me try this out.
Post Reply