AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
Forums
AUG Forums
Acumatica Generic I...
Generic Inquiry to ...
 
Notifications
Clear all

Questions Generic Inquiry to Show Where GI's are Used in Dashboards

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 3 years ago
4 Posts
3 Users
5 Reactions
2,113 Views
RSS
Brett Clark
Posts: 10
 Brett Clark
Topic starter
October 27, 2023 10:34 am
(@bclark)
Eminent Member
Joined: 4 years ago

Hello! 

Is it possible to track where a GI is being used elsewhere in Acumatica? For example, can we see any dashboard/widget where a GI is behind it? 

I've been tasked with cleaning up our GI list, but I don't want to remove anything that may be powering a widget on a dashboard somewhere. 

Thanks in advance!


Topic Tags
Generic Inquiry widgets
3 Replies
cwomack
Posts: 8
 cwomack
October 27, 2023 3:04 pm
(@cwomack)
Active Member
Joined: 6 years ago

This should get you started.  Create a GI with the table PX.Dashboards.DAC.Widget.  it is messy but it works.

We added the following formula to pull out the GI numbers. 

=Substring([Widget.Settings],InStr([Widget.Settings], '<InquiryScreenID>')+17,8)

If I was to give this to a customer I would clean it up a lot more but for internal usage it's ok. 


Reply
Dianne A and Brett Clark reacted
Brett Clark
 Brett Clark
(@bclark)
Joined: 4 years ago

Eminent Member
Posts: 10
October 27, 2023 4:21 pm
Reply tocwomackcwomack

@cwomack Thank you!


Reply
cwomack reacted
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
October 28, 2023 9:42 pm
(@timrodman)
Famed Member
Joined: 11 years ago

Great formula @cwomack !

Also note that Acumatica 2023 R2 has a new WIDGETS tab on the Dashboards (SM208600) screen which is kind of the opposite of what you're looking for here, but it's related:

image

 

 


Reply
cwomack and Brett Clark reacted
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Unable to Add Field "Unapplied Balance" to Generic Inquiry "Payments and Applications"
    1 year ago
  • Equivalent to Excel Post-Special, "transpose"
    2 years ago
  • Generic Inquiry - Last Modified On Date Change
    2 years ago
  • Generic Inquiry, pulling data from two unrelated sources
    2 years ago
  • Adding Override Contact Info to GI Results
    2 years ago
Topic Tags:  Generic Inquiry (41) , widgets (4) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 135 Online
  • 2,439 Members
Our newest member: Ralph Torres
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

By using this website, you agree to our Terms of Use (click here)

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×