Query extension samples

This is for:

Developer

In this article

Service and support

Here are some sample use cases for the Query Extensions.

Service and support

The following samples would be used in a Coveo for Salesforce Insight Panel.

Next issue avoidance

Returns parent cases of related cases.

  (NOT @syssfid=={!>id})
  (NOT @syssfcaseid=={!>id})
  /*--- Get the parent cases ---*/
  {{relatedCases = @objecttype=="Case" $some(keywords: '{!>Subject}', match:1) @sfparentcasenumber $correlateResultSet(resultSet: @syssfid=={!Id}, field: '@sysconcepts', maximumValues: '25', modifier: '1000')}}
  ​
  /*--- Extract the parent cases from the related cases ---*/
  $valuesToResultSet(values: $valuesOfField(field: '@sfparentcasenumber', resultSet: {{relatedCases}}), field: '@sfcasenumber')

Returns knowledge docs related to parent cases of related cases.

  (NOT @syssfid=={!>id})
  (NOT @syssfcaseid=={!>id})
  ​
  /*--- Extract related cases ---*/
  {{relatedCases = @objecttype=="Case" $some(keywords: '{!>Subject}', match:1) @sfparentcasenumber $correlateResultSet(resultSet: @syssfid=={!Id}, field: '@sysconcepts', maximumValues: '25', modifier: '1000')}}
  /*--- Extract parent cases of related cases ---*/
  {{parentCases = $valuesToResultSet(values: $valuesOfField(field: '@sfparentcasenumber', resultSet: {{relatedCases}}), field: '@sfcasenumber' )}}
  /*--- Find some relevant knowledge ---*/
  $some(keywords:$removeStopWords(keywords:$anyKeywords(keywords:$valuesOfField(field: '@title', resultSet: {{parentCases}}))))