Error : conversion failed when converting from a character string to uniqueidentifier while loading a User-defined datalist

When creating a User-defined datalist the error : "conversion failed when converting from a character string to uniqueidentifier" may occur.
This may be caused by a result field in the source query being improperly used. Remove half of the fields and preview the results. If you continue to get the error remove half of the left over fields. Continue until you have located the offending field. You may start over at any time by closing the query and not saving the changes. 

Steps to Duplicate

Open the query being used for the datalist and click on the "Preview results" tab. Note the error : "conversion failed when converting from a character string to uniqueidentifier"

Environment

 Blackbaud CRM

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.