Appearance
Analysis search
There are four ways to search for analyses:
- 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.
![](/screenshot/analyses_search_fields_blank.png)
To use the search form, you can enter:
- one or more property IDs (you can paste these from a spreadsheet if you want);
- one or more sale IDs (you can paste these from a spreadsheet if you want);
- one or more analysis IDs (you can paste these from a spreadsheet if you want);
- one or more dealing numbers (you can paste these from a spreadsheet if you want);
- a district;
- a zone;
- a component (disabled until you select a district);
- a base year;
- a valuer name;
- a lot number;
- a plan number;
- a property type;
- a processing stage;
- a sale code;
- a house number;
- a street name;
- a suburb;
- a contract date range;
- an inspection date range;
- an exported date range;
- whether or not the analysis as been exported; and
- a constraint to include only market data.
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.
- Property ID(s), Sale ID(s) and Analysis ID(s) fields 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 analyses in that district AND with that street name.
The Property ID(s), Sale ID(s) and Analysis ID(s) fields takes a list of Property ID(s), one on each line, or multiple IDs on one line separated by spaces, commas or any non-numeric character. You can get these by pasting in from a spreadsheet or copying IDs 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 analysis.
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:
- Sale analysis
- Property
- Property description
- Property notes
- Contract region
- Property tags
- Future values
- LT values
- LG values
- Property DAs
Each field is listed below by category.
Sale analysis
Field Name | Type | Notes |
---|---|---|
Analysis ID | Number | |
District | Dropdown | Selection from a list of active districts. |
Sale ID | Number | |
Dealing number | Text | |
Analysis zone | Dropdown | |
Analysis component | Text | |
House number | Number | |
Street name | Text | Default comparison type is CONTAINS. ONE OF searches behave a bit differently for street names. Here, it means to find analyses whose street name CONTAINS any of the items in the comma-separated list. |
Suburb | Dropdown | Selection from a list of active suburbs. |
Contract date | Date | |
Settlement date | Date | |
Sale price | Number | |
Property nature | Dropdown | Selection from a list of active property natures. |
Primary purpose | Dropdown | Selection from a list of active primary purposes. |
Sale code | Text | |
Sale source | Text | |
Sale legal description | Text | Default comparison type is CONTAINS. |
Sale notes | Text | Default comparison type is CONTAINS. |
Analysed LV | Number | |
Adjusted LV | Number | |
Multi or Partial property sale | Yes/No | Default value is EITHER. |
Analysis has DA | Yes/No | Default value is EITHER. |
GST paid | Yes/No | Default value is EITHER. |
Market indicator | Yes/No | Default value is YES. |
Out of line | Yes/No | Default value is YES. |
Not suitable for analysis | Yes/No | Default value is YES. |
Has photo (ticked) | Yes/No | Default value is YES. |
Has env. constraints | Yes/No | Default value is YES. |
Base year | Number | |
Analysis units | Number | |
Analysis unit type | Text | |
Total improvement | Number | |
Total adjustment | Number | |
Total market movement | Number | |
Sale summary | Text | Default comparison type is CONTAINS. |
Site description | Text | Default comparison type is CONTAINS. |
Environmental constraints | Text | Default comparison type is CONTAINS. |
General comments | Text | Default comparison type is CONTAINS. |
Analysis date | Date | |
Inspection date | Date | |
Property type | Dropdown | |
Map reference | Text | |
Valuer | Dropdown | Default comparison type is EQUALS. |
Valuer name | Text | Default comparison type is CONTAINS. |
Supervising valuer | Text | Default comparison type is CONTAINS. |
Analysis internal notes | Text | Default comparison type is CONTAINS. |
Is internal analysis | Yes/No | Default value is YES. |
Stage | Text | |
Is exported | Yes/No | Default value is NO. |
Can export | Yes/No | Default value is YES. |
Export date | Yes/No | |
Vendors | Text | Default comparison type is CONTAINS. |
Purchasers | Text | Default comparison type is CONTAINS. |
Analysis property name | Text | Default comparison type is CONTAINS. |
Market movement (percent) | Number | |
Market movement description | Text | Default comparison type is CONTAINS. |
MI construction type | Dropdown | |
MI roof type | Dropdown | |
MI age | Dropdown | |
MI condition | Dropdown | |
MI value | Dropdown | |
MI size | Dropdown | |
MI rate | Dropdown | |
Is vacant | Yes/No | Default value is YES. |
Is paired | Yes/No | Default value is YES. |
Land use code | Dropdown | Selection from a list of active land use codes. Default comparison type is EQUALS. |
In contract region | Yes/No | Default value is YES. |
Is commercial analysis | Yes/No | Default value is YES. |
Is rural analysis | Yes/No | Default value is YES. |
Has ticked report PDF | Yes/No | Default value is YES. |
Property
Field name | Type | Notes |
---|---|---|
Property ID | Number | |
Zone | Dropdown | Selection from a list of active zones. |
Component | Text | You’ll have to type the component code because a list would depend on having selected a district. |
Suburb | Dropdown | Selection from a list of active suburbs. |
Cancelled | Yes/No | Default value is NO. |
House number | Number | |
Street name | Text | Default comparison type is CONTAINS. ONE OF searches behave a bit differently for street names. Here, it means to find analyses whose street name CONTAINS any of the items in the comma-separated list. |
Postcode | Number | |
Owners | Text | Default comparison type is CONTAINS. |
Area | Number | A value ending with h, H, ha or HA will be interpreted as hectares. Anything else will be interpreted as m². |
Apportionment parent | Number | |
Land tax liable | Yes/No | Default value is YES. |
Heritage listing | Text | |
Is strata | Yes/No | Default value is YES. |
Verification type | Dropdown | Selection from a list of active verification types. |
Verification date | Date | |
Property name | 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. |
Property notes
Field name | Type | Notes |
---|---|---|
Land description | Text | Default comparison type is CONTAINS. |
Property internal note | Text | Default comparison type is CONTAINS. |
Property has DA | Yes/No | Default value is YES. |
Has worksheet | Strict Yes/No | Default value is YES. |
For sale | Yes/No | Default value is YES. |
Contract region
Field Name | Type | Notes |
---|---|---|
Contract region | Dropdown |
Property tags
Field name | Type | Notes |
---|---|---|
Tag | Text | Default comparison type is STARTS WITH. |
Future values
Field name | Type | Notes |
---|---|---|
Future LV | Number | |
Future valuation basis | Dropdown | Selection from a list of active valuation bases. |
Future authority code | Dropdown | Selection from a list of active authority codes. |
Future heritage value | Number | |
Future MDAF | Number | |
Future MUAF | Number | |
Future stratum | Number | |
Future on-site | Number | |
Future off-site | Number | |
Future subdivider’s | Number | |
Future unutilised value | Number | |
Future attributable part | Number | |
Future coal | Number | |
Future valuation date | Date | |
Future applied factor | Number | |
Future methodology | Dropdown | Selection from ATTRMATX, OTHRFACT, COMPFACT, REGRADED. |
Future verification method | Dropdown | Selection from VERIFIED, INSPECTD. |
Future verification date | Date | |
Future risk rating | Dropdown | Selection from a list of active risk ratings. |
Future risk code | Dropdown | Selection from a list of active risk codes. |
Future risk rating date | Date | |
Future BM type | Dropdown | Selection from PRIMARY, REFERENCE, SECONDARY. |
Future quartile | Number |
LT values
Field name | Type | Notes |
---|---|---|
LT LV | Number | |
LT corrected LV | Number | |
LT valuation basis | Dropdown | Selection from a list of active valuation bases. |
LT authority code | Dropdown | Selection from a list of active authority codes. |
LT heritage value | Number | |
LT MDAF | Number | |
LT MUAF | Number | |
LT stratum | Number | |
LT on-site | Number | |
LT off-site | Number | |
LT subdivider’s | Number | |
LT unutilised value | Number | |
LT attributable part | Number | |
LT coal | Number | |
LT applied factor | Number | |
LT methodology | Dropdown | Selection from ATTRMATX, OTHRFACT, COMPFACT, REGRADED. |
LT verification method | Dropdown | Selection from VERIFIED, INSPECTD. |
LT verification date | Date | |
LT risk rating | Dropdown | Selection from a list of active risk ratings. |
LT risk code | Dropdown | Selection from a list of active risk codes. |
LT risk rating date | Date | |
LT valuation date | Date | |
LT BM type | Dropdown | Selection from PRIMARY, REFERENCE, SECONDARY. |
LG values
Field name | Type | Notes |
---|---|---|
LG LV | Number | |
LG valuation basis | Dropdown | Selection from a list of active valuation bases. |
LG authority code | Dropdown | Selection from a list of active authority codes. |
LG heritage value | Number | |
LG MDAF | Number | |
LG MUAF | Number | |
LG stratum | Number | |
LG on-site | Number | |
LG off-site | Number | |
LG subdivider’s | Number | |
LG unutilised value | Number | |
LG attributable part | Number | |
LG coal | Number | |
LG applied factor | Number | |
LG methodology | Dropdown | Selection from ATTRMATX, OTHRFACT, COMPFACT, REGRADED. |
LG verification method | Dropdown | Selection from VERIFIED, INSPECTD. |
LG verification date | Date | |
LG risk rating | Dropdown | Selection from a list of active risk ratings. |
LG risk code | Dropdown | Selection from a list of active risk codes. |
LG risk rating date | Date | |
LG valuation date | Date | |
LG BM type | Dropdown | Selection from PRIMARY, REFERENCE, SECONDARY. |
Property DAs
Field name | Type | Notes |
---|---|---|
Application number | Number | Default comparison type is EQUALS. |
Application submitted | Yes/No | Default value is YES. |
Development comments | Text | Default comparison type is CONTAINS. |
Decision | Dropdown | Default comparison type is EQUALS. |
Decision date | Date | Default comparison type is EQUALS. |
Rural land classification
Field name | Type | Notes |
---|---|---|
Land classification | Dropdown | Selection from a list of active land classifications. |
Land classification description | Text | Default comparison type is CONTAINS. |
Land classification area | Number | Default comparison type is BETWEEN. |
Land classification rate | Number | Default comparison type is BETWEEN. |
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.