☝️Small business or a startup? See if you qualify for our special offer.
+

Update query

Resolved
Varun asked on May 16, 2025

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

4 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 16, 2025

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

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 27, 2025

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

 

Public
Varun May 28, 2025

Yes, it worked. Thanks for your help. You can close the ticket

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 28, 2025

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

Please login or Register to Submit Answer