topic Re: classicEntitySelector to extract relationships in DQL

Extract Entity Relationships Using classicEntitySelector in DQL

paolo_fumanelli — Thu, 18 Dec 2025 12:19:51 GMT

Hi, when extracting relationships with DQL I often get into this warning. See for istance the following:

the usage of classicEntitySelector is suggested is best practices for such cases but how can I get the same result with it?

It's working perfectly when you want to filter for a specific, defined filter (e.g. service id, or name, or any other attribute that can be use as a filter, known in advance), like this:

But how can I express with classicEntitySelector "please add all the services called by each of the fetched services"?

I tried this, but does not work because filter attribute is not constant:

Anyone can help?

Thanks!
Paolo

Re: classicEntitySelector to extract relationships

marco_irmer — Tue, 11 Mar 2025 17:33:50 GMT

It appears that this warning comes up when there are more than 100 relationships on any single record. Based on some experimentation, the number of returned relationships for a given entity appears to be capped at 100 regardless of what is done with filtering. It always comes down to more than 100 entries in the calls[dt.entity.service] field, usually associated with a longer query timeframe. I'm not aware of any way around this outside of shrinking the query timeframe down until it generates less than 100 relationships, which of course may not be applicable in every environment. Perhaps a support request is warranted to shed light on this limitation and potential ways around it.

Re: classicEntitySelector to extract relationships

paolo_fumanelli — Wed, 12 Mar 2025 08:11:54 GMT

Hi Marco, yes that's a possibility but in my case I can't use it because many of the involved services have lots of relationships also with very short timeframes.

Re: classicEntitySelector to extract relationships

IzabelaRokita — Thu, 18 Dec 2025 12:19:29 GMT

Hey @paolo_fumanelli ,
I just wanted to check in and see if you still need help with this. If so, I’d be happy to look into it for you! 😊
Please let me know what works best for you.

Re: classicEntitySelector to extract relationships

paolo_fumanelli — Thu, 18 Dec 2025 13:10:09 GMT

Hi Izabela, yes your help would be much appreciated 🙂

Re: classicEntitySelector to extract relationships

Julius_Loman — Thu, 18 Dec 2025 21:42:58 GMT

@paolo_fumanelli As for now, I don't think you can solve it without narrowing down the result first.
However, this will be solved (afaik) with the upcoming Smartscape in Grail which is just around the corner and will be released soon. At least for the core entities.