Find Database Objects - Additional Filter for objects to search for

[SaKa]

Hi,
I use the "Find Database Object" under Tools menu a lot and its great tool. Is there any way I can add in extra condition to limit the search of Objects please? At present we can specify "Name" with % etc to limit the number of objects to search for, can we use additional criteria to select objects ?

we have loads of packages for example and we group packages by category and its maintained in a table. We like a way to use this table to cut down the number of objects to search for. Is that at all possible please?

Thanks
Sak

 

[Marco Kalter]

No, this is currently not possible. The filter is restricted to the properties on the form, and you cannot use subqueries or function calls there.

I have added this to the list of enhancement requests.

 

[Maxmix]

I think, 'Browser filter' criterion does just that. You can define browser filters with an arbitrary query.

 

[Maxmix]

I think, 'Browser filter' criterion does just that. You can define browser filters with an arbitrary query.

 

[Maxmix]

 

[SaKa]

Hi Maxim,
Do we have any examples or any documentation on how to use Browser filter please? Never used it but interested to see what possibilities it gives us.

Thanks
San

 

[Maxmix]

SaKa,
It does just that : limits db objects by adding conditions to queries, searching within the metadata.

We can use any columns from ALL_OBJECTS view, e.g.

owner in ('BESTSCHEMA', 'OURUTILS') and object_name not like 'TMP%'

Something like this.