Hello everyone,

Can I just say, that I love this group.... the hints, tips and tricks are great and I've learnt a lot by just lurking. So thank you all.

I use PSQuery quite a lot and would class myself as in intermediate user but I'm a little bit puzzled as to how I would go about defining a sort order.

I would like my query results to come back in a specific order that I can define from one field.  How would I go about this?

I'm currently using record CLASS_TBL_SE_VW - Class Table Student Enrl View and I want to sort on the CLASS_SECTION - Class Section field in a none alpha manner.

Thanks in advance.

Tracey

Hello everyone,

Can I just say, that I love this group.... the hints, tips and tricks are great and I've learnt a lot by just lurking. So thank you all.

I use PSQuery quite a lot and would class myself as in intermediate user but I'm a little bit puzzled as to how I would go about defining a sort order.

I would like my query results to come back in a specific order that I can define from one field.  How would I go about this?

I'm currently using record CLASS_TBL_SE_VW - Class Table Student Enrl View and I want to sort on the CLASS_SECTION - Class Section field in a none alpha manner.

Thanks in advance.

Tracey

Hello everyone,

Can I just say, that I love this group.... the hints, tips and tricks are great and I've learnt a lot by just lurking. So thank you all.

I use PSQuery quite a lot and would class myself as in intermediate user but I'm a little bit puzzled as to how I would go about defining a sort order.

I would like my query results to come back in a specific order that I can define from one field.  How would I go about this?

I'm currently using record CLASS_TBL_SE_VW - Class Table Student Enrl View and I want to sort on the CLASS_SECTION - Class Section field in a none alpha manner.

Thanks in advance.

Tracey

I may be over simplifying this, but have you used the 'Reorder/Sort' radio button on your "fields" tab within query manager? See below:

Hello everyone,

Can I just say, that I love this group.... the hints, tips and tricks are great and I've learnt a lot by just lurking. So thank you all.

I use PSQuery quite a lot and would class myself as in intermediate user but I'm a little bit puzzled as to how I would go about defining a sort order.

I would like my query results to come back in a specific order that I can define from one field.  How would I go about this?

I'm currently using record CLASS_TBL_SE_VW - Class Table Student Enrl View and I want to sort on the CLASS_SECTION - Class Section field in a none alpha manner.

Thanks in advance.

Tracey

Not knowing exactly how your CLASS_SECTION is contructed but taking a guess maybe you can create an expression similar to this/use as field and sort

case 

when substr(A.CLASS_SECTION,-1) between 'A' and 'Z' then substr(A.CLASS_SECTION,1,3)

when substr(A.CLASS_SECTION,-2) between 'AA' and 'ZZ' then substr(A.CLASS_SECTION,1,2) else A.CLASS_SECTION end

When I am using something as a sort only I make the Length 0 and set the Heading Text as No Heading

Hope this helps,

Bob

--
Bob Fogarty

LionPATH - Reporting Team Lead

The Pennsylvania State University

rtf12@psu.edu

I may be over simplifying this, but have you used the 'Reorder/Sort' radio button on your "fields" tab within query manager? See below:

Hello everyone,

Can I just say, that I love this group.... the hints, tips and tricks are great and I've learnt a lot by just lurking. So thank you all.

I use PSQuery quite a lot and would class myself as in intermediate user but I'm a little bit puzzled as to how I would go about defining a sort order.

I would like my query results to come back in a specific order that I can define from one field.  How would I go about this?

I'm currently using record CLASS_TBL_SE_VW - Class Table Student Enrl View and I want to sort on the CLASS_SECTION - Class Section field in a none alpha manner.

Thanks in advance.

Tracey