Andy Vanspranghe

Member since October 12, 2020 06:30

Total activity 8

Last activity September 19, 2022 13:42

Following 0 users

Followed by 0 users

Votes 0

Subscriptions 4

Activity overview

Latest activity by Andy Vanspranghe

Andy Vanspranghe commented, September 19, 2022 13:42
Using AND instead of WHERE indeed allows me to add a simple condition. The one with dynamic syntax still doesn't work, but you mentioned this. I do need this to allow dynamic security, based on the...
- View comment
- September 19, 2022 13:42
- 0 votes
Andy Vanspranghe commented, September 19, 2022 13:29
By the way, could you tell me which tool you use to see the SQL? I have been looking for something like this for a long time. Is it included in B1UP? Thx Andy
- View comment
- September 19, 2022 13:29
- 0 votes
Andy Vanspranghe commented, September 19, 2022 13:28
Hi Rasmus, My WHERE clause is a bit more complicated :) WHERE "U_BU"||'/'||"U_DeptCode" IN (select "AccessCode" from UNI_V_FIN_BUDGET_SECURITY where "UserCode"= (SELECT T0.USER_CODE FROM OUSR T0 WH...
- View comment
- September 19, 2022 13:28
- 0 votes
Andy Vanspranghe commented, September 15, 2022 08:21
Hi Matthew, I have a similar business case where I would like to filter some data for security reasons (input screen for budgets, which need to be filtered based on the departments the user has acc...
- View comment
- September 15, 2022 08:21
- 0 votes