Active Query Builder support area

Displaying tables/views in a folder

Avatar
  • updated
  • Completed

I'd like to display some objects in "folders" for users so they can easily be found. Basically the server layout of the objects does not match what I'd like to display to the user.

 I've tried using Packages for this purpose, but this affects the NameFull property.

E.g. I have a view called MyView in a schema MySchema.

The query name for this should be:

"MySchema"."MyView"

But if I put it in MyPackage1->MyPackage2 (nested packages) the full name is

"MyPackage1"."MyPackage2"."MyView"

 

Is there a way to override the NameFull so that the layout of the object tree doesn't match the namespaces of the objects? Or is there something else I could do?

 

(Hope that makes sense!)

 

Thanks, Colin

Avatar
Colin Overton

I didn't know about that functionality, thanks so much for pointing me to the right part of the docs!

Avatar
Andrey Zavyalov, PM

Hello, Colin.

Thank you for your question.

You mustn't change objects in the Metadata Container, otherwise, the component won't be able to correctly generate SQL queries and detect them in SQL query text. 

Instead, use the Metadata Structure facility that was made exactly for this purpose. You can read more about in in this article: https://support.activequerybuilder.com/hc/en-us/articles/115001055289-Customizing-the-Database-Schema-Tree-structure