Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Eliminate Created_bu user from User auto complete

SOLVED
Go to solution
Highlighted
Fergal Kavanagh
Occasional Advisor

Eliminate Created_bu user from User auto complete

Hi,

I want to eliminate the user that is in the process of creating a request (not yet submitted) from being in a validation to select a user to approve. Any ideas?

I have tried allready modifying the PPM - User Id - Enabled validation and then adding an extra filter to the SQL

and user_id =! '[REQD.CREATED_BY]'

and many other variables of the same thing. The error i am getting is -


One of the tokens in the validation was unparseable. This can be caused by an invalid token name or missing data from the field the token represents. (KNTA-10073)

SELECT user_id, full_name, username, department_meaning, email_address FROM knta_users_v users WHERE ( UPPER (first_name) LIKE UPPER (? || '%') OR UPPER (last_name) LIKE UPPER (? || '%') OR UPPER (full_name) LIKE UPPER (? || '%') OR UPPER (username) LIKE UPPER (? || '%') ) AND NVL (end_date, CURRENT_DATE) >= CURRENT_DATE and user_id =! '[REQD.CREATED_BY]' ORDER BY full_name




Any thoughts?? Thanks a million

Fergal
3 REPLIES
Semenov Alexand
Esteemed Contributor

Re: Eliminate Created_bu user from User auto complete

Hi.
Try this [P.CREATED_BY]
Tim Brandish
Frequent Visitor
Solution

Re: Eliminate Created_bu user from User auto complete

I don't think that REQ.CREATED_BY will work since it isn't created yet. You need to use [SYS.USER_ID] since it is the user_id of the logged in user.
Fergal Kavanagh
Occasional Advisor

Re: Eliminate Created_bu user from User auto complete

Thanks Tim. Did the job.
//Add this to "OnDomLoad" event