AutoQuery fails when the same table is joined multiple time

ServiceStack Auto Query
1

I am trying to use AutoQuery in a scenario where the same table is joined twice and that’s throwing an error at SQL server The objects “ProjectTask_SubTask” and “ProjectTask_SubTask” in the FROM clause have the same exposed names. Use correlation names to distinguish them.
Is there a way to define aliases for these tables in AutoQuery?

2

No you wont be able to create a query that joins on itself with AutoQuery.

3

Thanks! Is it going to be added in a future release?

4

No, there’s no way to define self-join using AutoQuery. Create a Custom Query/Service.