Print Thread
Find Database Objects - Additional Filter for objects to search for
#58408 10/05/18 03:57 PM
Joined: Nov 2016
Posts: 92
S
SaKa Offline OP
Member
OP Offline
Member
S
Joined: Nov 2016
Posts: 92
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

Re: Find Database Objects - Additional Filter for objects to search for
SaKa #58412 10/06/18 09:02 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
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.


Marco Kalter
Allround Automations
Re: Find Database Objects - Additional Filter for objects to search for
Marco Kalter #58413 10/08/18 04:48 AM
Joined: Mar 2011
Posts: 237
Russia
Member
Offline
Member
Joined: Mar 2011
Posts: 237
Russia
I think, 'Browser filter' criterion does just that. You can define browser filters with an arbitrary query.


Best regards,
Maxim
Re: Find Database Objects - Additional Filter for objects to search for
Marco Kalter #58414 10/08/18 04:48 AM
Joined: Mar 2011
Posts: 237
Russia
Member
Offline
Member
Joined: Mar 2011
Posts: 237
Russia
I think, 'Browser filter' criterion does just that. You can define browser filters with an arbitrary query.


Best regards,
Maxim
Re: Find Database Objects - Additional Filter for objects to search for
Marco Kalter #58415 10/08/18 04:48 AM
Joined: Mar 2011
Posts: 237
Russia
Member
Offline
Member
Joined: Mar 2011
Posts: 237
Russia


Last edited by Maxmix; 10/08/18 04:51 AM. Reason: Duplicate post

Best regards,
Maxim
Re: Find Database Objects - Additional Filter for objects to search for
Maxmix #58432 10/11/18 08:54 AM
Joined: Nov 2016
Posts: 92
S
SaKa Offline OP
Member
OP Offline
Member
S
Joined: Nov 2016
Posts: 92
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

Re: Find Database Objects - Additional Filter for objects to search for
SaKa #58437 10/12/18 02:29 AM
Joined: Mar 2011
Posts: 237
Russia
Member
Offline
Member
Joined: Mar 2011
Posts: 237
Russia
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.
SQL Query
owner in ('BESTSCHEMA', 'OURUTILS') and object_name not like 'TMP%'

Something like this.



Best regards,
Maxim

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.041s Queries: 14 (0.012s) Memory: 2.5244 MB (Peak: 3.0424 MB) Data Comp: Off Server Time: 2024-05-18 21:26:13 UTC
Valid HTML 5 and Valid CSS