Skip to main content
Lookups and Expressions

Using HighQ isheets as External Tables

HighQ iSheets that have been added to your Contract Express External Table list can be used as an external data source and queried using Select statements. This article provides information on how the data query works for different types of iSheet data.
For more general information on how to use data from external tables, please refer to the articles Accessing external data in the questionnaire and Select Operator (from External Data Source).
iSheet data types
  • Date
     must be passed in the format DD-MM-YYYY and
    date and time
     in the format DD-MM-YYYY HH:MM.
  • File link
     only searches by the file name and will not search by extension (for example, image).
  • Attachment
     column will search with name and extension (for example, image.png).
  • Empty search
     must use Equal and Not Equal operators.
    • For example: (col_1234 Is "") will work, but (col_1234 IsMoreThan "") will not work.
  • To search
    choice
     questions with multi-options, use an OR query.
  • For
    Rich Text Box
    , search by html tag is not supported.
    • For example: (col_123 Is "<html>test</html>") will not work.
  • To search with a
    single quote
     (‘) inside the text string, the symbol must be escaped using \\'.
    • For example: (col_1234 Is "user\\'s data")
  • The
    hyperlink
     column will not return empty data with any operator.

This article applies to:

  • Product: Contract Express