OneData 10.7 | Managing Master Data with webMethods OneData | webMethods OneData User’s Guide | Advanced Object Properties | External Services | Using Deep Links | Customizing Deep Links | Deep Link Filter Syntax
 
Deep Link Filter Syntax
Create the customized deep link by appending the filter to the end of the deep link URL using the syntax: ?filter=[Column Name]=[value].
The name of the object must be the physical table name and the column must be the column name. However, if the column is a reference column, you must use the constraint name instead of the physical name. The format of the search value must comply with the syntax of the column’s data type.
The following table describes the format to use for the value by data type.
Data Type
Format
Numeric
None. For example: EMPLOYEE_ID=120
String
Enclose string values that contain spaces within quotes, for example:
*EMPLOYEE_USERID=JDOE
*EMPLOYEE_NAME=“John Doe”
Date
Enclose dates within quotes using the format YYYY-MM-DD, for example: EMPLOYEE_DOB=“1984-12-31”
Timestamp
Enclose timestamps within quotes using the format YYYY-MM-DD HH:MM:SS.sssssssss, for example: EMPLOYEE_DOJ=“2007-03-01 10:30:30.0”
Note:
You must specify at least one digit in the millisecond field (sssssssss).
For example, to search for records in the Employee data object where the last name (last_name) is Smith, the deep link filter would be as follows:
http://localhost:8080/onedata/dmdirect/QA/Standard%20Project/DO/Employee?filter=last_name=”Smith”