Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Why does Rule State double each Answer in the report?

Summary:

Adding Rule State to Answer Default report doubles every row for each answer.

Content (required):

I want to modify the Answers Default report that is a simple list of Answers to add the versioning and rule state information. When I add the Rule State of the answer to the report, it doubles each answer in the report. Why is this? I added this information to the report in 21C and had no issue with it, now in 21D it is doubling the answers in the report?

If this is related to there being multiple rule state records over time for a given answer and the join replicating a row for each rule state, that wouldn't seem to make sense an answer can only be in one rule state at a time and rule states are showing the same in the report.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!