Versions Compared

Old Version 3

changes.mady.by.user Kianusch Sayah Karadji

Saved on

compared with

New Version 4

changes.mady.by.user Kianusch Sayah Karadji

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

NAME

Panel
borderStylesolid

jpdbi - Display and optionaly manipulate DCM4CHE Database entries.

SYNOPTICS

Panel
borderStylesolid

jpdbi [options] [<LastName> [<FirstName> [<Birthdate>]]]

Code Block

DESCRIPTION

Panel
borderStylesolid

jpdbi will query DCM4CHE DB - via jdbc - so you will have access to the DCM4CHE data from command line and even if JBOSS ist not running.

If configured it will also allow updates/changes to the data. e.g. one can change the ISSUER on the PATIENT level both in the database and the DICOM Database BLOB.

jpdbi will display the date beginning at the PATIENT level down to FILES/FILESYSTEM level.

OPTIONS

Panel
borderStylesolid

Help and Version

  • -v|--version
display version information

  • display version information. More v's display more information.
  • -h|--help
display extended help

  • display extended help.
  • --jdbcurlhelp
    display information to the jdbc connection Url.
  • -U|--url
<jdbcURL> DB jdbcURL to connect --db <alias> DB alias to connect Search options: -s|--studyiuid <iuid> Study-IUID -S|--seriesiuid <iuid> Series-IUID --issuer <ISSUER> ISSUER --patid [ISSUER:]PATID (ISSUER and) Patient-ID -d|--date [<date>|<n>] StudyDate or n-past days -m|--modality <MODALITY> Modality -q|--query <statement> Extended query Display Options: -F include fieldnames --aet AET's --pks primary keys --study-level patient+study --series-level +series) --instance-level +instance --path [--fs] +path [+FS information (FS-PK, Group)] --ignorenonempty ignore patients with no studies/series/... Output Options: -O|--out <file> [-z|--gzip] output to (gziped) <file> -E|--err <file> error to <file> --jdbcurlhelp jdbcURL Syntax --debug debug mode

DESCRIPTION

Panel
borderStylesolid

jpdbi will query DCM4CHE DB - via jdbc - so you will have access to the DCM4CHE data from command line and even if JBOSS ist not running.

If configured it will also allow updates/changes to the data. e.g. one can change the ISSUER on the PATIENT level both in the database and the DICOM Database BLOB.

jpdbi will display the date beginning at the PATIENT level down to FILES/FILESYSTEM level.

EXAMPLES

...

  • <jdbcUrl>
    jdbcURL for the destination database to connect to.
  • --db <alias>
    JDBC-connect-url-alias as defined in properties-file.

Search Options

The first three optional command line arguments are defined as Firstname, Lastname and Birthdate. Those three can be combined with any other search option. Searching without any search criteria is not a good idea - specialy for large archives - so it is deactivated. If you really want to display all paties, use a corresponding wildcard.

SQL-Wildcards are supported on most fields. Use % for a multi-character wildcard and _ for a single character wildcard.

  • -s|--studyiuid <studyiuid>
    study-IUID to search for.
  • -S|--seriesiuid <studyiuid>
    series-IUID to search for.
  • --issuer <issuer>
    patient issuer to search for.
  • --patid [<issuer>:]<patid>
    (issuer and) patient-ID to search for.
  • -d|--date <date>|<n>
    if study date is give as "YYYY-MM-DD" - this date is searched for - if a number from 0 to 999 is supplied, studies from the last <n> days is search for. You can also use "today" and "yesterday" as a date string.
  • -m|--modaliy <modality>
    modality to search for.
  • *-q|--query <statement>
    extended query statement. (See corresponding section.)

Display Options

  • -F
    include fieldnames in output. Those names are only for orientation - and are not related to the DB columns nor to the dicom tags.
  • --aet
    include AE-Titles (source-aet, retreive-aet and external retreive-aet) in output.
  • --pks
    include DCM4CHE DB-primary keys in output.

Display Level Options

Default level to be displayed is PATIENT level - one can choose the desired level to display - the chosen level and all levels above will be included in the output.

  • --study-level
    display patient and study
  • --series-level
    display patient, study and series
  • --instance-level
    display patient, study, series and instances
  • --path [--fs]
    display patient, study, series, instances and object-path. Optionaly include filesystem group and PK.
  • --ignorenonempty
    if selected - patients missing studies (series or instances) are not displayed

Output Options

  • -O|--out <file> [-z|--gzip]
    output is redirected to (gezipped) <file>
  • -E|--err <file>
    error/debug (stderr) is redirected to <file>
  • --debug
    debug output on stderr

EXAMPLES

SEE ALSO

jdbexp - a command line generic database query tool.