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
conditional filtering in dropdown filtering defined
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
-
- Posts: 2431
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: conditional filtering in dropdown filtering defined
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)))
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....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
Re: conditional filtering in dropdown filtering defined
great thank you Mark, let me try this out.