Solved

How to fetch Table name using ViewName.

  • 27 May 2021
  • 1 reply
  • 315 views

Userlevel 6
Badge +3

Hi,

I’m using ScreenInfo to store all the screen details to custom table.Able to get ViewNames and fields but unable to get Table name for the respective views.
Is there a way to fetch table name using ViewName or any other way to get all the screen details(Tables,ViewNames and fields)?.


 

icon

Best answer by jknauf 28 May 2021, 19:27

View original

1 reply

Userlevel 3
Badge

Well a view is often several tables joined together, so they usually don’t have a 1-1 relationship with tables. Are you looking for the type of a view? You can get that using: View.GetType()
Or if you’re looking for the name of a PXCache you can use the static method: GetItemName(PXCache)

Reply


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