Skip to Content
0
Jul 23, 2016 at 09:33 PM

HANA XSA: View does not retrieve data from table

60 Views

Hi Colleagues,

I created a view which should retrieve data from a table, whenever I insert data through my application which calls a stored procedure, the view does not retrieve this data eventhough I find it in the table. If I insert data manually from the database itself, the view retrieves this data.

My code is below:

context Todo {


    Entity TodoEntry {
        key Id:                         Integer;
        Description:                    String(256) not null default '';
        ValidFrom:                      Timestamp not null;
        ValidTo:                        Timestamp;
        CreatedBy:                      String(256) not null;
    };


    View UserEntries as Select from TodoEntry {
        Id,
        Description,
        ValidFrom,
        ValidTo,
        CreatedBy
    }  with structured privilege check;


};


I would appreciate any ideas.

Thank you,

Best Regards,

Shady