display a row first based on a condition

vash

Hi,

I have a table with following fields:

CompanyId Name Parent Num of Licenses
123 ABC 222 5
234 PQR 222 1
222 XYZ 222 4
345 DEF 222 6

I want to display the third row as the first - based on the condition that
CompanyId == Parent.

So the desired output is:

CompanyId Name Parent Num of Licenses
222 XYZ 222 4
123 ABC 222 5
234 PQR 222 1
345 DEF 222 6

Can someone suggest, how to do this?

Thanks,
-Vash

JasonW

Vash,

Just add a sort condition to the table that is displaying it with the following expression:

if( row["companyid"] == row["parent"] ){
"1";
}else{
row["companyid"]
}

If company id and parent are ints

if( row["companyid"] == row["parent"] ){
1;
}else{
row["companyid"]
}

Jason