Skip to main content
Answer

How to fetch Table name using ViewName.

  • May 27, 2021
  • 1 reply
  • 394 views
praveenpo
Semi-Pro III
Forum|alt.badge.img+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)?.


 

Best answer by jknauf

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)

Praveen

    1 reply

    J
    Varsity II
    Forum|alt.badge.img
    • jknauf
    • Varsity II
    • Answer
    • May 28, 2021

    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)

    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    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