Problem - Sort output in table (multiple columns)

[Former Member]

Dear all,

First of all - Best wishes for 2008.

I probably have an easy matter, but i can't figure it out, and on this forum very little is mentioned about the sort operator, so therefore this new post.

I have a dashboard with some input fields (dropdown boxes).

I have a table (as result of query) and this works fine. The table consists of several columns. (so far no rocket science).

Generally the structure of the table is like:

IM SBU | App. Request key | App. Request | etc....

I want the IM SBU colum to be sorted (assending or decending doenst matter).

But somehow the second column is the one where the data is sorted (standard).

My guess this happends because its a key value? or its because it starts with an A (and the other with and I).

So i insert the sort opperator, add an object (IM SBU) and select up. Then from that opperator i create a table.

This results in a table with just 1 column (IM SBU).

So i tried several things.

I tried to sort on the IM SBU key (this gives the same result).

I added all colums as an object of the sort opperator...but this still gives the same result of just 1 column.

Any ideas?

Regards.

Bart

[Former Member]

Hi All,

Does anybody know if the sort opperator can work with a navigational object?

And if I model a sort opperator as input of a multple column table, it doenst matter what i sort on or how many sorts is use i still get 1 column as result. But i want just 5 colums or more (sorted by 1 object). Is that possible?

Any help is welcome.

Points will be assigned

Regards.

Bart

[Former Member]

Hi Bart,

you should place the sort operator between the query and the output table. First connect the output of the query with the sort operator. In the sort operator you specify on which fields from the query you want to sort (up or down). After linking the output of the sort operator to the input port of the table view, you should be able to select all columns you want to display by configuring the table view and placing checkmarks before the column names you want to display.

The sort operator only affects the sorting of the complete output of the query and does not work as a filter. The sort operator should work on all columns that are delivered by the query.

Regards,

Arno