Hi Joshua,
You can try:
select entity.text, document.name from DiscussionMessageAttachmentLink.
Apparently retrieving relations for Discussion messages with CZQL doesn't work.
Hope this helps,
Ophir
Can you please help me with getting the id list of attachments on a discussion post? For cases I am doing this:
Select AttachmentsCount,(Select Name from Documents) from Case
But including "(Select Name from Documents)" for discussion posts doesn't return anything for attachments:
Select Container.Name, AttachmentsCount ,Body,EntityType,post,(select name from documents) from DiscussionMessage
Is there another entity I need to query to get the attachments for discussion messages?
Please sign in to leave a comment.
Hi Joshua,
You can try:
select entity.text, document.name from DiscussionMessageAttachmentLink.
Apparently retrieving relations for Discussion messages with CZQL doesn't work.
Hope this helps,
Ophir
Hi Ophir, that query works, but I need a reference back to the issue that the discussion is a child of. I tried container.name, but that doesn't work. How can I also get the parent id in this query?
Thanks,
Josh
Hi Joshua,
For issues the field name is Title. Check this out:
select entity.text, entity.container.title, document.name from DiscussionMessageAttachmentLink
Hope this helps,
Ophir