# Can I query all existing values of a given property?

**URL:** <https://org-roam.discourse.group/t/can-i-query-all-existing-values-of-a-given-property/3608>\
**Category:** Requests\
**Created:** [October 8, 2024, 10:18am UTC](https://org-roam.discourse.group/t/can-i-query-all-existing-values-of-a-given-property/3608 "2024-10-08T10:18:13Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![nobiot](https://yyz2.discourse-cdn.com/free1/user_avatar/org-roam.discourse.group/nobiot/32/159_2.png) [@nobiot](https://org-roam.discourse.group/u/nobiot)\
**Post date:** [October 8, 2024, 11:25am UTC](https://org-roam.discourse.group/t/can-i-query-all-existing-values-of-a-given-property/3608/2 "2024-10-08T11:25:31Z")

</div>

Is this one-off retrieval, or in every Emacs session or command call?

If you need the list frequently, I’d do a query like this below (replace GEO with AREA — for your purpose, you don’t need to retrieve the ID either), dedupe the same occurrences, and keep the resultant list in a simple list variable.

Or I retrieve the list once, and manually create a list variable in init so that you can manually add/remove from it.

```auto
LAT and LON are decimal degrees of type number (not string)."
  (let ((nodes (org-roam-db-query
                [:select [properties id]
:from nodes
:where (like properties '"%geo%")])))

```

source: [How to use location in org-roam? - #3 by nobiot](https://org-roam.discourse.group/t/how-to-use-location-in-org-roam/3159/3)

---

_[View the full topic](https://org-roam.discourse.group/t/can-i-query-all-existing-values-of-a-given-property/3608)._