Skip to main content ↑ ↓
Topic: Use ActiveUser.id in Where (Read 2211 times) previous topic - next topic

Use ActiveUser.id in Where

I use the User Records Management. My Problem is that the Select Field Shows everything in the Database. So i think that i must Control the USERID in the OptionListDataSource. But how can i get the Activeuserid in the Where?


Example:


SELECT  DISTINCT Kurzname AS value,Kurzname AS label FROM arbeitgeber where USERID = 'ActiveUser.id ????

Re: Use ActiveUser.id in Where

Reply #1 –
Please use the defined constant USER_ID.

SELECT  DISTINCT Kurzname AS value,Kurzname AS label FROM arbeitgeber where USERID = USER_ID

ActiveUser.id is for the client side

Re: Use ActiveUser.id in Where

Reply #2 –
Thank You Emman . It Actually Helped me in My Problem.