Skip to main content
Solved

ABOUT AURENA QUERY

  • March 14, 2022
  • 1 reply
  • 94 views

Mervan
Sidekick
Forum|alt.badge.img+9

Hi,

I have one question. How can I find the user id in aurena?  

When I type the following query in the IFS EE10 lobby, the user can only see their own data. Aurena not seeing data in lobby.  How can I find the user id in Aureana

 

…………AUTHORIZE_ID IN (SELECT PERSON_ID FROM &AO.PERSON_INFO_ALL WHERE USER_ID=USER)

best regards 

Mervan 

Best answer by Mervan

hi,

I wanted to share with you the problem.The query worked when I wrote the following parameter instead of user_id. 

 

“SELECT PERSON_ID FROM &AO.PERSON_INFO_ALL WHERE USER_ID=&AO.USER_ACCESS_API.Get_User”

 

best regards

MERVAN

 

This topic has been closed for replies.

1 reply

Mervan
Sidekick
Forum|alt.badge.img+9
  • Author
  • Sidekick
  • 44 replies
  • Answer
  • March 14, 2022

hi,

I wanted to share with you the problem.The query worked when I wrote the following parameter instead of user_id. 

 

“SELECT PERSON_ID FROM &AO.PERSON_INFO_ALL WHERE USER_ID=&AO.USER_ACCESS_API.Get_User”

 

best regards

MERVAN