Search these areas:
Help
Support Forums
Product Info



-Introduction
-DataWeb: What's New
-Creating an Application
-The DataWeb Designer
-Application Management
-Data Tables
-Data Tables
-Views
-Templates
-Components
-Data Analysis
-Members
-Security
-Importing
-Exporting
-FTP
-JavaScript
-Object Model
-Full-Text Search
-Domain and Email Hosting
-HotBlock Modules
-Account Management
-Glossary
-New Responsive UI Module





DataWeb Help
Support Forums
Tutorial
Script Library
Knowledge Base

Home > Support

KnowledgeBase


How To: Filter for records where a Field is NOT equal to a Value
Article TypeHow To
TitleFilter 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 ReviewedFebruary 20, 2015 14:08:18

  
Affiliate | Partner | Terms of Use | Privacy Policy | Contact Us | Pricing | Bring DataWeb In-House    
DataWeb, 720 North 10th Street, A #145, Renton, Washington 98057 *425-583-5970* Fax 484-770-4706* Email Us