database view showing duplicate records

will_smith
Mega Guru

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...

find_real_file.png

Results with duplicating numbers

find_real_file.png

10 REPLIES 10

will_smith
Mega Guru

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?