Subject Wizard - Column Attributes

Top  Previous  Next  


The Subject Wizard - Column Attributes form lets you set certain properties for the columns you have chosen to include in your subject.


To set a Column's properties, first choose the Table that it belongs to using the Available column Treeview.  Click on the Column to select it.  You can then specify the following properties;


Column Label - Very often the column names in a database don't mean very much to it's users.  DataPA lets you specify in your Subjects, the Column names to be used when the users are building their queries.  Simply type the name you wish to use in the 'Column Label' text box.


Allow Column to be used as a Condition - This will default to true if the column belongs one of the database indexes, and false if it doesn't.  This Column lets you determine whether the users can put conditions on the column when building their Queries.  You may set 'Postcode' as a condition column so that the users can build a query which looks for customers in a specific postal area.


Allow Column to be used for Sorting - This will default to true if the  column belongs to a database index, or false if it doesn't.  You may set the 'Salesrep' column to be used for sorting, thus enabling the users to build queries which Sort customer records by who the Sales Rep is.


NOTE: You can not use a column as a Condition or Sort field If the Subject is based on a Smart Data Object and the column is an SDO Calculated Column, or if the Subject is Freeform and the column has multiple extents.


NOTE: If your Subject is made up of multiple tables it may contain columns which come from different tables but which have the same Column Label.  If this happens you will get an error message.  To remedy this, you should change the Column Label of one of the instances of the column.








By 'Clicking' on the Options button you can gain access to additional options.


The pop up menu options allow you to set all your columns so that they may be used for sorting or as condition columns, or reset them to their defaults.


It also allows you to easily reset all the labels from the database labels, or to quickly set all the labels to the database column names or perform a global search and replace on all the column labels.


NOTE:  Non Index columns can be used for Conditions and Sorting but this is not as efficient as using index columns and may cause queries to run slowly.


Once you have set the Column Attributes, click on 'Next >' to move on to the final screen which is Subject Wizard - Finished.


You can click on '< Back' at any time to review and amend the work you have done in the previous screen Subject Wizard - Select Columns.


Copyright © 2003-2017 DataPA Limited, all rights reserved. DataPA OpenAnalytics 6.0