# Querying all references to an object

**URL:** <https://connect.superhuman.com/t/querying-all-references-to-an-object/34756>\
**Category:** Ask the Community\
**Created:** [October 22, 2022, 9:04pm UTC](https://connect.superhuman.com/t/querying-all-references-to-an-object/34756 "2022-10-22T21:04:34Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sarah\_Heyborne1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/sarah_heyborne1/32/48681_2.png) [@Sarah\_Heyborne1](https://connect.superhuman.com/u/Sarah_Heyborne1)\
**Post date:** [October 22, 2022, 9:04pm UTC](https://connect.superhuman.com/t/querying-all-references-to-an-object/34756/1 "2022-10-22T21:04:34Z")

</div>

Hi all,

I’m working in my CRM and want to be able to pull all references to various entities. For example, I have a notes field on my ‘Organizations’ table as a catch all for anything that I haven’t managed to structure more formally. In a note for one organization I wrote:  
_Discovered [this company] from @Person at @Meeting)_  
When I got to @Person’s record, I would like to have a formula that pulls in anywhere said person is referenced. So e.g. I would want that organizations page to be linked somehow (ideally in lookup/object format but in reference format is also great).

Does anyone have a cheat for doing this? I know I could filter my primary tables to pull any objects whose Notes column referenced my currently selected object (they @Person record in the example above), but I’d like to not have to list out every possible table and table field where the reference could occur and instead have a sort of search function like what the search in the sidebar does.

---

<div class="post-metadata">

**Author:** ![Quentin\_Morel](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/quentin_morel/32/31407_2.png) [@Quentin\_Morel](https://connect.superhuman.com/u/Quentin_Morel)\
**Post date:** [October 23, 2022, 12:20am UTC](https://connect.superhuman.com/t/querying-all-references-to-an-object/34756/2 "2022-10-23T00:20:17Z")

</div>

Hello @Sarah_Heyborne1

this is a very interesting question. I do not have the answer, but it makes me think obviously to **obsidian** core and relationship between object, where you can see directly all existing link in the page. Not sure if this is possible in coda, as it may require to scan all pages of the doc, all tables of the doc, and I do not know what kind of formula may reach that power… wait for better coda master than myself 😉 I’ll watch this feed, as it could be a (new, again!) game changer for me !

---

<div class="post-metadata">

**Author:** ![Sarah\_Heyborne1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/sarah_heyborne1/32/48681_2.png) [@Sarah\_Heyborne1](https://connect.superhuman.com/u/Sarah_Heyborne1)\
**Post date:** [October 25, 2022, 7:17pm UTC](https://connect.superhuman.com/t/querying-all-references-to-an-object/34756/3 "2022-10-25T19:17:21Z")

</div>

Thanks for the response @Quentin_Morel! I wasn’t familiar with obsidian before, that does feel very similar to the functionality I’m looking for.

The Coda search bar does a pretty good job of this task, I actually think what I’m asking for would be a scale back of the search functionality as it is currently. Instead of searching all text in all records, the search would only return objects that make that specific @-link.

---

<div class="post-metadata">

**Author:** ![Thomas\_Robbs1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/thomas_robbs1/32/9234_2.png) [@Thomas\_Robbs1](https://connect.superhuman.com/u/Thomas_Robbs1)\
**Post date:** [November 8, 2022, 1:23pm UTC](https://connect.superhuman.com/t/querying-all-references-to-an-object/34756/4 "2022-11-08T13:23:12Z")

</div>

I just was searching for the same functionality and found your post. Perhaps there isn’t a way to do this?

If not, I’d encourage you to move this idea to the Suggestion Box as it’s a very useful idea to have implemented.

---

<div class="post-metadata">

**Author:** ![Sarah\_Heyborne1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/sarah_heyborne1/32/48681_2.png) [@Sarah\_Heyborne1](https://connect.superhuman.com/u/Sarah_Heyborne1)\
**Post date:** [November 8, 2022, 4:33pm UTC](https://connect.superhuman.com/t/querying-all-references-to-an-object/34756/5 "2022-11-08T16:33:30Z")

</div>

Good flag, thank you @Thomas_Robbs1

---

<div class="post-metadata">

**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\
**Post date:** [November 8, 2022, 5:31pm UTC](https://connect.superhuman.com/t/querying-all-references-to-an-object/34756/6 "2022-11-08T17:31:37Z")

</div>

@joost_mineur , @Max_OBrien

Hi guys, If I remember correctly, one of you mentioned, a month or so in the community, using this kind functionality?

Regards  
Piet

---

<div class="post-metadata">

**Author:** ![joost\_mineur](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joost_mineur/32/30539_2.png) [@joost\_mineur](https://connect.superhuman.com/u/joost_mineur)\
**Post date:** [November 8, 2022, 11:32pm UTC](https://connect.superhuman.com/t/querying-all-references-to-an-object/34756/7 "2022-11-08T23:32:27Z")

</div>

I don’t think it was me, I also can’t remember having run into a need for this type of functionality.

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [February 6, 2023, 11:32pm UTC](https://connect.superhuman.com/t/querying-all-references-to-an-object/34756/8 "2023-02-06T23:32:29Z")

</div>

Closed on February 6, 2023, 11:32pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
