Reporting > Native reporting system > How to edit or add a report > Text Editor > Text mode: Editing the report extraction criteria
  
Text mode: Editing the report extraction criteria
After you select the database fields and indicate the characteristics for each, you must provide the values those fields should hold if they are to be selected for printing. Each of the following commands functions to enable you to do that.
DEFINE command
Indicates that a field must contain a specified variable to be extracted for your report.
FIELD command
Indicates you have user-defined fields in your project on which you want to report.
JOIN command
Moves between database tables to report on two objects having a certain relationship between them.
PARTIAL command
Identifies that information should be extracted even if the conditions defined for extraction are partially met.
WHERE command
Specifies the value that database field should have to be included in the extraction file. 
If you do not use the WHERE command to limit the field selection to those with a specific value, all matching fields, regardless of their value, are included. To better manage and control the report output, use the WHERE command to limit what you select from the database.
SELECT command
Specifies the columns for your report.
Parent topic
Text Editor