Filter

Object and Type

Object  : FCGeneric

Type     : Property

Prototype

Public Filter As String

Description

This property is used for the "where" clause when this generic object queries the database. You must use SQL syntax to specify the "where" clause.

In most cases, you should not use this property, but rather use the higher-level AppendFilter property provided. The AppendFilter property, each time you call on it, will add another clause to the "where" clause, and will join them together with "And".

The one time to use this property is if you have very complex filtering, particularly if you want to use the "Or" construct.

Example

The following example shows how to query for sites in Texas or Arizona from the site_view view.

JavaScript:

  // Set up a query of sites in Texas or Arizona
  var boSiteView = FCSession.CreateGeneric();
  boSiteView.DBObjectName = "site_view";
  boSiteView.Filter = "state = 'TX' or state = 'AZ'";
  boSiteView.Query();

  // Print them out
  while (boSiteView.EOF != true)
  {
    Response.Write ("Site ID: " + boSiteView("site_id"));
    boSiteView.MoveNext();
  }

Visual Basic:

  Dim boSiteView As FCGeneric

  Set boSiteView = fc_session.CreateGeneric
  boSiteView.SimpleQuery "site_view"
  boSiteView.Filter = "state = 'TX' or state = 'AZ'"
  boSiteView.Query

  While boSiteView.EOF = False
    MsgBox "Site: " & boSiteView("site_id")
    boSiteView.MoveNext
  Wend