How do I locate the SQL behind the Pivot Table?

  • 16 April 2024
  • 1 reply


Is there any way to get the SQL running behind the Pivot table? 

Also, if I have a SQL Script, how can I get the PIVOT to be created from that SQL?


Best answer by BenjaminCrisman 16 April 2024, 16:16

View original

1 reply

Userlevel 7
Badge +4

@abhijit To see the results of the query you can run the pivot and check the trace, this usually has the query generated for the results set seen. You can also navigate to Request Profiler screen and turn on the logging, then run the pivot again and check the results from Request Profiler, this is pretty thorough.

From there if you want to use this query you’ll need to incorporate a customization, maybe a custom table or set of tables which can be used to generate a pivot, or maybe it could be done with SQL views (not really my area of expertise).


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved