Define Browser Folder - misfortune with order by clause

[Maxmix]

Hi,
I have create custom Browser folder and populated it with several objects. Then I decided to order them.
To accomplish this, I included "object_type" into order by clause (without quotes).
Now on attempt to view custom folder's contents, I have to wait for long, and then I see thousands of non-relevant objects, without any trace of ordering.
For example, among the items we have:
-- items with with function icon
mdsys.ogc_pointonsurface,
mdsys.ogc_area,
mdsys.ogc_buffer,
mdsys.ogc_equals,
mdsys.ogc_symmetricdifference
-- items with java icon
sys."/9be89712_cubiccurve2ddouble",
sys."/55f982a1_cubiccurve2dfloat",
sys."java/awt/geom/cubiciterator"
-- items with synonym icon
public."sqlj/javac/rmsqljnode",
public."sqlj/javac/simplenode",
public."sqlj/javac/javafield",
public."sqlj/javac/javaconstructor"

etc...
Billions of items, in fact!
Have I done something wrong?

 

[Marco Kalter]

Can you let me know the where clause and order by clause of the folder?

 

[Maxmix]

"Where" is empty, and "order by" reads just "object_type"

 

[Marco Kalter]

Okay, I see what the problem is. By specifying an order by clause the folder has become query-based. Since you have not specified a where clause, all objects will be included.

The order by clause does not affect the objects you have explicitly added.

 

[Maxmix]

I see.
But the list is becoming large, and tends to have "dead" entries. I was able to copy the object list into external editor, sort there and paste back.

 

[Theod]

Hi,

how about this where clause.

Where 1 = 1
order by object_type

since you can also order there.

 

[Maxmix]

Thanks for the try, but no, it does not make difference.
Obviously, the folder becomes query-based, if either folder (where, orderby) is not empty...