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