# DQL: getting called services nested

**URL:** <https://community.dynatrace.com/t/dql-getting-called-services-nested/48849>\
**Category:** DQL\
**Tags:** dql, notebooks\
**Created:** [November 12, 2024, 1:40pm UTC](https://community.dynatrace.com/t/dql-getting-called-services-nested/48849 "2024-11-12T13:40:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![erh\_inetum](https://avatars.discourse-cdn.com/v4/letter/e/48db29/32.png) [@erh\_inetum](https://community.dynatrace.com/u/erh_inetum)\
**Post date:** [November 12, 2024, 1:40pm UTC](https://community.dynatrace.com/t/dql-getting-called-services-nested/48849/1 "2024-11-12T13:40:00Z")

</div>

Hi,

I’m trying to get the called services nested from the other one. I want to get something like this using DQL.

 ![erh_inetum_0-1731418148678.png](https://global.discourse-cdn.com/dynatrace/original/2X/a/aab457a5ff7aba309d81d8d7064e1ed975cd598e.png)

For this I’m launching this query:

fetch dt.entity.service  
|filter entity.name == “MY SERVICE”  
|fieldsAdd entity.name  
|fieldsAdd called\_by  
|filter isNotNull(entity.name)  
|expand service1 = called\_by[dt.entity.service]  
|fieldsAdd service1name = lookup([fetch dt.entity.service],  
sourceField:service1, lookupField:id)[entity.name]  
| join [fetch dt.entity.service | filter entity.name == “SERVICE CALLED BY MY SERVICE”|fieldsAdd entity.name|fieldsAdd called\_by|filter isNotNull(entity.name)|expand service2 = called\_by[dt.entity.service]|fieldsAdd service2name = lookup([fetch dt.entity.service],sourceField:service2, lookupField:id)[entity.name]],  
on: {entity.name}

but it isn´t return results. But if I lauch these queries&nbsp;separately, I get the expected results.

It seems service2 information is not being collected. Because if I launch this:

fetch dt.entity.service  
|filter entity.name == “MY SERVICE”  
|fieldsAdd entity.name  
|fieldsAdd called\_by  
|filter isNotNull(entity.name)  
|expand service1 = called\_by[dt.entity.service]  
|fieldsAdd service1name = lookup([fetch dt.entity.service],  
sourceField:service1, lookupField:id)[entity.name]  
| join [fetch dt.entity.service | filter entity.name == “SERVICE CALLED BY MY SERVICE”|fieldsAdd entity.name|fieldsAdd called\_by|filter isNotNull(entity.name)|expand service2 = called\_by[dt.entity.service]|fieldsAdd service2name = lookup([fetch dt.entity.service],sourceField:service2, lookupField:id)[entity.name]],  
on: {entity.name}  
| fieldsAdd hierarchy = concat(service1, " → ", service2)  
| filter isNotNull(service1name) and isNotNull(service2name)

I get the error

{  
“error”: {  
“message”: “FIELD\_DOES\_NOT\_EXIST”,  
“details”: {  
“exceptionType”: “DQL-RESULT\_TYPE”,  
“syntaxErrorPosition”: {  
“start”: {  
“column”: 50,  
“index”: 803,  
“line”: 11  
},  
“end”: {  
“column”: 57,  
“index”: 810,  
“line”: 11  
}  
},  
“errorType”: “ **FIELD\_DOES\_NOT\_EXIST** ”,  
“errorMessage”: “ **The field service2 doesn’t exist.** ”,  
“arguments”: [  
“service2”  
],  
…

…  
],  
“errorMessageFormat”: “The field %1$s doesn’t exist.”,  
“queryId”: “253effe1-57be-4032-989e-e6937afafcad”  
},  
“code”: 400  
}  
}

What am I doing wrong?

Thanks a lot in advance.

Regards,

Elena.

---

<div class="post-metadata">

**Author:** ![Tiit\_Hallas](https://avatars.discourse-cdn.com/v4/letter/t/cdc98d/32.png) [@Tiit\_Hallas](https://community.dynatrace.com/u/Tiit_Hallas)\
**Post date:** [November 12, 2024, 2:04pm UTC](https://community.dynatrace.com/t/dql-getting-called-services-nested/48849/2 "2024-11-12T14:04:43Z")

</div>

Do you mean something like this?

```markup
fetch dt.entity.service
| fieldsAdd entity.name, 
            called_by = called_by[dt.entity.service], 
            calls = calls[dt.entity.service]
| filter isNotNull(entity.name)
| expand called_by
| expand calls
| filterOut isNull(called_by) or isNull(calls)
| fields hierarchy = concat(entityName(called_by, type:"dt.entity.service"), " => ", entityName(calls, type: "dt.entity.service"))

```

---

<div class="post-metadata">

**Author:** ![erh\_inetum](https://avatars.discourse-cdn.com/v4/letter/e/48db29/32.png) [@erh\_inetum](https://community.dynatrace.com/u/erh_inetum)\
**Post date:** [November 13, 2024, 7:10am UTC](https://community.dynatrace.com/t/dql-getting-called-services-nested/48849/3 "2024-11-13T07:10:14Z")

</div>

Hi&nbsp;[@Tiit\_Hallas](https://community.dynatrace.com/user/56833)&nbsp;,

Yes, this is that I need.

Thank you very much 🙂

Regards,

Elena