Greetings,
I want to display documents in a view status wise.
suppose I have four status Submitted, Approved, Rejected and close. then it should display first Submitted then Approved then Rejected then Close.
How can I do this?
Panther
Subject: display by status
create a hidden column before your categorized column and sort it ascending. this column shoud evaluate to numeric values. you can write code as:
@if(Status = “Submitted”; 1; Status = “Approved”; 2 …)
hth
Sharjeel
Subject: display by status
You could add a hidden sorted column which is calculated with a value based on the contents of the status field, e.g.
@If(Status=“Rejected”; 1; Status=“Approved”; 2; …; 0)
0 being the else branch.
Subject: display by status
A slightly better method, especially if the values may change in the future, is …
@Member( Status ; “Submitted”;“Approved”;“Rejected”;“Close” )
This way, you can insert new values without having to manually change the numbers associated with each value.