Hello.
I need to define only active employees for employees which authorized to add and edit employees.
Via Web Designer in configure project I specify custom value with next web sql condition:
EXISTS (select 1 from (select uid_person from personinaerole where exists (select 1 from (select UID_AERole from AERole where Ident_AERole = 'Specialist SC') as x where x.UID_AERole=personinaerole.uid_aerole)) as X)
With that condition Employees with AERole = Specialist SC can see (edit) all employes in One Identity.
I try to extend my condition and wright something that: "and IsInActive = 0" but it's wrong.
How can specify to display only active employees and temporary disabled employees for employees with AE role = SpecialistSC?