|
| How To: Filter for records where a Field is NOT equal to a Value |
| Article Type | How To |
| Title | Filter for records where a Field is NOT equal to a Value |
| <I>How do I filter a resultset where a field is <B>not equal</B> to a value?</I><BR><BR>Use a <A href="/default.view?Topic=objectmodel/dataargs/wsdataargs">filter object</A> with <A href="/default.view?Topic=urls/urlfilterview">URL filter syntax</A>:<BR><BR><SPAN class=smallCode><PRE>// return all records on the FRUIT table except those where fruitName = "Apples";
var filter = new Object;<BR>
filter["fruitName~ne"] = "Apples";
rsIndex = table.select( "fruit", ["rowId","fruitName","season"],
filter, "+fruitName");</PRE></SPAN> |
| Last Reviewed | February 20, 2015 14:08:18 |
|
|
