Page 1 of 1
filter data (v2021)
Posted: Wed Mar 08, 2023 6:32 pm
by ahmed7
Hello
I want to filter my data according some filters criteria together(OR not AND) to make multi selected filters for these three field :
AddFilter(ref filter, "field1= '" + CurrentUserInfo("Project_Id") + "'" ) ;
AddFilter(ref filter, "field2= '" + CurrentUserInfo("Project_Id") + "'" );
AddFilter(ref filter, "field3= '" + CurrentUserInfo("Project_Id") + "'" );
but nothing view , if I make each one alone so will be ok to view data , and made (or) between them but it will be error there
Is there any way to make filters correct for multi selection ?
I use v21 not v22 to make multi selected userid security (1,2,3..) so I use this way.
And I hope there is any simple way to make these three fields (single multi selected field) to make one field have data(1,2,3..) filter with user information.
Thanks
Re: filter data (v2021)
Posted: Thu Mar 09, 2023 7:11 am
by MichaelG
You can simply construct your filter with the OR condition:
AddFilter(ref filter, "field1 ... OR field2 ... OR field3 ...");
Re: filter data (v2021)
Posted: Thu Mar 09, 2023 11:07 am
by ahmed7
So if want to make many field in current user information will be like this too?
AddFilter(ref filter, "field= '" + CurrentUserInfo("info1 OR info2 Or info3") + "'" ) ;
Re: filter data (v2021)
Posted: Fri Mar 10, 2023 7:03 am
by MichaelG
No, you need to build one by one:
AddFilter(ref filter, "field= '" + CurrentUserInfo("info1") + "' OR field = '" + CurrentUserInfo("info2") + "' OR field = '" + CurrentUserInfo("info3") + "'") ;
Re: filter data (v2021)
Posted: Fri Mar 10, 2023 8:37 am
by ahmed7
so is there any way to make filter with user info field have multi selected data(1,2,3...) instead of making three field in v21?
Re: filter data (v2021)
Posted: Fri Mar 10, 2023 10:41 pm
by ahmed7
so is there any way to make Advanced Security with user ID Field have multi selected data(1,2,3...) instead of making three field in v21?
Re: filter data (v2021)
Posted: Fri Mar 10, 2023 10:56 pm
by ahmed7
MichaelG wrote:
No, you need to build one by one:
AddFilter(ref filter, "field= '" +
CurrentUserInfo("info1") + "' OR field = '" +
CurrentUserInfo("info2") + "' OR field = '" +
CurrentUserInfo("info3") + "'") ;
it work for first field only and show the others
Re: filter data (v2021)
Posted: Sat Mar 11, 2023 2:49 am
by ahmed7
ahmed7 wrote:
MichaelG wrote:
No, you need to build one by one:
AddFilter(ref filter, "field= '" +
CurrentUserInfo("info1") + "' OR field = '" +
CurrentUserInfo("info2") + "' OR field = '" +
CurrentUserInfo("info3") + "'") ;
it work for first field only and show the others
work fine now