Forum

This content is now out of date.

Visit Our Community

RLS Configuration

Hi Team,



Please clarify the below:

1) For SourceFilter setup, I have configured the below SQL query..
SELECT 'UserId', userid, 'FilterType', securitycode from dbo.getSecurityCode({UserId}).

How to use the Yellowfin logged in user id in the DB function?

Please clarify it as soon as possible.

Regards,
Chandrakumar.N.
Hi Chandrakumar,

Thanks for sending in the query. I think you are running into issues because your column names are not adhering to the strict naming convention required to run a scheduled SQL query. Each of the column names should be:

Identifier Type
Identifier
Reference Type
Reference Id

For example:

Forum image


This is outlined in the below forum article:

Creating a Source Filter using Schedule SQL Query

Also, here is some information on our wiki pertaining to this subject:

Access Filters

Can you review this information and let us know if it helps solve your problem? Either way I look forward to hearing back. Have a great day!

Kind Regards,

Dustin




Hi Dustin,

Thanks for the response.

In my case, in order to get the filter value (i.e: to get identifier), I need to pass the current Yellowfin login UserId to the stored procedure to get the filter value.

So how can I pass the Yellowfin login user name when giving SQL query for Access filters.

Regards,
Chandrakumar.N.
Hi Chandrakumar,

Apologies if I misunderstood your original question. Have you had a chance to review the below forum post:

Passing a User ID to a Stored Procedure

The post outlines the process that can be used to set up a Source Filter that will pass the current user's User ID as one of the parameters to the procedure.

Is this what you are after?

Kind Regards,

Dustin

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.