Hello,
I have an issue where I created a query that returns the data as I want it to return it.
When I link the query and create a gadget and then place it into the dashboard, it returns no data.
I worked it out as why. There is a custom filed created in the AUTILIS table, it stores the default site.
My view pulls the data based upon the site as well.
Idea is that I link the global variable GUSER to the AUTILIS table using following link [F:AUS]USR=GUSER
This works great in the query itself but when dashboard is refreshed, it returns no data, as soon as I remove this selection, it work fine but it does not do any filtering on data based upon the current user logged in.
Anyone had similar issues?
Thanks
Ranko