This forum is now out of date, for our new forum Click Here
Source filters - ignore for admins?
Question Asked
Hi,

I've got source filters working well - restricting to a certain users "company".

Is there any way to remove the restriction for certain users. e.g. top managers should be able to see all companies..

(Other than creating a copy of the view, and having different view permissions and removing the source filter)

Thanks,
Dan

Dan

Fri Oct 19, 2012 12:10 AM

Answer
Hi Dan,

We do currently support source filter 'Wildcards' however a DB modification is needed to support this feature.
Please note, this will change in the future, though for Yellowfin 6.1 , this method is the only way to get it working.

1. Run the query below against your Yellowfin DB
Please make sure Yellowfin is not running
insert into configuration (iporg, configtypecode, configcode, configdata) values (1, 'SYSTEM', 'SOURCEFILTERWILDCARD',
'%'
)

In the above example
%
is the wildcard. Please take note of this.



2. Startup Yellowfin and create your source filter as normal , however for the filter value, use %
E.g.



Please let me know if you have any issues with this.

Regards,
David

David

Fri Oct 19, 2012 9:13 AM

Comment
Thanks, that works a treat.

Dan

Tue Oct 23, 2012 12:39 AM

Comment
Have source filter wildcards been included in 6.3, or does the above still apply?

Ian

Thu Nov 28, 2013 2:12 PM

Comment
Hi Ian,

Source filter wildcards have not been included in 6.3, so you've definitely still got to do the above insert query.

regards,
Dave

David

Fri Nov 29, 2013 7:59 AM

Comment
David - What does this do to the SQL generated? Does it add the wild card or does it simply omit the where clause all together?

Nicholas

Thu May 15, 2014 2:08 AM

Comment
Hi Nicholas,

When using the wildcard for the Access Filter, the where clause is omitted.

Below is an example of the SQL generated for both examples



Please let me know if this is what you were after

Regards,
Stephen

guest

Thu May 15, 2014 6:49 PM

Comment
That's it. Thanks. I'm thinking about using web services to pull a list of users in a certain YF group and using this method to eliminate the access filter. Our key is a version key of a location and has grown to over 20,000 records. Needless to say, an admin user's where clause in reports is looking quite horrible at the moment and performance is suffering.

guest

Sat May 24, 2014 4:50 AM

Comment
That guest was me in the above post. Forgot to login. Thanks again.

Nicholas

Sat May 24, 2014 4:51 AM

Comment
Is the database insert into the config table still needed for YF7.1 to enable wildcards in access filters?

Mark

Mon May 25, 2015 1:46 PM

Comment
Hi Mark,

Source Filter Wildcards have still not found their way into the application. Sorry for the bad news.

Regards,

Kyle

Kyle

Thu May 28, 2015 5:43 AM