Search, object search not returning data

Toad for Oracle & DevOps Toolkit
1

Is anyone else having issue with data being returned with release 2025 R2 patch1? I can perform the same object search with 2025 R1 and data is returned. I am using the same database and same search options.

2

I have not heard of any such problems, but I'll need more info to fix.

Turn on the spool SQL in each and perform the same search. If it runs different queries, please post them here.

3

See attached for both sql files.

In version 2025R1, data is returned, but in 2025R2patch1, no data is returned to the screen.

Let me know if you need more information.

Thanks,

Daniel

(attachments)

Debug2025R2Patch1.SQL (6.08 KB)
Debug_2025R1.SQL (6.09 KB)

4

I see that the queries are the same, and the first one (which is a big UNIONed query) returns two rows.

So I guess the question now is - why does 2025R2 not show the query result.

Can you also post screen shots of the search window options and results in 2025R1?

Also, in 2025R2 - make sure that you don't have any filters set in the result grid.

Thanks

5

I see my previous email was returned with the message, “We're sorry, but your email message to ["incoming+ca25c896e9847439d177468a1682c174@quest.discoursemail.com"] (titled RE: [Toad World® Forums] [Toad for Oracle & DevOps Toolkit] Search, object search not returning data) didn't work.

Reason:

Sorry, new users can only put one embedded media item in a post.

If you can correct the problem, please try again.”

So sending again with one screen shot .

I see down below in 2025R2Patch1, the bottom of the screen says 2 objects found, but I don’t see them showing in the panel.

image004.png836×908 26.9 KB

Daniel

6

Ah! Your result grid is filtered to Package Bodies.

See the little blue funnel icon in the "Object Type" column header? You must have clicked there previously when looking through search results, and the grid remembered it. And now you are searching for something else (I'm guessing a sequence based on what I saw in your spool sql), and it's getting filtered out of the result.

You can also see that a filter is set by looking under the grid - where it says "Object type = PACKAGE BODY". That would not be there if there were no filter.

Click the red X to clear the filter.

image
image1526×1668 265 KB

Maybe it's not a great idea that this grid remembers filter settings (that's on us, not you) but now you know.

Also, I increased your "trust level" in the forums, so hopefully you can post more than one image next time.

7

THANKS so much. Glad it was so simple.

I don’t even remember using a filter.

1 Like