EntityImage is null while running the SQL FilteredContact View.But am getting EntityImage_url,EntityImageId.
Any one faced this issue???
*This post is locked for comments
I can't think how this could happen under normal circumstances.
Check your ImageDescriptor table - does it have any data in it for ObjectTypeCode=2 (Contact)? Perhaps it has been truncated somehow?
The entityimage field should return the image in binary format in the SQL view.
See inogic.com/.../printing-entity-images-on-reports-in-dynamics-crm-2013
Hope this helps,
Scott
Had the same problem for which I couldn´t find a reason. Finally ended up with this:SELECT ImageDataFROM Filtered*INNER JOIN FilteredImageDescriptor ON ImageDescriptorId = entityimageid
We're seeing the same behaviour but in an inconsistent way - on some installations entityimage contains the binary data and on others it's returned as NULL? The reason I've ended up investigating this is because, when it returns data, the underlying sql on one of the fetchxml queries is invalid and breaks our Resco solution. Would be great if someone could explain why the inconsistency...
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
HR-09070029-0 2
ED-30091530-0 1
