Use Session.UserId in query condition

Use Session.UserId in query condition

How can i use Session.UserId in query condition. Eg

I have a query 
select * from XYZ where xyz.userId = Session.UserId (outsystem provided.)

i am not able to join the System table User with Entities table
Hi Navratn,

In order to use Session.UserId in a query you need to pass it as a parameter to that query.

Have you take a look at our training materials? I suggest you see this video at about 4:55 you'll see how to create a parameter in a simple query.


Thanks a lot Andre. It helped