Tree View
Tree
List View
Alphabetical List
Share
Share
Search:
id:
128

name:

Query String Parameters



description:
Use the following query strings options to query your data and drill down into particular records and even columns.

Use these query strings with Qrimp's JavaScript API and Square Brackets to build custom behaviors for your websites and share data on other websites.

Selecting the Data to Display


The most important query string parameter is t, which specifies the table from which to pull data. Since it's the most important, you'll probably use it with the ? like this:
?t=1005 or ?t=HelpTopics

For example, to display Help Topics in a Grid View, you would use this url:
db.aspx?t=HelpTopics

You could display the HelpTopics on the Calendar View like this:
calendar.aspx?t=HelpTopics

Or in a Tree View like this:
treeview.aspx?t=HelpTopics

You can use either the ID of the Table or the TableName. You can get a list of tables from the Develop > My Tables menu.

Formatting the Data

Another useful parameter is the vid parameter which specifies which layout format to use from the Views Table. With views, like with tables, we can use either the ID or the name of the view, like so:
&vid=1 Uses the Grid view.

Combine the t and vid parameters like this:
db.aspx?t=HelpTopics&vid=1 <-- Click it and see. View 1 is the default view, so usually you will not need to specify &vid=1, unless a default view has been specified in the Table Settings.

As another example, let's look at the Help Topics as a list of links:
db.aspx?t=HelpTopics&vid=14

Sorting your data



To order the results by a column, simply add &orderby= to the end and specify the column number to order by. Adding multiple orderby parameters, or values separated by commas will reverse the order. For example &orderby=5 will sort the fifth column ascending and &orderby=5,5 will sort the fifth column in descending order. The sorted column in a grid view will be highlighted. A quick way to sort your data by most recently created items first would be to order by the ID field descending like this:
db.aspx?t=HelpTopics&orderby=1,1

Filtering your data



You can filter your data many ways using the query string. If you would like to limit records to a particular value within a column add &columnname=value where columnname is the name of the column and value is the value for the filter. For example, to display a particular record you can reference that record by the ID.

Look in the location bar now and you will see:
/db.aspx&id=128&t=HelpTopics Which means, show the item from the HelpTopics table using view number vid and for the Help Topic with id equals 128.

If you would like to be more specific about your query, you can use query operators and query values like so
&columnnameop=
&columnnamequery=

For example, to show only Help Topics that contain the word Parameters in the name, you could use a query string like this:
db.aspx?t=HelpTopics&nameop=contains&namequery=Parameters

To show all help topics with created since May 1, 2008, you'd use this url: db.aspx?t=HelpTopics&createdateop=>&createdatequery=5/1/2008
contains : Find items that contain the query value, same as contains
like : Find items that are like the value, same as contains
not like : Find items that do not contain the query value
startswith : Find Items that start with the query value
= : Find items equal to the query value
<> : Find items not equal to the query value
>= : Find items greater than or equal to the query value
> : Find Items greater than the query value
< : Find items less than the query value
<= : Find items less than or query equal
in : Specify a list of items. Example: &idop=in&idquery=1,2,3
&pagesize= Determines how many records are shown. Do you want 20 Help Topic Links or 50 Help Topic Links By Default, the page size is pulled from the Table Settings
&hidecolumns= Determines which column names should be hidden Help Topics without the description field
&selectcolumns= Determines which column names should be pulled from the database. Show Id, Name and CreateDate
&noheader=true&nofooter=true Hides the page header and footer Help Topics sans Header/Footer These will be useful when using the Share Data feature when you want to include data, but not the menus and content in the right rail. We call it the footer because it appears at the bottom of the HTML source, even though it is rendered on the right hand side of the page. You can use Skins to change this behavior.
_fieldvalue=fieldname This parameter used in conjunction with the id= parameter will show only the contents of the specified column. For example, to show only the description for this Help Topic, use the following url:
db.aspx?t=HelpTopics&id=128&_fieldvalue=description
&qid= Allows you to specify one of your custom Ad Hoc Queries to filter the records or build complex joins among tables.


ParentTopic: