lookup to display user's own information

[Legacy User]

Hello everyone,

 

i want to create a lookup that should display only my name if i click on that, in general whoever clicked on it to see the resource/user name it should show only their name. i had planned to try this with Dynamic niku query, this never looked very easy for me as i am not getting the right data/option/table info for it.

any help/suggestion/guidance will be much appreciated.

 

Thanks

Daya

[Sridhar Bandaru]

In your Dynamic Query Lookup, you may use below construct which provides logged in user id to apply filtering:

            @WHERE:PARAM:USER_ID@

[Legacy User]

HI Sridhar

 

Thanks a lot. This is working fine for me.

This is just an awesome solution. i was thinking about finding the session related tables and all.

Thanks again. Have a great week end.

 

Thanks

Daya

[Legacy User]

HI Shridhar,

i am facing one more issue in continuation to the same issue from today.

if i select my name for this look up that has been assigned to one field. when other user logged in and see that field it shows their name already selected for that field.

the requirement is only to select the their name for that particular look up/ but here its so happening that if any user select his name , the other user who logged in will see their name selected for this field.

Please suggest me if i made any wrong settings.

[Sridhar Bandaru]

Is it possible for you to share lookup NSQL?

[Legacy User]

SELECT @SELECT:u.id:user_id@,
@SELECT:u.USER_NAME:UNIQUE_CODE@,
@SELECT:r.id:resource_id@,
@SELECT:r.first_name:first_name@,
@SELECT:r.last_name:last_name@,
@SELECT:r.full_name:full_name@,
@SELECT:r.person_type:person_type_id@
FROM srm_resources r,
cmn_sec_users u

WHERE u.id = r.user_id
AND u.id=@WHERE:PARAM:user_id@

[Sridhar Bandaru]

Just to solve the said problem, you may try below query. 

 

SELECT @SELECT:u.id:user_id@,
@SELECT:u.USER_NAME:UNIQUE_CODE@,
@SELECT:r.id:resource_id@,
@SELECT:r.first_name:first_name@,
@SELECT:r.last_name:last_name@,
@SELECT:r.full_name:full_name@,
@SELECT:r.person_type:person_type_id@
FROM srm_resources r,
cmn_sec_users u

WHERE u.id = r.user_id
@BROWSE-ONLY:
AND u.id=@WHERE:PARAM:user_id@
:BROWSE-ONLY@

 

But if you want the same field to be appearing in Object list filter view where it should show all resources, then you may actually enhance the lookup to be parameterized to map to object instance. 

[Legacy User]

Hi Shridhar

 

its giving me NPT-0102: NSQL statement must define at least one dimension. error.

i am also trying my best to figure this out. Please suggest if you see  any solution.

thanks

Daya

[Sridhar Bandaru]

This is not expected, after all, we just added Browse only construct. Does the error go away if you remove that construct?

 

By the way, though it is not related to the error, please add @FILTER@ to the query.

[Legacy User]

Yes Shridhar. you are right. this is working perfectly.

thanks a lot for your time on this. this saved my effort and frustration:)

thanks again and have a great weekend.

Thanks

Daya