Collection manipulation

[sumit]

Hi All,

I want to filter a collection in which i have 3 column i.e order number, status ,order line number and i want to filter the collection if status is like other than cancel and dispatch and also line number null .I tried to filter but i am stuck with the status please suggest .

 

[VJR]

Hi sumit,

This is assuming 'Order Line Number' is a Number type column.

Test this out for various scenarios on your collection and post back if you have any issues.

"Status <> 'Dispatch' AND Status <> 'Cancel' AND [Order Line Number] = 0"

 

[sumit]

Hi sumit,

This is assuming 'Order Line Number' is a Number type column.

Test this out for various scenarios on your collection and post back if you have any issues.

"Status <> 'Dispatch' AND Status <> 'Cancel' AND [Order Line Number] = 0"

Thanks it really helpful.