Sorting by a DDDW column 1

[Lekar]

Hi

I want to sort my DW using a DDDW column. The column stores a number, but displays a name stored in another table. I tried the LookUpDisplay function but I think it doesn't work with DropDownDataWindows.

Thanks in advance.
=)

 

[tabhijit]

Hi,

Create hidden compute object and assign lookupvalue to it. Then sort dw using compute object.

Regards,
Abhijit.

 

[Lekar]

Thanks, but how can I assing the lookupvalue to the new compute object?

 

[tabhijit]

Hi,

In the expression of compute object select lookupdisplay (columnname or number).

Regards,
Abhijit.

 

[Lekar]

So many thanks. It works with LookUpDisplay (I don't know why it didn't work on my first attempts). And, by the way, it is not necessary to assign the LookUpValue to a compute object, it is possible to code:

dw_1.SetSort("LookUpDisplay(State_ID) A&quot
dw_1.Sort()

and it works. That was I looking for, 'cause I want to code that sentence in the parent DW Control, so it is automatic in the descendents.