Update query

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