View – WQX.BINARYOBJECT

View Name: WQX.BINARYOBJECT

View Type: WQX

Description: WQX.BINARYOBJECT returns details of the file(s) associated with WQX data.

Language: English

Output Columns:

TITLE = DT_FILE.TITLE

AUTHOR = DT_FILE.AUTHOR

REMARK = DT_FILE.REMARK

PUBLISHER = DT_FILE.PUBLISHER

FILEDATE = DT_FILE.FILE_DATE

FILENAME = DT_FILE.FILE_NAME

FILETYPE = DT_FILE.FILE_TYPE

PARENTOBJECTTYPE = DT_FILE.PLACE_TYPE

PARENTOBJECTID = DT_FILE.PLACE_CODE

PARENTSUBOBJECTID = DT_FILE.PLACE_SUBCODE

ORGID = DT_FACILITY.FACILITY_CODE

BINARYOBJECTID = DT_FILE.FILE_ID

BINARYOBJECTCONTENT = DT_FILE.CONTENT

Note: DT_FILE.CONTENT is hidden to improve performance. A field that contains a Binary Large Object (BLOB) shows the text “System.Byte[]”.

Tables: DT_FACILITY, DT_FILE

Database Type: SQL

Database Schema: WQX Schema

Database Version: EQuIS 7.0+

Data Requirements: DT_FILE.PLACE_CODE must be populated with an associated PLACE_TYPE for a record to be generated in WQX: Binary Object.

Output Type: Grid