Sometimes when formulating a query it helps to view data from the actual data source. The OpenSpirit Data Selector may be used for this purpose. The Data Selector is launched from the OpenSpirit desktop. It includes a Query builder that is based on the same query builder used in the BusinessWorks plug-in for OpenSpirit. Note: The column names in the Desktop Data Selector are based on the chosen model view. If you want the column names to match those seen in the BusinessWorks plug-in for OpenSpirit you will not want to use a model view (as illustrated below) .
Then you will need to select the table you are interested in to have it displayed in the data selector:
Then you may choose which columns to display: