What is it and how do I edit it?
Looks to be a Computed Column in a Query. You should be able to search for 'Computed Columns' in the Designer Guide to get more info, but here is the short version from the guide:
You can create computed columns in a query which is based on tables, views, and synonyms from one JDBC connection only.
In the lower part of the dialog box, there are functions and tables/columns of the query. They are just for your reference. You can specify the expression by yourself in the editing text box, only if the expression can be accepted by your database.
In addition, the functions in this dialog box are not from the Logi Report system. They are from the database you are connecting to. For each database, you may get a different set of the functions. Thus, if you change your database, some of these functions may no longer exist. You can use the following functions to write an expression:
Designer places the computed columns you add to a query in the criteria panel of the Query Editor dialog box together with the table columns in the query. If you want to edit a computed column, you can double-click its name in the criteria panel and then edit it in the dialog box Designer displays.
After you create a computed column, Designer adds it to the SQL of the query. Suppose you have added a computed column named "Net Total" in a query and the computation is @UNITPRICE * @QUANTITY * (100 - @DISCOUNT) / 100, when you view the SQL statements of the query, you see the following SQL statement being inserted into the SQL: @UNITPRICE * @QUANTITY * (100 - @DISCOUNT) / 100 AS "Net Total".
Please sign in to leave a comment.