Announcements
No record found.
Hello,
I am using the query in the AOT.
Can I join two tables in the query as "left outer join" (that if there are no data on the inner table - it should appear as null)?
Thanks :)
*This post is locked for comments
this is not clear, the task you looking for have no data on inner table and you want parent table record to be null as well, that means parrent and child does not have any information so do you needed empty information ?
or you looking inner where you can have from parents when you have related info in child.
Little confuse ... Maybe I didn't clarified myself ...
It's view (not a query).
What all I need is to use the view object in AOT, and do the simmiliar thing as "outer join" in Microsoft-Sql-Server. (Join two tables in outer join link).
How can I do that?
create the AOT query, there you can specify the join mode to outer join. then drag the query to view.
How and where ? - I see I cannot drag query to the view (I cannot copy to datasource, or any node on the View).
it is dragable to the metadata node of view.
Well, that I defenitly have tried, but with no success (I cannot drag to metadata, or any of the nodes a query object).
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Sagar Suman 2 Super User 2026 Season 1
Alexey Lekanov 2
