Sale 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

info

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 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 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 contract region;
• a house number;
• a street name;
• a suburb;
• a lot number;
• a plan number;
• a sale code;
• a property type;
• a price range;
• a contract date range;
• an area range;
• a vendor;
• a purchaser.

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.

info

In all fields, useful default operators have been selected.

• The Property ID(s) and Sale ID(s) fields matches to ONE OF the provided IDs.
• The same applies to the Dealing(s) field.
• Text fields use the CONTAINS operator.
• All conditions must be met in order to retrieve result rows.

cast_for_education

Search example

If you enter a district and a street name, the system will find sales in that district AND with that street name.

lightbulb

The Property ID(s) and Sale ID(s) fields takes a list of 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 sale.

To use Full search:

1. Select a field.
2. Select a comparator.
3. Enter the search criterion value (if necessary).
4. Press either the Search , Search , or the Search button to run the search.

info

If you have added a search criterion you no longer want, click the Remove button to remove that criterion.

To use a natural language search:

1. Click the Use natural language button.
2. In the popup, type your query in plain text.
3. In the background, the system will send your query to an AI for conversion into search criteria.
4. When it's complete, it will replace your existing search criteria with what it's come up with.
5. Click Done when you're finished with the popup.
6. Check the search criteria to ensure that it's what you meant.
7. Press either the Search , Search , or the Search button to run the search.

info

If a search criterion you don't want has been added, click the Remove button to remove that criterion.

info

On recent versions of Windows, you can press Windows logo key + H to open a recorder that will translate speech into text. So when you open the popup, you can press Windows+H, start speaking, and have your words converted to text in the entry field.

warning

Your typed (or spoken) criteria will be sent to a large language model (LLM, gpt-4o-mini) for conversion into a format MVOW understands. Your text will be processed by, but not retained by, the LLM.

warning

Always check the results of this conversion. Accuracy is not guaranteed.

Fields

The fields that you can search come from multiple categories:

• Sale
• Vendor
• Purchaser
• Sale analysis
• Property
• Property description
• Property notes
• Property DAs
• Contract region
• Property tags
• Future values
• LT values
• LG values

Each field is listed below by category.

Sale

Field Name	Type	Notes
Sale ID	Number
Sale dealing number	Text
Sale zone	Dropdown
Sale 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
Import 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.
Sale analysed	Strict Yes/No	Default value is YES.
Property type	Dropdown	Selection from a list of active property types
Strata lot number	Text
Plan type	Text
Not suitable for analysis	Yes/No
Year flagged as not suitable for analysis	Number
Sale property name	Text
District	Dropdown
Is vacant	Yes/No	Default value is YES. A sale is regarded as a vacant sale if the sale code is active and is flagged as a "vacant" sale code.
In contact region	Yes/No	Default value is YES.
Area	Text	Default comparison type is EQUALS.
Must analyse	Yes/No	Default value is YES. A sale must be analysed if the contract date is after the LT base date AND the sale is a confirmed sale AND the component code is set AND the sale does not have a strata lot number AND AT LEAST ONE OF the following are true: the zone is marked as "must analyse all sales" (Reference items | Zones), OR the zone is marked on the district as "analyse all sales" (Reference items | Districts), OR the sale is a vacant land sale, OR the area is greater than 100ha.
Sale internal notes	Text	Default comparison type is EQUALS.

Vendor

Field Name	Type	Notes
Vendor name	Text	Default comparison type is CONTAINS.

Purchaser

Field Name	Type	Notes
Purchaser name	Text	Default comparison type is CONTAINS.

Sale analysis

Field Name	Type	Notes
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.
Inspection date	Date
Property type	Dropdown
Land use code	Dropdown	Selection from a list of active land use codes.
Map reference	Text
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.
Has commercial lease	Yes/No	Default value is YES.
Is exported	Yes/No	Default value is NO.
Analysis property name	Text	Default comparison type is CONTAINS.

Property

Field name	Type	Notes
Property ID	Number
District	Dropdown	Selection from a list of active districts.
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 sales whose street name CONTAINS any of the items in the comma-separated list.
Postcode	Number
Owners	Text	Default comparison type is CONTAINS.
Frontage	Number	The number will be interpreted as metres.
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.

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.

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 corrected 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 applied factor	Number
Future methodology	Dropdown	Selection from ATTRMATX, OTHRFACT, COMPFACT, REGRADED.
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 a list of benchmark types.
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 verification method	Dropdown	Selection from ATTRMATX, OTHRFACT, COMPFACT, REGRADED.
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 BM type	Dropdown	Selection from a list of benchmark types.

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 verification method	Dropdown	Selection from ATTRMATX, OTHRFACT, COMPFACT, REGRADED.
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 BM type	Dropdown	Selection from a list of benchmark types.

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.

info

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.

report

Removing a search removes it from both the Recent tab and the Favourite tab.

info

Choosing to edit a favourite creates an entirely new search.

If you want to replace your current favourite with the new one:

1. On the favourite, press Edit .
2. Change the search criteria.
3. Run the search (, or ).
4. Favourite the search result.
5. On the Favourite tab, Remove the original favourite.

Favourite searches

Allows you to name and store your favourite searches.

info

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.