| # Query Table Fields (ttadv3586m000) This session lists the query table fields that you can select for use in a query chart. To select query table fields, either zoom from the Category Column field, or the Data II Column field in the Query Chart Data (ttadv3185s000) session. Note You must first define these query fields in the Query Data (ttadv3580m000) session. Related topics To add query table fields to a chart Query Field The table field code. A table field is identified by its unique combination of: Package code Module code Table code Field name Bind.Var. If you want to use several functions on the same (non-repeating) table field, you must bind these functions in the text editor. To do this, postfix the functions with a colon and a binding-variable. The binding-variable must be of the form int0..int9 or float0..float9. The int variable displays the result of the function as an integer value, while float displays the result as a floating point number. This means that you cannot use this construction in non-numeric fields. Example select ttaad220.user, min(ttaad220.comp):int0, max(ttaad220.comp):int1 from ttaad220 group by ttaad220.user As output, the query produces a list of users, with the lowest and the highest company numbers they are authorized for. |