Object Browser default sort set wrong?

[MjH]

Somehow I have managed to get the object browser to sort objects in descending order, which is (for me) rather annoying. I have checked the Object Browser Folder and Filters and nothing is set there.

The other interesting thing is that it does not do this for certain user accounts. If I log in to a database with my DBA-privileged account then the Object Browser shows objects in the ascending sort.

Is there a preferences setting or something that I may have set accidentally that is causing this?

This is in 12.0.7 - 64 bit.

Thanks in advance...

 

[mike]

On top of the object browser, there is an icon that looks like a funnel filter that defines the browser filters. Open that and there is an order by tab. Most of the native ones have this:

decode(owner, user, 0, 1),
owner,
object_name

In my custom filters, I just have object name. Anyway, you can change the sort for the object filter you are using there.

 

[MjH]

I have checked that. There is only the "All Objects" filter, and it has nothing in either the Where clause or Order by clause boxes.

 

[WexSoft]

Hi MjH, I was just wondering if you have created a custom folder in the Object Browser? The rightmost button of the 6 buttons at the top of the Object Browser window is the Folders button. If you click this you can customise the list of folders, and for custom folders you can set an Order By clause by clicking on the "Order By clause" tab (you cannot set this for system folders).

 

[William Robertson]

The default Order By clause for the 'All objects' browser filter is

decode(owner, user, 0, 1),
owner,
object_name

If you've somehow lost the other filter definitions (My objects, My invalid objects etc) it's easy to add them. I also have some of my own, for example we have a numbering system for related schemas in dev environments so XXX_42, YYY_42 and ZZZ_42 are related (it's kind of a cheap way to host multiple dev/build environments on a single instance without licencing Multitenant), so I have a filter as

owner like regexp_replace(user,'(^[^_]+)','%')

which finds objects for all schemas with the same suffix.