Sorting the Non qualifier values.. Is it Possible!!

[Former Member]

Hi Experts,

I have a qualified table.

week day -> Non qualifier

Time In -> Qualifier

Time out -> Qualifier

The Week day Field is fileed with all 7 days of the week.

Monday, Tuesday,wednesday,Th..... sunday

Wehave 2 issues here..

1) In DM qualified lookup selection for a record, i can see it is autiomaticallyy sorted Based on Alphabetical order..

that is Friday, Monday, Saturday, Sunday, thursday, Tuesday, Wednesday.

we require this to be in Monday to Sunday order..

2) Also i selected Monday first and gave timein time out values, and for the same record when i ALSO select Friday and provided Time in and Time out values and once i Hit save, then i can see that Friday is seen first and Monday is seen Next to it.

Which means it is also saving the Entries for Qualified table in a Non qualifier Alphabetical sorting order.

Can we get rid of this??

User should see the Qualifid Lookup selection box in Monday to sunday order

Once user selects the any of the values in non qualifiers they should be seen in Monday to Sunday order once they save.

Note: Sort Type option at Non qualifier Field level did not help.

did anyone face similar issue??

KR

John

[Former Member]

Hi John,

I am not sure if this can be really sorted out.

However,what you try this -

Unload the repository

Select the Qualified table from left hierarchy pane

Right click over,select "reorder"

Reorder as you wish

load the repository,check if it works.

Thanks,

Ravi

[Former Member]

Hi,

I used a Integer field called Code.

which has 1-7 numbers.

Name : Code

Monday 1

Tuesday 2

Wednesday 3

thursday 4

Friday 5

Saturday 6

Sunday 7

These 2 fields are Non qualifiers, But in Portal we have hidden the Code field.

This way the sorting worked.

Closing thread.

KR

John