Skip to main content
Solved

ABOUT AURENA QUERY

  • March 14, 2022
  • 1 reply
  • 84 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

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

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

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings