I just wanted to add an update to my scoreboard 'Update Counts' button issue not working. It was due to the syntax in a data partition constraint that we had. Support figured out the cause today and I'm very happy!
The syntax we had was like this:
NOT (group.last_name IN('name1','name2','name3','name4')) OR (group.group_list.member IN (@root.id)) OR group IS NULL OR customer = @root.id
And there needs to be a parenthesis before the NOT, and the end parenthesis after the part that the NOT is meant for.
Like this:
( NOT (group.last_name IN('name1','name2','name3','name4'))) OR (group.group_list.member IN (@root.id)) OR group IS NULL OR customer = @root.id
I'm posting this for 2 reasons --- So that someone else doesn't write the same constraint syntax and cause this issue to happen, and so that anyone who is also experiencing an issue with the 'Update Counts' button not working right can check their data partition constraints for a similar scenario. Here is the tech doc from support that explains the nature of the issue and the solution: https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1227794.html
Thanks, Tammy