api_external.my_saved_searches
View
The caller's saved marketplace searches and their alert switch (Section 4.4.3).
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Saved search. |
| org_id | uuid | Yes | White-label org the search is limited to; NULL for the whole marketplace. |
| name | text | Yes | Name. |
| role_type | app.external_role_type | Yes | Role type filter. |
| role_code | text | Yes | Canon role filter. |
| cat_urid | text | Yes | Canon category filter. |
| jurisdiction_id | text | Yes | Jurisdiction filter. |
| starts_after | date | Yes | Earliest start. |
| ends_before | date | Yes | Latest end. |
| min_rate_minor | bigint | Yes | Minimum pay in minor units. |
| currency_code | character(3) | Yes | Currency of the minimum. |
| alerts_enabled | boolean | Yes | True when alerts are on. |
| created_at | timestamp with time zone | Yes | When saved. |
| query_text | text | Yes | Words filter. |
| disc_code | text | Yes | Canon discipline filter. |
| certification_name | text | Yes | Required certification filter. |
| near_label | text | Yes | Place the distance filter measures from. |
| near_latitude | double precision | Yes | Latitude of that place. |
| near_longitude | double precision | Yes | Longitude of that place. |
| radius_km | numeric(6,1) | Yes | Distance filter radius in kilometers. |