Skip to main content
Solved

How to fetch Table name using ViewName.

  • May 27, 2021
  • 1 reply
  • 366 views

praveenpo
Semi-Pro II
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)

View original
Did this topic help you find an answer to your question?

1 reply

Forum|alt.badge.img
  • Varsity II
  • 35 replies
  • 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)


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings