How to use Ui macro and call it in a widget for dashboard

[Christy Anusha]

Hi , 

I have a requirement to use UI macro and call it in a widget to have a drop down values from a database table and based on the selection of choice report has to be refreshed, Please any one help me with the script.

[Sanjay Bagri1]

H Christy,

Please can you go to this blog  link ,sure this link will help you;

UI Macro in ServiceNow

Please mark as a correct and also helpful if it is helping to you. So others will be benefited to same threads.

Thanks

Sanjay Bagri

Dxsherpa.com

[Adam Stout]

What is it you are trying to achieve?  Why do you need to create a new widget?  If we can avoid creating custom code, we should.  It there an OOTB solution that would work for you?

[Christy Anusha]

we are trying to achieve using ui macro since we don't have Performance Analytics permission.

my scenario is to have a choice field (drop-down) from a database table, and based on selection of choice the report which is in dashboard has to be refreshed.