You’re offline. This is a read only version of the page.
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
Well, that I defenitly have tried, but with no success (I cannot drag to metadata, or any of the nodes a query object).
Thanks :)
it is dragable to the metadata node of view.
How and where ? - I see I cannot drag query to the view (I cannot copy to datasource, or any node on the View).
Thanks :)
create the AOT query, there you can specify the join mode to outer join. then drag the query to view.
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?
Thanks :)
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,232
Super User 2024 Season 2
#2
Martin Dráb
230,064
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (