Variables not showing up on dashboard - gauge

[tobrien]

Howdy Folks,

As an Admin I created a REPORT based upon the CATALOG TASK table (sc_task.) The CONDITIONS select one particular type of TASK, and the items to be listed are a mixture of fields found in the SC_TASK table (i.e. NUMBER) and those found as Variables of a CATALOG REQUEST (i.e. SHIPPING REQUEST.Customer)

The problem is that I see ALL the selected items in my dashboard gauge associated with this report.

And anyone NOT an admin sees only the "NUMBER" column as if the 'variables' are somehow being restricted via an ACL.

How do I get the Variable Items to get listed for non-admins?

Thanks!

[sourabhd87]

I think you should give the access to users on the item_option_new and sc_item_option_mtom table. Not sure if that will work but I think this is what restricting the non-admins from viewing the variables.

Kind regards,

Sourabh D

[tobrien]

Thanks, Mr. D but that did not seem to help ...

This is a screen shot of the new READ control I added to both tables mentioned... in case you meant something different than what I did.

[tobrien]

And I just added the USER role to these but still no joy :<

[tobrien · Accepted solution]

The Real Answer is to give ITIL or PUBLIC role READ access to

sc_item_option

item_option_new

sc_item_option_mtom

Then the gauge starts showing the Variable-based columns on the User's dashboard.

Thanks to Mr. Dhaygude for starting me down the wryte path.