Work Order Service Tasks

(1) Share

Report

Posted on by narek

Hi everyone,

I would like to know is it possible to get inspection questions and answers in the plugin code when the service task is 100 percent completed?

Thanks.

I have the same question (0)

All responses (5)

Answers (1)

Maen.Moutaz 239 on at

Like (0)

Report

Work Order Service Tasks

Hello Narek,

Were you able to retrieve the response? I’m facing a similar situation and need to fetch the answer using FetchXML for my SSRS report. Based on the screenshot you provided, I need to extract the "Test" value inside the red circle.

Would appreciate any insights you can share.

Was this reply helpful? Yes No
Verified answer

Vivek Sinha on at

Like (0)

Report

RE: Work Order Service Tasks

Hi,

I think you can try using the 'inspectiondefinitionid' and 'inspectionresponseid' values from the msdyn_workorderservicetasks table.

Let me know if that helps.

Was this reply helpful? Yes No
Fannie30 2,990 Moderator on at

Like (0)

Report

RE: Work Order Service Tasks

I am not sure that is possible at this point in time.

Was this reply helpful? Yes No
narek 42 on at

Like (0)

Report

RE: Work Order Service Tasks

Thank you for your response Ali Khan.

I am familiar with the entities you have mentioned above. This entities are not related to Work Order Service Task. I have forgot to mention in my question that i also need to know from which Work Order Service Task those questions and answers come.

Was this reply helpful? Yes No
Ali Khan 1,380 on at

Like (0)

Report

RE: Work Order Service Tasks

Responses are in the following tables:

Customer Voice survey response or msfp_surveyresponse: a response to an inspection.

Customer Voice survey question response or msfp_questionresponse: each individual response to each inspection question.

Excerpt from (and to read more): docs.microsoft.com/.../inspections-reporting

Was this reply helpful? Yes No