Return to Answer

Preformatted text

Source Link

edit approved Jan 10, 2016 at 15:57

2.1k
3
26
47

One possible solution is to put the Parent field at the parent part, rather the sub-query:

SELECT Name, Id, ( SELECT Id, Title, RecordType, LastModifiedDate, CreatedBy.Name, ParentId from CombinedAttachments WHERE ParentId = '001b0000009ovxS' ORDER BY LastModifiedDate DESC limit 100 ) FROM Account WHERE Id = '001b0000009ovxS'

 SELECT Name, Id, ( SELECT Id, Title, RecordType, LastModifiedDate,
 CreatedBy.Name, ParentId from CombinedAttachments WHERE ParentId =
 '001b0000009ovxS' ORDER BY LastModifiedDate DESC limit 100 ) FROM
 Account WHERE Id = '001b0000009ovxS'

One possible solution is to put the Parent field at the parent part, rather the sub-query:

SELECT Name, Id, ( SELECT Id, Title, RecordType, LastModifiedDate, CreatedBy.Name, ParentId from CombinedAttachments WHERE ParentId = '001b0000009ovxS' ORDER BY LastModifiedDate DESC limit 100 ) FROM Account WHERE Id = '001b0000009ovxS'

One possible solution is to put the Parent field at the parent part, rather the sub-query:

 SELECT Name, Id, ( SELECT Id, Title, RecordType, LastModifiedDate,
 CreatedBy.Name, ParentId from CombinedAttachments WHERE ParentId =
 '001b0000009ovxS' ORDER BY LastModifiedDate DESC limit 100 ) FROM
 Account WHERE Id = '001b0000009ovxS'

Source Link

created Mar 10, 2014 at 22:54

R.Epstein

One possible solution is to put the Parent field at the parent part, rather the sub-query:

SELECT Name, Id, ( SELECT Id, Title, RecordType, LastModifiedDate, CreatedBy.Name, ParentId from CombinedAttachments WHERE ParentId = '001b0000009ovxS' ORDER BY LastModifiedDate DESC limit 100 ) FROM Account WHERE Id = '001b0000009ovxS'