String-based search method formats
| Format | Supports | Example / comment |
|---|---|---|
| String | Single value |
Supports as wildcards asterisk (*) for multiple characters and question mark (?) for single characters manatee - returns records with the word in title or number abbey - returns Locations or other items with abbey in the name me - returns own Location |
| Range |
No wildcard support 37/00000 to 37/99999 |
|
| List of values |
Manatee,Dugong,Whale Use quotes to enclose strings with spaces |
|
| Record number |
record:"27" Record numbers must be in quotation marks. |
|
| Object | Names of objects |
Location search hasMember:abb* - returns all Locations that have members whose names start with abb assignee:me |
| [all] [none] |
container:[all] returns all records with a container schedule:[none] returns all records that do not have a retention schedule |
|
| For Location fields:[me] [not me] |
owner:[me] returns all records whose owner is me assignee:[not me] returns all records that have an assignee other than me assignee:[surname:abbey and givenName:Rhoda] |
|
|
Number 32bit & 64bit integer, decimal and currency |
Single value |
1 27.5 $33.00 For comma separator, use number in quotes, e.g."1,000" |
| Range |
1 to 100 number>1999/00998 - all numbers greater than 1999/00998 |
|
| List of values | 1,3,5,8,90 | |
| Boolean | No parameters, just method name | name:financial* and usable |
| Date | Single date | 1/1/83 |
| Single date with time | 1/1/83 12:30:00 | |
| Range | 1/1/83 to 1/1/87, registeredOn:1/1/2001 to 31/12/2009 | |
| previous X <period(s)> |
previous refers to the previous full period, for example, if you conducted a search on Monday October 3rd 2017 at 3:40 PM and searched the previous month, the system would search by September 1st 12:00:00 AM TO September 30th 11:59:59 PM |
|
| this <period> | this refers to the current period, for example, if you conducted a search on Monday October 3rd 2017 at 3:40 PM and searched this month, the system would search by October 1st 12:00:00 AM TO October 31st 11:59:59 PM | |
| next <period> | next refers to the period starting after the current one, for example, if you conducted a search on Monday October 3rd 2017 at 3:40 PM and searched next month, the system would search by November 1st 12:00:00 AM TO November 30th 11:59:59 PM | |
|
before or after a date |
periods are defined as second, hour, day, week, month, quarter, year, fiscal year You can leave the plural s out when using a period. Examples: previous 7 seconds, previous 12 hours, previous 3 days, previous 9 weeks, previous 8 months, previous 22 years, previous 3 fiscal year, for example, if you conducted a search on Monday October 3rd 2017 at 3:40 PM and searched previous 6 months, the system would search by April 1st 12:00:00 AM TO October 3rd 3:40:00 PM this week, this month, this quarter, this year, next 10 years, next month, next week, for example, if you conducted a search on Monday October 3rd 2017 at 3:40 PM and searched next 6 months, the system would search by October 3rd 2017 at 3:40:00 PM TO April 30th 2018 11:59:59 PM quarter to date registeredOn<31/12/2009 - the period before the date registeredOn<=31/12/2009 - the period before and including the date registeredOn>31/12/2009 - the period after the date registeredOn>=31/12/2009 - the period after and including the date registeredOn=31/12/2009 - the period equalling the date registeredOn<>31/12/2009 - the period outside the date registeredOn>1997 - the period after 31/12/1997 registeredOn<1997 - the period before 1/1/1997 registeredOn>lastMonth - the period after the last day of the last month registeredOn<lastMonth - the period before the first day of the last month |
|
| Financial Year | FY2016 | |
| Enumerated value | Items from a predefined list, e.g. for the field Disposition | |
| Single value | Archived (Permanent) | |
| Set of values |
Inactive,Archived (Local) |
|
| Range |
disposition>Archived (Interim) returns records with a value for Disposition of Archived (Permanent) or Destroyed |
|
| URI | Single value | 377 |
| Set of values | -1,3,44 | |
| Recursive searching | assignee:99+ will find also all Locations that are members of the Location with the URI 99 |