Set Up Columns
Set Up Columns specifies a set of fields from AccuWork, and the order in which they will appear as columns in a particular table.
Note: What about column widths?
You don't specify column widths with this option. After finishing this operation, you can drag column separators in the tab from which you invoked Select Columns. You can also drag-and-drop the column headers to rearrange the columns.
Invoking Set Up Columns
The Set Up Columns button appears in the Queries tab, in the Query Results pane toolbar. Use it to specify the format of the table that shows the results of a user-defined AccuWork query.
The Set Up Columns button also appears in the following areas of the Schema Editor (see The Schema Editor (Administrators Only)):
Change Packages tab (Change Package Results pane)
Specifies the format of the tables produced by Show Issues and Show Diff by Issues.
Change Packages tab (Change Package Triggers pane)
Specifies the format of the table displayed by the change-package-level integration between AccuRev and AccuWork.
Relationship Types tab
Specifies the format of the table that shows the set of issue records related to a given issue record.
Using the Columns Dialog
The fields listed under Selected when you click Ok will be displayed in the appropriate table of issue records.
- To move field names from the Available list to the Selected list (or vice-versa), select one or more names, then click the button (or the button).
- To move all field names between the lists, click the or button.
- To rearrange the Selected list, select one or more names, then click the or button.
Field names vs field labels
The names that you work with in the Columns dialog are the actual field names (Name column of the Schema subtab of the AccuWork Schema Editor) In the Query Results pane, the column headers are the corresponding field labels (Label column of the Schema subtab).
Further adjustments, including column-width specifications
You don't specify column widths in the Columns window, just their order. You can adjust column widths and change the order of columns: see Working with Tables.
Multiple-line text fields
You can include a multiple-line text field in the set of columns to be displayed in the Query Results pane, but it's likely that you won't be able to see the complete contents of such fields, no matter how wide you make its column. But when you display an
HTMLfile created by Export Table in a web browser, you'll see the complete contents of every field.
When you click Ok to close the Columns dialog, the changes you've made are reflected immediately in the Query Results pane. But the changes to the query's columns setup are not saved in the repository until you invoke Save All in the Query List pane.