+ Add post
Can i anyone help me out to get correct esq query for
SELECT [Account].[Name] FROM [dbo].[Order] LEFT OUTER JOIN [dbo].[Account] ON ([Account].[Id] = [Order].[AccountId] ) WHERE ([Order].[Id]='10643C0B-4932-415C-9150-91458492BBBE')
My esq query:
var esq = Ext.create("Terrasoft.EntitySchemaQuery"...MoreLess
Like
Can anyone help on this?
Hi Susanna, Seems like you have added a wrong column. Correct column in the query will be: esq.AddColumn("Account.Name"); Here you can find...MoreLess
Dmytro,
I tried it is not working.I need to join the two tables Account and Order, retrieve the account name.
Please correct the esq
Susanna Thomas,
Can you show us the console.log. You want get the column account in order. The account is lookup from Order, no need "esq.AddColumn("[Account:Id:AccountId]...MoreLess
