Search Valuations
Search Valuation records using field filters and free-text search.
Filtering & lookups
Any field listed below can be filtered on directly for an exact match
(e.g. ?status=active), or suffixed with __<lookup> to use a Django-style
lookup appropriate to that field's type (e.g. ?created__gte=2024-01-01).
Only lookups valid for a given field's type are accepted; see that field's
own description for the ones it supports.
| Lookup | Meaning |
| --- | --- |
| startswith / istartswith | Value starts with the given string (istartswith case-insensitive). |
| endswith / iendswith | Value ends with the given string (iendswith case-insensitive). |
| in | Value is one of a comma-separated list, e.g. ?id__in=1,2,3. |
| gt / gte | Greater than / greater than or equal to. |
| lt / lte | Less than / less than or equal to. |
| range | Value falls between two comma-separated bounds, e.g. ?price__range=100,200. |
| isnull | Field is/isn't null. Pass true or false. |
| date | Matches the date part of a datetime field, e.g. ?created__date=2024-01-01. |
| year / iso_year | Matches the (ISO) year of a date/datetime field. |
| quarter | Matches the quarter (1-4) of a date/datetime field. |
| month | Matches the month (1-12) of a date/datetime field. |
| week / week_day | Matches the ISO week number, or day of the week (1=Sunday...7=Saturday). |
| day | Matches the day of the month (1-31). |
| time | Matches the time part of a datetime field. |
| hour / minute / second | Matches that component of a time/datetime field. |
| contained_by | Array/JSON field is fully contained within the given comma-separated values. |
| overlap | Array field shares at least one element with the given comma-separated values. |
| len | Matches the number of elements in an array field. |
| has_key | JSON field contains the given top-level key. |
| has_keys | JSON field contains all of the given comma-separated top-level keys. |
| has_any_keys | JSON field contains at least one of the given comma-separated top-level keys. |
Combinator suffixes can be appended instead of (or in addition to) a lookup to control how a filter combines with the others on the request:
| Combinator | Meaning |
| --- | --- |
| or | Match this filter optionally — OR'd with the other filters instead of required. |
| not | Exclude records matching this filter. |
| ornot | Exclude records matching this filter, optionally (OR'd with other exclusions). |
| and | Explicitly require this filter alongside the others (the default behaviour). |
HTTP Request
POST/listings/api/v1/valuations/search/
Example Response
{"count": 0,"next": "http://www.example.com","previous": "http://www.example.com","results": [{"id": 0,"site": 0,"lightstone": 0,"lightstone_id": 0,"lightstone_data": null,"residential": "string","commercial": "string","owner": 0,"created": "2026-09-08T14:40:57.096Z","modified": "2026-09-08T14:40:57.096Z","deleted": "2026-09-08T14:40:57.096Z","uuid": "770bba28-9f80-4d40-9c51-6e022364af91","source_ref": "string","template": "string","branch": -2147483648,"agent": -2147483648,"approving_agent": -2147483648,"status": "string","model": "string","location": -2147483648,"comments": "string","valuation_extras": null,"created_by": -2147483648,"updated_by": -2147483648}]}
| Name | Description |
|---|---|
search | string Free-text search across the model's configured search fields |
fields | string Comma-separated list of fields to match the search/trigram query against |
id | string Filter results by exact id. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__any`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith` |
lightstone | string Filter results by exact lightstone. Also accepts any `lightstone__<lookup>` suffix (e.g. `lightstone__in`). |
lightstone_id | string Filter results by exact lightstone_id. Also accepts any `lightstone_id__<lookup>` suffix (e.g. `lightstone_id__in`). |
lightstone_data | string Filter results by exact lightstone_data. **Allowed lookups:** `__or`, `__not`, `__ornot` |
residential | string Filter results by exact residential. Also accepts any `residential__<lookup>` suffix (e.g. `residential__in`). |
commercial | string Filter results by exact commercial. Also accepts any `commercial__<lookup>` suffix (e.g. `commercial__in`). |
owner | string Filter results by exact owner. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith` |
created | string Filter results by exact created. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__contained_by`, `__date`, `__day`, `__endswith`, `__gt`, `__gte`, `__hour`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__minute`, `__month`, `__quarter`, `__range`, `__second`, `__startswith`, `__time`, `__week`, `__week_day`, `__year` |
modified | string Filter results by exact modified. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__contained_by`, `__date`, `__day`, `__endswith`, `__gt`, `__gte`, `__hour`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__minute`, `__month`, `__quarter`, `__range`, `__second`, `__startswith`, `__time`, `__week`, `__week_day`, `__year` |
deleted | string Filter results by exact deleted. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__contained_by`, `__date`, `__day`, `__endswith`, `__gt`, `__gte`, `__hour`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__minute`, `__month`, `__quarter`, `__range`, `__second`, `__startswith`, `__time`, `__week`, `__week_day`, `__year` |
uuid | string Filter results by exact uuid. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith` |
source_ref | string Filter results by exact source_ref. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith` |
template | string Filter results by exact template. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith` |
branch | string Filter results by exact branch. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith` |
agent | string Filter results by exact agent. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith` |
approving_agent | string Filter results by exact approving_agent. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith` |
status | string Filter results by exact status. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith` |
model | string Filter results by exact model. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith` |
location | string Filter results by exact location. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith` |
comments | string Filter results by exact comments. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith` |
valuation_extras | string Filter results by exact valuation_extras. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__has_any_keys`, `__has_key`, `__has_keys`, `__iendswith`, `__in`, `__isnone`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith` |
created_by | string Filter results by exact created_by. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith` |
updated_by | string Filter results by exact updated_by. **Allowed lookups:** `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith` |