In aggregates it is possible to filter on Static entity identifiers, I would like to have the same option in advanced SQL, where you can access the static entity identifiers.
Hi Damian,
It is posssible to achieve by passing static identifiers as input parameters, but I agree that having it as a built-in option would be more convenient.
Hi @Daryna Kravets
I know this is a solution, but having a lot of parameters this make the code a bit messy
I just posted an idea related to this. at least if we can make them as local variables not the input params we don't have to pass it from multiple places whenever you refresh query
