Searching for Constraints?

Tridus Aug 23, 2013 1:19 PM

Hi. Just downloaded the 4.0 release version. Trying out the new search tool, it seems to be able to find everything (tables, columns, indexes, synonyms, etc) except for constraints. I see there's a Constrant option in the list of things to search, so I find it odd that searching for one exactly by name (copied from the "Constraints" tab of a table list so I know it exists) doesn't find anything. All schemas are checked to search.

Is there an issue with that one?

Thanks.

1. Re: Searching for Constraints?

thatJeffSmith-Oracle Aug 23, 2013 1:51 PM (in response to Tridus)

Constraints isn't an option under 'All Object Types' - where are you seeing constraints listed as a search option?
Like Show 0 Likes(0)

Actions
2. Re: Searching for Constraints?

Tridus Aug 23, 2013 1:55 PM (in response to thatJeffSmith-Oracle)

Err, you're right. I misread something earlier. Sorry.
Like Show 0 Likes(0)

Actions
3. Re: Searching for Constraints?

thatJeffSmith-Oracle Aug 23, 2013 2:01 PM (in response to Tridus)

Now, that doesn't mean we can't add it going forward!
Like Show 1 Likes(1)

Actions
4. Re: Searching for Constraints?

Tridus Aug 23, 2013 5:20 PM (in response to thatJeffSmith-Oracle)

That'd be helpful. It's one of the things I need to try and find when an error turns up with some obscure constraint violation.
Like Show 1 Likes(1)

Actions
5. Re: Searching for Constraints?

thatJeffSmith-Oracle Aug 23, 2013 6:13 PM (in response to Tridus)

In the meantime, you could put together a code snippet for user defined report that did the constraint lookup for you...for the report, you could even have it pull up with a link to the table it's attached to.
Like Show 0 Likes(0)

Actions

Go to original post