database view showing duplicate records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-02-2016 11:27 AM
I have setup a database view to join the Incident table, the Assessment metric results [asmt_metric_result] table, and Assessment instances [asmt_assessment_instance]. The problem that I am running into is that all of my results are coming back with the same number, even though the assessment values are different. This tells me the records Please see the below screenshot, and thanks for the assistance!
Here is my database view...
Results with duplicating numbers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-06-2016 12:05 PM
ctomasi: Do you have any thoughts on why the view is not pulling the value and string value data across when it exists on the assessment instance question table?