Sergey Kornilov 8/29/2024 | |
Where in the manual did you find addWhere() function? |
P
|
Pietro Arcadio author 8/29/2024 |
Sergey Kornilov 8/29/2024 | |
Correct. Do you see which event you need to use this function in?
|
P
|
Pietro Arcadio author 8/29/2024 |
Yes sure, the same code in a normal table works fine. In sql view no. Tomorrow i'll can post other screenshot |
Sergey Kornilov 8/29/2024 | |
Got it, I thought you were adding this code to After Successful login event. This addWhere() function doesn't make much sense in SQL Views where you can have just any kind of SQL query like a stored procedure call. It only makes sense when you use a regular table. What you can try though is SQL variables: |
P
|
Pietro Arcadio author 9/24/2024 |
Hi, sorry for the late reply. I solved it as you told me with sql variables. I created a session variable at login and put it in the WHERE clause in the source page SELECT Thanks for the help |