spacer
spacer
University of Tennessee at Martin
Martin, TN 38238

Toll Free 1.800.829.UTM1
Local 731.881.7000

Click Here for GPS Direction
Ribbons Decorative

How do I remove or change the order of columns for my query result set?

 

Follow the steps below depending on what software you are using.

 

 

Web Access:

      • Change the order of the columns
            1. Login to Web Access
            2. Right-click on the application
            3. Choose "New Query"
            4. While viewing/changing the Query Criteria
              1. On the left hand side of the 'Index Name' column is a column named 'Show'
              2. To view a column in the query results make sure there is a check in the 'Show' column
              3. To remove a column from the query results remove the check from the 'Show' column
            5. Then you may run your query as normal

 

Document Manager:

      • Change the order of the columns
            1. Log in to ApplicationXtender Document Manager and perform a query
            2. While viewing the result set position/size the columns to your satisfaction (similar to rearranging and sizing columns in windows explorer)
              1. You can move the columns just by clicking on the column you want to move and dragging it to the new position
              2. You can resize the columns placing your cursor on the line between the two columns (your cursor icon will change into an icon with an arrow on each side) and move it the way you want to move it.
              3. Once you get that done, right-click on one of the column headings and choose ‘Save Columns
      • Hide columns
            1. Right-click on one of the column headings
            2. Choose ‘Settings’ then uncheck any columns you don’t want
            3. Once you get that done, right-click on one of the column headings and choose ‘Save Columns’