I want to show inactive users for 2 fields only of HR form and remaining all fields should contain active users

ravindranath2
Tera Contributor

I am tryig to use 'user query' before business rule, but getting confused how to restrict to 2 fields to show active and inactive users and remaining all fields where we are referring user table should show only active users. please some one help me out here for the solution.

9 REPLIES 9

Hi Ravindra,



Is there a business requirement that can be met only by writing a query BR on user table? If not then you should remove it and make use of reference qualifiers as it makes more sense in this scenario. What you are trying to achieve here cannot be done using a query business rule as there is no way to identify from where the query is run on the table,


Hi Sanoop,



But this business rule across the system to not see inactive records for other users other than admin, if i deactivate it then other users will wrongly assign the incidents to inactive users and also i need to change the reference qualifiers for all user fields if this is the case.


I would say this is not the correct way to do it. Restricting data access should have been done using an ACL and not using query business rule.


haider3
Kilo Contributor

Hi Ravindranath



I have same issue please let me know if you got the answer.


How to solve the problem of business rule(can we solve it by getting sys_id of the form or any thing else)



Regards,


Haider


durgesh7
Tera Contributor

Hi Ravindranath,


      Use query business rule as you already did along with reference qualifier like allow_inactiveuser =1 only for those field where you need both the users.


        allow_inactiveuser does not exists do it will try to return all the users from user record.



        Let me know if this works.



Regards,


Durgesh