查询以找出QnA知识库中哪些问题未能获得答案 [英] Query to find out what questions failed to get an answer in the QnA knowledge base

问题描述

我想知道在Azure Analytics中用于我的知识库的查询.此查询是为了找出哪些问题未能获得答案(例如，在知识库中找不到很好的匹配项，或者我已经做出了客户答复).

I would like to know what query to use in Azure Analytics for my knowledge base. This query is to find out what questions failed to get an answer (e.g. No good match found in KB or a customer response that I have made).

我已使用此模板并过滤了答案，但并非所有答复都显示出来:

I have used this template and filtered the answers but not all responses showed:

谢谢.

推荐答案

感谢您使用Azure Application Insights.  ;

您可以添加where子句( /span> answer == 在KB中找不到很好的匹配项.") 或您创建的任何其他客户回复，都应为您提供问题记录无法得到答案.

You can include the where clause (answer == "No good match found in KB.") or any other customer responses you have created, which should give you the records for questions failed to get an answer. 

请求

| 其中 "generateAnswer"

    | where url endswith "generateAnswer"

| 项目

    | project timestamp, id, name, resultCode, duration

| parse "/knowledgebases/" KbId " ;/generateAnswer"

    | parse name with *"/knowledgebases/"KbId"/generateAnswer"

| join

    | join kind= inner (

  痕迹| 扩展

    traces | extend id = operation_ParentId

) on

    ) on id

| 扩展 问题" ])

    | extend question = tostring(customDimensions['Question'])

| 扩展 答案" ])

    | extend answer = tostring(customDimensions['Answer'])

| 其中 在KB中找不到很好的匹配项."

    | where answer == "No good match found in KB."

| 项目

    | project KbId, timestamp, resultCode, duration, question, answer

希望这会有所帮助.如果您还有其他问题，请告诉我们. 谢谢.

 Hope this helps. Let us know if you have any further questions. Thank you. 

 

这篇关于查询以找出QnA知识库中哪些问题未能获得答案的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！