Default Intent and Entity

Other than these, skill will have some default intent and entities after training. These are:

• Intent: simpleQuery and example same as intent name.
• Entities:
  • queriedColumns: all the columns of the table/procedure are stored as values for the entity.
  • Tables: all the table names which are uploaded by the user.
  • System Entities: sys-number & sys-date.
  • Aggregator
  Aggregator

  Value	Synonyms
  Average	avg
  Count	Total number, number of
  Distinct	unique
  Maximum	Max, utmost, most, highest, largest, upper limit
  Minimum	Min, lowest, smallest, tiniest, lower limit, least
  Sum	Total amount, total cost

  • groupBy: This entity is used for grouping the result. This is an entity with the same value and synonyms are:
    • per
    • in each
    • grouped on
  • Negator: is an entity to identify not and its value is “not”, and synonym is non.
  • logicalOperator: is an entity to identify “or” which is also the value and synonym. It is used for having logical operator between where clause conditions.
  • Operators: This entity is used to complete where clause condition expression.

  Operators

  Value	Synonyms
  Between	Range
  Equal to	Equals
  Greater than	More than
  Greater than or equal to	After, Greater than or equal to
  Less than	Lesser than
  Less than or equal to	Before, Less than or equal to

  • Sql_boolean: This entity is to identify the Boolean values

  Boolean Expression

  Value	Synonym
  True	True, yes
  False	False, no

  • OrderBy: this entity is used to get ORDER BY clause in sql query.

  Orders

  Value	Synonym
  ascending	Arrange by, arrange in ascending, increasing, order by, order in ascending, rising, sort by, sorted by, low to high
  descending	arrange in descending, decreasing, order in decreasing, sort in decreasing, high to low

  • sql_string: this is to identify string as value. It’s a pattern ['"[^"]+"']