How to filter out disabled users via designer

Hi,

You can update the existing where clause for "Employees which can be edited by the current user":

Select Edit | Configure project | Web project...

From the Configure project tab, expand "Employees" and enable the "Value (custom)" option.

Trevor

Hi Trevor,

I can see there is standard sql condition mentioned but unable to get what it means exactly, Can you please help me out what exactly is userid in below query?

"uid_person in ( select uid_person from QER_VEditEmployee where uid_personhead = '%useruid%')"

so that it could be easy enough for me to modify the appropriate SQL condition

Hi Trevor,

I can see there is standard sql condition mentioned but unable to get what it means exactly, Can you please help me out what exactly is userid in below query?

"uid_person in ( select uid_person from QER_VEditEmployee where uid_personhead = '%useruid%')"

so that it could be easy enough for me to modify the appropriate SQL condition

%useruid% is the UID_Person of the currently logged-in user.

Thank you so much Markus, I am trying to remove inactive employees from direct reports in IT shop and I have added th below conditions in Web Designer - Employees -> EMployees authorized to add and edit employees and Employees which can be edited by current user

Employees authorized to add and edit employees:

exists( select 1 from person p join PersonInAERole pir on pir.UID_Person = p.UID_Person join AERole r on r.UID_AERole = pir.UID_AERole where p.IsInActive = 0 and Ident_AERole = 'Employee Managers' and p.UID_Person = Person.UID_Person )

Employees which can be edited by current user

(

uid_person in (select uid_person from QER_VEditEmployee where uid_personhead = '%useruid%'

or

exists ( select 1 from PersonInAERole where UID_Person = '%useruid%' and UID_AERole in (select UID_AERole from AERole where Ident_AERole = 'Employee Managers') )

)

and

IsInActive = 0

But still I cannot see any changes reflected in IT shop, requesting your help if I am performing changes at the current place and or if the query is incorrect.

Appreciate your help in advance!

If you are talking about the Tile on the start screen, then you need to change this where clause here (I think).

Thank you so much for replying Markus. I will check this and give it a try.

Hi Markus,

I have tried to change the where clause by adding a new property but still it shows me all the users (active and inactive) on the direct reports tile on the dashboard.

below is the condition I have used:

format("uid_person in (select uid_person from QER_VEditEmployee where uid_personhead = '{0}' and UID_OrgRoot = 'Person' and IsInActive = 0)",GetUser())

Shouldn't the condition look like

format("uid_person in (select uid_person from QER_VEditEmployee where uid_personhead = '{0}' and UID_OrgRoot = 'Person') and IsInActive = 0)",GetUser())

Yes Markus, that also isn't helping no change in the direct reports tile even after compiling database.

format("uid_person in (select uid_person from QER_VEditEmployee where uid_personhead = '{0}' and UID_OrgRoot = 'Person') and IsInActive=0)",GetUser())

Hmm.. maybe there is something wrong with your extension but I am no WebDesigner expert. Maybe someone else is able to jump in here.