Smile CDR v2024.08.PRE
On this page:
   37.4    SQL Syntax: Limitations
  • HFQL: Direct SQL Access
  • 37.0 HFQL/SQL Overview
  • 37.1 SQL Syntax
  • 37.2 SQL Syntax: Select
  • 37.3 SQL Syntax: Where
  • 37.4 SQL Syntax: Limitations
  • 37.5 SQL Syntax: Examples
    •    Table of Contents

    SQL Syntax: Examples

    37.5.1HFQL Syntax Examples

     

    This page contains example HFQL queries.

    37.5.2Find Resources with Repeating Elements

     

    You can select and return only the resources that have multiple repetitions of an element by using a HAVING clause. Note that this query loads each Patient resource from the database in order to test whether to include it in the result set, so it can potentially be very slow if there are many resources that only have a single repetition.

    SELECT id, name[0], name[1]
FROM Patient
HAVING name.count() > 1
       37.4    SQL Syntax: Limitations
  • HFQL: Direct SQL Access
  • 37.0 HFQL/SQL Overview
  • 37.1 SQL Syntax
  • 37.2 SQL Syntax: Select
  • 37.3 SQL Syntax: Where
  • 37.4 SQL Syntax: Limitations
  • 37.5 SQL Syntax: Examples