XSOdata with calculation view

May 12, 2017 at 02:43 PM


avatar image

I'm trying to expose a table via XSOdata in which the current user is also the creator.

I created a calculation view

SELECT CURRENT_USER "current user" into lv_user FROM DUMMY;
var_out = SELECT * from TABLE WHERE "UserID" = lv_user;

which works fine (I only see records for myself).

Then I create XSOdata which points to "_SYS_BIC"."VIEW".

The XSOdata returns me all the records (disregarding the conditions above). Moreover it returns the columns which are marked hidden in the calculation view.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers

Skip to Content