Solved

ABOUT AURENA QUERY

  • 14 March 2022
  • 1 reply
  • 71 views
Mervan
Rank
Userlevel 3
Badge +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 

icon

Best answer by Mervan 14 March 2022, 15:11

View original
This topic has been closed for comments

1 reply

Mervan
Rank
Userlevel 3
Badge +9

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

 

Terms & ConditionsCookie settings