SQL Query showing different results

SQL Query showing different results

I am working on a project. I have to develope a pop-up web screen that uses drop down to select users and add them to the application. I am done with this. The problem is that i am using SQL query to fetch the list of users from USER table to show in the combo box. The query is giving the right results in the test but when i run the application. The combo box is inflated with the totally different result. My application's espace is not multi-tenant. I can't figure out where is the issue.

The user provider is the provider that is shown in the eSpace properties:

Queries you are testing are tested with the tenant / user provider that is configured via menu Module / Configure Tenant to Test Queries. If the Tenant listed there is different from the User Provider (or the Effective User Provider as shown in Service Center - but you can probably ignore that) you may get different results.

For my application espace. These both properties are same but the application is showing different data to every user that is logged in. what could be the issue.? same logic is applied but different result.

Regards,

Like Kilian said,

If these two are different, the results in Design time and Run time will possibly be different:

Ok, one more thing: did you sort the Aggregate? Though I would expect the database to present the list the same for each invocation, even if unsorted, it might be it uses different execution plans for different users, sorting the output differently.

As stated here, it seems that to create tenants, you need to build an application.

If your users are really in different tenants (I would check this first), this means that you (your company) probably have already an application to manage tenants and users.

So I would talk to someone to understand why the users are in different tenants, if it makes sense to them to be in the same tenant and if you can change them to the same tenant or someone else has to do it.

And I'm curious... Why your users are in different tenants and why they should all see same data?