I am in the process of setting up NPM, CTA and NCM for about 600 nodes. Almost done! I have been careful to make sure that I could use fields like "City" and "Department" and others properly so I could search on them later using Dynamic Groups.
For example, one field, Comment, I populated something like "ABC's" without the double quotes. When I built a Dynamic Group with the query (Type is Node, and Comment | is | ABC's). After I hit Submit I could not get back into Groups on the menu of NPM. All I got was a "Failed to Render" type error when I clicked on Groups.
Support was able to bring up this bad Dynamic Group Query from the Database. What we saw was similar too (((....... 'Comment' is 'ABC's')...).....). The single quote from the from the search of the field data was Breaking the Query.
Support was able to delete the Dynamic Group Query and do some other maintenance and I was back to work. I then bulk edited all of the data that had a ' (Single Quote). apostrophe
Are there any other characters that I need to watch out for?