Appearance
CL tenure search
There are four ways to search for tenures:
- Simple — where you enter criteria into frequently-used search fields
- Full — where you can select from every available field and choose your own comparison operators
- Recent — where you can re-run recently-used searches
- Favourite — where you can store named search favourites that you expect to be useful into the future.
For a step-by-step guide to learning how to search in MVOW, see Searching in MVOW.
Simple search
Simple search exposes the following collection of search fields.
To use the search form, you can enter one or more of the following:
- one or more account numbers (you can paste these in from a spreadsheet if you want);
- a region;
- an office;
- a tenure type;
- a tenure subtype;
- a lot number;
- a plan number;
- a suburb;
- a holder name;
- a holder class;
- a last review date range;
- a next review date range;
- a land value range;
- an area range;
- a redetermination status;
- a redetermination processing type;
- a redetermination issue date range.
The Make full button transfers your existing simple search criteria over to the Full search tab.
The Search 
button displays the search results in the current tab, navigating away from the search criteria page.
The Search 
button displays search results in the current tab, retaining the search criteria.
The Search 
button displays search results in a separate browser tab.
The Clear button removes all criteria from the Simple search tab.
In all fields, useful default operators have been selected.
- The Account number(s) field matches to ONE OF the provided PIDs.
- Text fields use the CONTAINS operator.
- All conditions must be met in order to retrieve result rows.
Search example
If you enter a district and a street name, the system will find properties in that district AND with that street name.
The Account number(s) field takes a list of Account number(s), one on each line. You can get these by pasting in from a spreadsheet or copying PIDs from previous search results.
Full search
Full search provides you with the ability to make much more complex search criteria. You can search for almost anything that can be traced back to the tenure.
To use Full search:
- Select a field.
- Select a comparator.
- Enter the search criterion.
- Press either the Search , Search , or the Search button to run the search.
If you have added a search criterion you no longer want, click the Remove 
button to remove that criterion.
Fields
The fields that you can search come from multiple categories:
- Tenures
- Tenure descriptions (lot/DP)
Each field is listed below by category.
Tenure
| Field name | Type | Notes |
|---|---|---|
| Account number | Number | |
| Region | Dropdown | Selection from a list of active regions. |
| Office | Dropdown | Selection from a list of active offices. |
| District | Text | Selection from a list of active districts. |
| Suburb | Dropdown | Selection from a list of active suburbs. |
| Holder | Text | Default comparison type is CONTAINS. |
| Tenure type | Dropdown | Selection from a list of active tenure types. |
| Tenure subtype | Dropdown | Selection from a list of active tenure sub-types. |
| Usage | Dropdown | Selection from a list of active tenure usages. |
| Structure | Dropdown | Selection from a list of active structures. |
| Curr gross annual rent | Number | |
| Curr net annual rent | Number | |
| Area | Number | A value ending with h, H, ha or HA will be interpreted as hectares. Anything else will be interpreted as m². |
| Next review date | Date | |
| Last review date | Date | |
| Rent at last review | Number | |
| Rent before last review | Number | |
| Term | Number | Tenure term in years. |
| Commencement date | Date | |
| Expiry date | Date | |
| Holder class | Dropdown | Selection from a list of active holder classes. |
| Tenure class | Dropdown | Selection from a list of active tenure classes. |
| Usage classification | Dropdown | Selection from a list of active usage classifications. |
| Suspended redet | Dropdown | Selection from a list of redetermination suspension types. |
| Suspension expiry date | Date | |
| Rebate category | Dropdown | Selection from a list of rebate categories. |
| Land value | Number | |
| CLCTA | Strict Yes/No | Default value is YES. |
| Express rent | Text | Default comparison type is CONTAINS. |
| Previous valuer | Text | Default comparison type is CONTAINS. |
| Previous valuation date | Date | |
| Redet status | Dropdown | Selection from a list of redetermination statuses. |
| Redet issue date | Date | |
| Last objection date | Date | |
| Redet process type | Dropdown | Selection from a list of redetermination statuses. |
| Valuation CM9 ref | Text | Default comparison type is CONTAINS. |
Property description
| Field name | Type | Notes |
|---|---|---|
| Lot number | Text | Default comparison type is EQUALS. |
| Plan number | Number | Default comparison type is EQUALS. |
Field types
The comparators available for the different field types are listed below.
| Field type | Comparators |
|---|---|
| Text | EQUALS, NOT SET, CONTAINS, ONE OF, NOT ONE OF, STARTS WITH, ENDS WITH |
| Date | EQUALS, NOT SET, BETWEEN, NOT BETWEEN, ON OR BEFORE, ON OR AFTER |
| Dropdown | EQUALS, NOT SET, ONE OF, NOT ONE OF |
| Yes/No | YES, NO, YES OR NO, NOT SET |
| Number | EQUALS, NOT SET, LESS THAN, GREATER THAN, ONE OF, NOT ONE OF, BETWEEN, NOT BETWEEN |
| Strict Yes/No | YES, NO |
Comparators
And here’s how the comparison operators work.
| Comparator | Description |
|---|---|
| EQUALS | The value associated with the property must be an exact match with what’s specified in the search criterion. |
| NOT SET | The value associated with the property must not be set. There is a difference between an empty value or zero and a value that is not set. |
| CONTAINS | The value associated with the property must contain the string of characters specified in the search criterion. |
| ONE OF | The value associated with the property must be one of the items specified in this list. You can separate the list of values with line breaks, white space (spaces, tabs) and/or commas. This is a bit problematic when it comes to values that contain commas and/or spaces (like legal descriptions). |
| NOT ONE OF | The value associated with the property must not be ANY of the values in the list. |
| STARTS WITH | The value associated with the property must start with the string of characters you specify. |
| ENDS WITH | The value associated with the property must end with the string of characters you specify. |
| BETWEEN | The value associated with the property must lie between the values you specify. Note that this can apply to dates or numbers, and is an inclusive range. That is, if you’re for LT land values between 100,000 and 200,000, properties with LT land values of 100,000 will be included in the search results. |
| NOT BETWEEN | The value associated with the property not must the values you specify. It must be less than the lower value OR greater than the upper value. |
| ON OR BEFORE | Applying specifically to dates, the value associated with the property must lie on or before the date you specify. |
| ON OR AFTER | Applying specifically to dates, the value associated with the property must lie on or after the date you specify. |
| YES | Applying specifically to flags, the flag associated with the property must be set to YES, normally by a box being ticked. |
| NO | Applying specifically to flags, the flag associated with the property must be set to NO, normally by a box being unticked. |
| YES OR NO | Applying specifically to flags, the flag associated with the property must be set. It can be either YES or NO, but it must be set. |
| LESS THAN | Applying specifically to numbers, the flag associated with the property must be less than the value you specify. |
| GREATER THAN | Applying specifically to numbers, the flag associated with the property must be greater than the value you specify. |
Recent searches
Re-run any of your 20 most recent searches.
Recent searches contain saved search criteria, not saved search results. If you have changed the data, a set of search criteria may result in a different set of properties.
The Search button displays the search results in the current page, navigating away from the search criteria page.
The Search button displays the search results in an in-page tab.
The Search button displays the search results in a separate browser tab.
The Edit 
button copies the search criteria, placing it in the Full search tab. You can edit it from there.
The Name tag 
button allows you to name any search that has already been made a favourite.
The Favourite 
button allows you to store this search on your Favourite tab.
The Remove button removes the search from your search history.
Removing a search removes it from both the Recent tab and the Favourite tab.
Choosing to edit a favourite creates an entirely new search.
If you want to replace your current favourite with the new one:
- On the favourite, press Edit .
- Change the search criteria.
- Run the search (, or ).
- Favourite the search result.
- On the Favourite tab, Remove the original favourite.
Favourite searches
Allows you to name and store your favourite searches.
Recent searches contain saved search criteria, not saved search results. If you have changed the data, a set of search criteria may result in a different set of properties.
The Search button displays the search results in the current page, navigating away from the search criteria page.
The Search button displays the search results in an in-page tab.
The Search button displays the search results in a separate browser tab.
The Edit button copies the search criteria, placing it in the Full search tab. You can edit it from there.
The Name tag button allows you to name any search that has already been made a favourite.
Clicking the Favourite 
button removes the search from the favourites tab (but does not remove the search from your recent searches).
The Remove removes the search from the Favourite tab and the Recent tab.