asked 1 day ago
Hi,
We are trying to retrieve oracle db query result by using flexmonster dataserver as dll and .net core. We have created db table
based on username like Y_UserName_Table. We already integrated SSO in our .net project and could retrieve username easily. Would it be possible to retrieve result based on username and without adding multiple index?
For eq:
We added index2 for oracle database and added query Select * from Y_UserName_Table
builder.Services.Configure<DatasourceOptions>((options) => {
options.Indexes = new Dictionary<string, IndexOptions>();
options.Indexes.Add("Index2",
new DatabaseIndexOptions("oracle", "Data Source=ALG02A;User Id=RISK;Password=****;", "Select * from Y_UserName_Table"));
});
What we want if user A tries to access api it loads result for table Y_A_Table and for user B it loads result of table Y_B_Table
Thanks,
Varun
⋅ 1 day ago
Hello, Varun!
Thank you for reaching out to us.
Kindly note that showing different data for different users is possible by implementing server-side filters. We have the example of server-side filters implemented in our Data Server as DLL sample project.
Our team recommends using the following guide as an entry point to read about server-side filtering: https://www.flexmonster.com/doc/getting-started-with-data-server-dll/#role-based-access-to-data-using-a-server-filter.
Hope you will find our answer helpful.
Kind regards,
Solomiia
