Query Parameters

For the following examples, the following file will be used

C:\Users\Admin\CodeSource\ResourceTypes\SubFolder\MY_RESOURCE.xml

Where "CodeSource" is the directory that contains the LobsterConfig.xml file and "ResourceTypes" is the DirectoryDescriptor folder.

:p_filename (MY_RESOURCE.xml)

Contains the full name of the file

:p_filename_without_extension (MY_RESOURCE)

Contains the file without its extension (everything after the last '.') A file named ".git" would have an empty string for this parameter

:p_file_extension (.xml)

Contains the extension of the file (including the '.') For files without and extension, this will be the same as :p_filename

:p_relative_path (ResourceTypes/SubFolder/MY_RESOURCE.xml)

Contains path of the file, relative to the CodeSource directory. For example, a file at C:\Users\Admin\CodeSource\ResourceTypes\SubFolder\MY_RESOURCE.xml where C:\Users\Admin\CodeSource\ResourceTypes is the root directory, :p_relative_path will be set to ResourceTypes\SubFolder\MY_RESOURCE.xml

:p_parent_directory (SubFolder)

Contains the name of the parent directory of the file

:p_full_path (C:\Users\Admin\CodeSource\ResourceTypes\SubFolder\MY_RESOURCE.xml)

Contains the full path of the file

:p_mime_type

Contains the mime type of the file. This has to be computed using the "FileMimeTypeStatement" SQL statement.

:p_data_type

Contains the data type of the file. This has to be computed using the "FileDataTypeStatement" SQL statement, and should only return "CLOB" or "BLOB"

:p_file_content_clob

Contains the content of the file stored as a CLOB.

:p_file_content_blob

Contains the content of the file stored as a BLOB (used for images and other raw files)

:p_footer_message

Contains a message generated by Lobster to help audit who pushed a file last. The message is in the following format: "Last clobbed by user {username} on machine {machineName} at {currentTime} (Lobster build {buildTime})"