Search these areas:
Support Forums
Product Info

DataWeb: What's New
Creating an Application
The DataWeb Designer
Application Management
Data Tables
Data Tables
-View Basics
-Converting HTML Pages to Views
-Incorporating Script in a View
-View Property Reference
-View XML Reference
-URL Parameters Reference
Modifying Nested Data Regions
-SQL Expression Reference
Data Analysis
Object Model
Full-Text Search
Domain and Email Hosting
HotBlock Modules
Account Management
New Responsive UI Module

DataWeb Help
Support Forums
Script Library
Knowledge Base

Home > Support

DataWeb User's Guide

URL Parameters Reference
By modifying the parameters of a view's URL, you can change a view's properties or perform database operations on the data tables underlying the view.

Data Region Parameters

The following table describes parameters that affect a view's data region:

Parameter Value Description
_page Any number When there are multiple pages of data, this parameter specifies which page of data to display.
_pagesize Any number Specifies the number of records to display on a single page.
_mode insert, update, grid, details Specifies the display mode of the data region.
_sort (+/-)fieldname Specifies the sort order for the data region.
_filter filterstring Specifies how the data region will be filtered. filterstring can contain SQL functions and keywords. The _filter parameter is not required for simple filtering cases. For simple filtering cases see the syntax below. For more complex cases see the SQL Expression Reference.
If _lastfilter is set to 1, then the last filter applied to the view will be used.

For example, the following URL specifies that the view file Orders.view be displayed in grid mode with the Date field sorted in descending order.

Filter Parameters

You can specify parameters in the URL to filter a data region. A filter specified in the URL is applied in addition to any filter attribute specified in the data region's Filter Preset property.

Filters can be specified as follows:

Filter Description
fieldname~eq=value Field equals value
fieldname~date-eq=value Date part of field (month, date, year) matches value (hours, minutes, seconds ignored)
fieldname=value Field equals value
fieldname~in=value1;value2;value3 Field is one of value1, value2 or value3. Use semicolons to separate the values, as shown in the example to the left.
fieldname~startswith=value Field begins with value
fieldname~contains=value Field contains value
fieldname~le=value Field is less than or equal to value
fieldname~lt=value Field is less than value
fieldname~gt=value Field is greater than value
fieldname~ge=value Field is greater than or equal to value
fieldname~ne=value Field is not equal to value
fieldname~empty=true Field is null
fieldname~isempty= Field is null
fieldname~empty=false Field is not null
fieldname~isnotempty Field is not null
fieldname%20LIKE%20'stringvalue%' Field begins with stringvalue

Related Topics

SQL Expression Reference

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