Sort expression

[#1]

HI,

I have a problem with sort express. How should look expression?

The sort order is ROZ, ZAW, W, PRZYPISANY

THANKS

MARTA

[sunny_talwar]

May be like this

Match(FieldName, 'ROZ', 'ZAW', 'W', 'PRZYPISANY')

[nagarjuna_kotha]

This is Information is not enough and not clear.

Can u explain clearly with some some sample data along with output.

-Nagarjun

[#4]

I have something like this

STATUS: ZAWIESZONY, PRZYPISANY_DO_GRUPY, ROZWIAZANY, W_TRAKCIE_PRAC

I wants to sort like this: ROZWIAZANY, ZAWIESZONY, W_TRAKCIE_PRAC, PRZYPISANY_DO_GRUPY

But I do not know how sort expression

[sunny_talwar]

This?

=Match(STATUS, 'ROZWIAZANY', 'ZAWIESZONY', 'W_TRAKCIE_PRAC', 'PRZYPISANY_DO_GRUPY')

[squeakie_pig]

It is like Sunny T said.

Go to the object properties.  Click the sort tab.  Click on the field you want to sort by... add the expression

match(YOURFIELDNAME, 'ROZWIAZANY', 'ZAWIESZONY', 'W_TRAKCIE_PRAC', 'PRZYPISANY_DO_GRUPY')

choose either ascending or descending, depending on how you want it to sort.

[muthukumar77]

Hi,

Go to Sort expression,put like this,

If(YOURFIELDNAME='ROZWIAZANY',1,

If(YOURFIELDNAME='ZAWIESZONY',2,

If(YOURFIELDNAME='W_TRAKCIE_PRAC',3,

If(YOURFIELDNAME='PRZYPISANY_DO_GRUPY',4))))

set as Ascending order.

[#8]

All of these solutions not work

[sunny_talwar]

Would you be able to share a sample to look at what you are trying to do?