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]

Thanks for the reply.

Basically i did wat you said. I created a query. From the output i create a sort. In the sort i press and select the object that should be sorted. I select up/down. from the output of the sort i create a table. Indeed i can select all columns. I do (via checkbox)...but it doenst matter if i select all or select some. the result in the colum is always the same. Its just 1 colomn (the 1 used in the sort). '

If i don't use the sort the table shows all colums selected by the checkbox.

any ideas what might cause this problem....(better yet) tips to solve it?

Regards

Bart

[Former Member]

Do you see the columns you checked in the layout view of the VC? And after using the checkboxes (when creating the table view), do you also see the checkmarks in the display column when you configure the table view after creating it (bottom right of the VC)? I have tried several things in my configuration, but I get to see the columns I select...?

[Former Member]

Thanks again for reply.

I did the following:

I created a new model -> use a nested iview. In Nested Iview i create from query variable (input) a signal in. Select all options. From signal out create a sort. Insert object to sort on. From sort create table and select all columns. On 1 higher level i create from signal in an input form... and deploy.

Hoera...it works..

So i go to my original dashboard. Create a new Nested Iview...do all the stuff mentioned above (similar). However the only difference is that the input field is not created new...as i use the input form already build.

Result??? 1 column.

How the %%&&% this is possible??

any ideas?

Points will be assigned.

Regards

[Former Member]

I discovered the following.

If i use a new model, and sort the table as described above it works.

If i insert the same structure in my exsisting dashboard i works partly.

I found out that the settings of the table regarding "fit contents", namely: auto, fit width and actual size determines the ammount of columns.

• If i use auto, i just see 1 column --> and cannot make column smaller.

• if i use fit widht i get to see 4 columns -> and if i make the last column smaller all (20 columns) are shown.

• If i use actual size i get to see all colums i selected, however they are all sized accordint to settings in layout tab.

As i said before i created a rather comprehensive dashboard. All tables use the same fit content settings (auto)....this is the first table with a sort....and this problem arrises.

Any suggestion?

Regards

Bart

[Former Member]

Dear all.

I'm wondering if anybody else experienced errors with the sort and the amount of columns shown in a table????

In general i have a query and want a table as output with 8 columns (sorted by 1 object). I figured out the following and will demonstrate it with 4 situations.

Situation1 (auto fit table without sort)

In the properties of the table i select 'frame style'= 'Primary frame' and "fit content" = 'auto'. I run the dashboard and the content of the query is good. All columns are shown and the chart width is auto determined.

Situation 2 (auto fit table with sort)

I want to sort on 1 object, so from query i insert a sort (select object), and from sort i create table. Then i select 'frame style'= 'Primary frame' and "fit content" = 'auto'. I run the dashboard and the content of the query is NOT good. I just get to see 1 column. But i selected 8 columns.

Situation 3 (actual fit table with sort)

I want to sort on 1 object, so from query i insert a sort, and from sort i create table. Then i select 'frame style'= 'Primary frame' and select "fit content" = 'actual size'. I run the dashboard and the content of the query is good (but not what i want). I get to see all 8 columns. But the table is smaller than i want. I doenst auto fit.

Situation 4 (fit width table with sort)

I want to sort on 1 object, so from query i insert a sort (select object), and from sort i create table. Then i select 'frame style'= 'Primary frame' and "fit content" = 'fit width'. I run the dashboard and the content of the query is NOT good. I just get to see 1 column (again). But i selected 8 columns.

Any suggestions?

Any known work arounds?

Or is this an error in VC and should i request a note?

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