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
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
Hello, Varun!
Hope you are doing well.
Our team is wondering if you had some time to check the provided examples of implementing server-side filters using Data Server as DLL. Could you please let us know if you have any further questions?
Looking forward to hearing from you.
Kind regards,
Solomiia
Yes, it worked. Thanks for your help. You can close the ticket
Hello, Varun!
Thank you for your feedback.
We are happy to hear our response was helpful.
Do not hesitate to reach out to us if any other questions arise.
Kind regards,
Solomiia