Combine of flags

[beck_bakytbek]

Hi Folks,

i am facing with issue, where i have the following Problem:

i created 2 flags within my scriptarea, for instance:

if(flagtest = 1, 'active', 

if(flagtest = 2, 'not active','')) as MyFlag.

and it does work great, but Question is, how to Combine These 2 flags into one like: All, my expected Output is:

MyFlag consists of 1, 2 and ALL (where ALL = 1 + 2)

Does anybody have any idea how to resolve this issue?

thanks a lot in Advance for any responses

Beck

[dplr-rn · Accepted solution]

You mean you want the users to have the ability to select ALL and have both Active and Not Active?

Isnt that same as not selecting?

But if its mandatory. maybe create a supplementary table like below and use that for selection

MyFlag	SelectionColumn
Active	Active
Not Active	Not Active
Active	All
Not Active	All

[beck_bakytbek]

Hi Dilipranjith

thanks  a lot for your responce and help

[dplr-rn]

no problem. mark as answered and close the thread please