Hi Team we have comments field in database view but not sure how this is updated?

[Ramu8]

Hi Team
i have database view as configure below but we have comments field and please suggest how it is updated with data?

from which table and field, the comments field data is updated?

inst_metric_type='6fa20d98db4bad109ee932f6f49619e3' && inst_state = 'complete'
us_sys_id=inst_user
inst_sys_id=res1_instance && res1_metric='f8a38d5cdb4bad109ee932f6f4961988'
inst_sys_id=res2_instance && res2_metric='00e34d5cdb4bad109ee932f6f49619d9'

[Tanushree Maiti]

Hi @Ramu8 

From your screen shot , It seems Comments field is part of  asmt_metric_result table.

• Navigate to asmt_metric_result.list in Navigator
• Open a record
• check show xml

[Ramu8]

Hi @Tanushree Maiti thanks for the reply checked using xml still the comments field is not avaialble in asmt_metric_result table

please suggest how this comments(res_string_value) is visible in database view 

[AndersBGS]

Hi @Ramu8 

Based on what you have shared, the comments field is coming from asmt_metric_result meaning the survey comments metric.

[Ramu8]

Hi @AndersBGS thanks for the reply but comments field is not avaialble in asmt_metric_result table

please suggest how this comments(res_string_value) is visible in database view