Forum Discussion
How to send USERPRINCIPALNAME to dynamic query to return results based on logged in user
Hi, I have a requriement to show data based logged in user. The logged in user (USERPRINCIPALNAME) need to be passed to query as a parameter user_id to the backend direct query. Data is huge cannot...
muhssamy
Resolver I
Resolver Iyes. dont import your table. and dont use dynamic query. just create a table contains IDs and use it also in import mode and let the relationship do the filtrations
something like the following image
USERPRINCIPALNAME() will filter the dimention that will have a join in your database with the right id
This solution didn't work. Not sure If I am missing anything. Can you please provide more details.