XSOdata with calculation view

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers

Skip to Content