Issues submitting Comments in Citizen Problem Manager

Question

I am having an issue submitting multiple comment entries in Citizen Problem Manager.  There are instances when one of the features (ex: Blight Issues) will not allow a single comment entry.  Are there any attributes that I'm overlooking that need to be configured to allow mulitple comments entries?

JodyStroud1 · Answer

Thank you.  This works perfectly.  I see what the issue was and why it was happening.

AllisonMuise1 · Answer

Thank you for the screenshots. The issue is the relationship keys. The relationship is currently configured so that comments are being related to the features using the OBJECTID fields of both the feature class (primary key) and the table (foreign key).

A relationship should work such that the value from the primary key field is written to the foreign key field every time a new record is created in the related table. This means that all comments related to the feature that has OBJECTID 1 (primary key value) should also have the value 1 in their foreign key field, which in your case is also set to the OBJECTID field.

OBJECTID is both a system field, which means that values are generated for it - they can not be specified, and it is the unique key field for the table which means that it cannot contain duplicate values. For these reasons, you are only able to 'relate' one comment with each of your features, and the wrong comment will be associated with each feature because OBJECTID values are generated sequentially.

To fix this, please take a look at the information in step 3 of this topic for configuring the report-comment table relationship for Crowdsource Reporter: http://solutions.arcgis.com/local-government/help/crowdsource-reporter/get-started/configure-app/#votes

JodyStroud1 · Answer

Not quite understanding your first question, but I built a relationship class between each feature class and the associated comments table.  Below is the properties for the relationship class.  I can see all of the comments in the appropriate comments attribute table, however, only one comment (what looks like the first comment) appears per entry when clicking the related records link.

As for the second set of questions; I am testing the entering of comments in both the comments section of the Citizen Problem Reporter and Citizen Problem Manager.  Below, I've already entered a "comment" that has registered.  If I attempt to edit, or add a new record, and save (submit) it, this is the same screen I will see after I've attempted to submit a new comment.  There are no error messages that pop up.