How do I use the user’s login name in a Condition
2 July, 2015
Hej,
I am trying to create a View where I want to apply a Condition to the data selected from a Table.
The Condition needs to use the current User's ID, as I want the data returned by the View only to contain records that are directly related to the User, and I do have the User's information in a field in the table I am extracting data from.
So I was hoping for the possibility to have something like:
Create a Dynamic Condition that incorporates " = $USER".
Have looked in vain at results returned by Google, so I am hoping that someone here can provide an answer.
Thanks
/Per
I am trying to create a View where I want to apply a Condition to the data selected from a Table.
The Condition needs to use the current User's ID, as I want the data returned by the View only to contain records that are directly related to the User, and I do have the User's information in a field in the table I am extracting data from.
So I was hoping for the possibility to have something like:
Create a Dynamic Condition that incorporates "
Have looked in vain at results returned by Google, so I am hoping that someone here can provide an answer.
Thanks
/Per
Hello Per,
You can do that with a source filter against the datasource.
When you create the source filter, you can use a SQL Query to populate the list of possible user id's:
select 'USERID', ?USERID?, 'UserId', ?USERID?
This established a source filter with a name of 'UserId' and a value of the current user. Then you can reference that source filter in your view against the table field that contains the UserID.
Here is a link to the wiki that walks you through setting up source filters:
http://wiki.yellowfinbi.com/display/USER71/Source+Access+Filters
Good luck
Giovanni
You can do that with a source filter against the datasource.
When you create the source filter, you can use a SQL Query to populate the list of possible user id's:
select 'USERID', ?USERID?, 'UserId', ?USERID?
This established a source filter with a name of 'UserId' and a value of the current user. Then you can reference that source filter in your view against the table field that contains the UserID.
Here is a link to the wiki that walks you through setting up source filters:
http://wiki.yellowfinbi.com/display/USER71/Source+Access+Filters
Good luck
Giovanni
Thank you Giovanni,
Per, I hope this answers your question but if not, please let us know.
I have also included the link HERE from our Wiki.
Thank you,
Kyle
Per, I hope this answers your question but if not, please let us know.
I have also included the link HERE from our Wiki.
Thank you,
Kyle