dcm4chee
  1. dcm4chee
  2. DCMEE-2106

Support of different value/data types in content_item table

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: dcm4chee-2.18.1
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Tracking Status:
      Risk Analysis - Todo, Test Spec - ToReview, Test State - Not tested
    • Test State:
      NOT tested
    • Risk Analysis:
      Todo
    • Test Spec:
      ToReview
    • Classification:
      Functional Requirement

      Description

      The content_item table provides a means to index and query the content of SR objects. However, it just supports text values and DICOM code values. The content_item table shall be extended in order to support other data types, such as Integer, Float or even Date.

        Activity

        Hide
        Bernhard Ableitinger added a comment -

        Other value types, such as Integer, Floats or even Dates may be stored as text, but are not natively supported. As consequence, dedicated SQL queries are either impossible or rather tricky, e.g. an SQL query for an integer value range such as value between [10,20].

        The request originates from the teaching-file web3 component, which is based on SQL queries of the SR content. A concrete use-case and feature request in teaching-files is the ability to query for patient age ranges, e.g. patient age between [0,2] years.

        Show
        Bernhard Ableitinger added a comment - Other value types, such as Integer, Floats or even Dates may be stored as text, but are not natively supported. As consequence, dedicated SQL queries are either impossible or rather tricky, e.g. an SQL query for an integer value range such as value between [10,20] . The request originates from the teaching-file web3 component, which is based on SQL queries of the SR content. A concrete use-case and feature request in teaching-files is the ability to query for patient age ranges, e.g. patient age between [0,2] years.

          People

          • Assignee:
            Gunter Zeilinger
            Reporter:
            Bernhard Ableitinger
            Testing Assignee:
            Sabine Kolics
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:

              Development