Error: Conversion failed when converting from a character string to uniqueidentifier - When previewing the results of a query

When trying to preview the results of a query that you are building, you may encounter the error "Conversion failed when converting from a character string to uniqueidentifier."
This issue was resolved in version 4.5

Steps to Duplicate

  1. Go to Analysis > Information Library.
  2. Click Add an ad-hoc query
  3. Select the Constituents source view
  4. On the left, select Constituencies
  5. From the middle, move Constituency to the top right
  6. Change "Equal to" to "One of"
  7. Move multiple constituencies from the left to the right
  8. Mark the "Only return records that match all selected values" box
  9. Click Ok
  10. Go to Preview results tab

Environment

 Altru Arts & Cultural

Was this article helpful?