List-DT – Create a list of decision tables

extras menu list dt

This function creates a list of all saved decision tables, including program codes ge­ne­ra­ted from it, in the form of an Excel or CSV file.

list dt 01

Necessary parameters

Parameter [short form]
-List-DT "Directory name(s)" [‑ldt]

Generates a list of all decision tables from the “Directory name” directory. It is also possible to specify several directories, separated by the delimiter valid in the operating system (e.g. a semicolon ";" in Windows). If the directory specification is mis­sing, either the current working directory or, if specified, the directory name of the parameter RootDirectory is automatically used.

Optional parameters

Parameter [short form]
-Recursive [-rec]

This parameter causes all subdirectories to be searched, too.
-FileNamePattern "Name pattern" [‑fnp]

Restriction of the processing to files that match the specified name pattern.

Uppercase and lowercase letters are irrelevant.

For masking, you can use the characters
   *  for any string
   ?  for any single character

It is also possible to specify several patterns, separated by a comma or semicolon.
-RootDirectory "Directory name" [‑rd]

This parameter causes all directories in the output relative to the directory specified here to be represented. If the entry for the directory is mis­sing, the directory resulting from the parameter -List-DT is automatically used.
-FileOut "File name" [‑fo]

The output is written to the “File-Name” file.

Permissible file extensions include: ".xls", ".xlsx", ".csv" and ".txt".

If the name ends with ".xls" or ".xlsx", the output is presented directly in MS Excel format. Otherwise, a text file will be created in CSV format.

If the file name is mis­sing, the default setting "LFET-List-DT.xlsx" will be used automatically.
-CreateMissingFolders [‑crmf]

This parameter causes output directories that do not exist yet to be automatically created.
-OpenDirectoryOut [‑odo]

This parameter causes the directory containing the file created by -FileOut to open automatically.

If the parameter -FileOut is mis­sing, generation of the output file with the preset name will be triggered at the same time.
-OpenFileOut [‑ofo]

This parameter causes the file created by FileOut to be automatically opened with the system editor relevant for the file type (e.g., Notepad, MS-Excel, etc.)

If the parameter -FileOut is mis­sing, generation of the output file with the preset name will be triggered at the same time.
-ColorHyperlinks [‑ch]

Hyperlinks in Excel files are not automatically selected in LF‑ET. By specifying this parameter, all hyperlinks are displayed in blue and underlined.
-DelimItem "x" [‑di]

The default column separator (;) can now be changed to another value.

This parameter is only relevant for output in CSV format.
-DelimText "y" [‑dt]

The default column separator (") can now be changed to another value.

This parameter is only relevant for output in CSV format.
-CheckGeneratedSources [‑cgs]

This parameter is used to search for ge­ne­ra­ted source codes for each decision table and to analyse if they are up-to-date.
-CheckSourceImport [‑csi]

You can additionally check if a source import from ge­ne­ra­ted source codes is possible.

Examples of use

A typical form of retrieval is e.g.:

lfetconsole.bat -List-DT -Recursive -OpenFileOut

or in short form:

lfetconsole.bat -list-dt -rec -ofo

Some columns may contain very long or extensive textual information (long folder names, complete texts for decision table, etc.). These columns are simply set very narrow in spreadsheet programs, such as. MS-Excel, so that it can clearly be seen whether a piece of information is included or not. If the content is to be viewed, the corresponding cell is simply marked and the complete content can be viewed in the activated formula bar.

Further information: