Andy Vanspranghe
- Total activity 8
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 4
Activity overview
Latest activity by Andy Vanspranghe-
Andy Vanspranghe commented,
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...
-
Andy Vanspranghe commented,
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
-
Andy Vanspranghe commented,
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...
-
Andy Vanspranghe commented,
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...