Extract Entity Relationships Using classicEntitySelector in DQL

[paolo_fumanelli]

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

[marco_irmer]

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.

[paolo_fumanelli]

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.

[IzabelaRokita]

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.

[paolo_fumanelli]

Hi Izabela, yes your help would be much appreciated 🙂 

[Julius_Loman]

@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.