# Is it possible to query object and all dependencies in 1 query?

**URL:** <https://discuss.aerospike.com/t/is-it-possible-to-query-object-and-all-dependencies-in-1-query/9609>\
**Category:** Use Cases\
**Tags:** query\
**Created:** [July 19, 2022, 8:15am UTC](https://discuss.aerospike.com/t/is-it-possible-to-query-object-and-all-dependencies-in-1-query/9609 "2022-07-19T08:15:06Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![s.malkevich](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/s.malkevich/32/1905_2.png) [@s.malkevich](https://discuss.aerospike.com/u/s.malkevich)\
**Post date:** [July 19, 2022, 8:15am UTC](https://discuss.aerospike.com/t/is-it-possible-to-query-object-and-all-dependencies-in-1-query/9609/1 "2022-07-19T08:15:06Z")

</div>

We are going to store tasks in aerospike set. Each task has list of dependent tasks so on. For example:

TaskA={id=‘TaskA’, dependencies=[‘TaskB’, ‘TaskC’]}

TaskB={id=‘TaskB’, dependencies=}

TaskC={id=‘TaskC’, dependencies=[‘TaskD’]}

TaskD={id=‘TaskD’, dependencies=}

![image](https://us1.discourse-cdn.com/flex019/uploads/aerospike/original/2X/8/81d56af1a38b019011e2d74c816811f517f99ce3.png)

So I’m looking for most efficient approach how to query TaskA and all it dependencies. In in our example it should return all 4 tasks in 1 query.

---

<div class="post-metadata">

**Author:** ![kporter](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/kporter/32/515_2.png) [@kporter](https://discuss.aerospike.com/u/kporter)\
**Post date:** [July 19, 2022, 3:53pm UTC](https://discuss.aerospike.com/t/is-it-possible-to-query-object-and-all-dependencies-in-1-query/9609/2 "2022-07-19T15:53:18Z")

</div>

If the “dependencies” also included itself, you could use an “IN LIST” query to find all tasks that depend on TaskA which would also include TaskA.

See: [List Indexing and Querying | Aerospike Documentation](https://docs.aerospike.com/server/guide/data-types/cdt-list-index-and-query)

---

<div class="post-metadata">

**Author:** ![pgupta](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/pgupta/32/2351_2.png) [@pgupta](https://discuss.aerospike.com/u/pgupta)\
**Post date:** [July 19, 2022, 5:49pm UTC](https://discuss.aerospike.com/t/is-it-possible-to-query-object-and-all-dependencies-in-1-query/9609/3 "2022-07-19T17:49:41Z")

</div>

Also cross posted in StackOverflow : [How to query all object dependencies reqursively in Aerospike - Stack Overflow](https://stackoverflow.com/questions/73034142/how-to-query-all-object-dependencies-reqursively-in-aerospike)

---

<div class="post-metadata">

**Author:** ![s.malkevich](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/s.malkevich/32/1905_2.png) [@s.malkevich](https://discuss.aerospike.com/u/s.malkevich)\
**Post date:** [July 21, 2022, 10:58am UTC](https://discuss.aerospike.com/t/is-it-possible-to-query-object-and-all-dependencies-in-1-query/9609/4 "2022-07-21T10:58:01Z")

</div>

Can we do it recursively on Aerospike?

---

<div class="post-metadata">

**Author:** ![Albot](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/albot/32/2076_2.png) [@Albot](https://discuss.aerospike.com/u/Albot)\
**Post date:** [July 24, 2022, 5:49pm UTC](https://discuss.aerospike.com/t/is-it-possible-to-query-object-and-all-dependencies-in-1-query/9609/5 "2022-07-24T17:49:30Z")

</div>

No. You can’t join inside the server across records.