Use the ( and ) buttons to group the filter into expressions.To add another expression to the equation, in the Filter pane click at one end of the expression and then click the AND or OR buttons and then New.If you have made a mistake, this gives you a chance to correct the expression. For best practices, click the Validate button. If an error is detected while inputting, an error message will appear to alert you to the problem. Notice once you select this the expression appears in the upper Filter pane. Click Comparison and select a logical expression.If you have just entered the dialog, the Category field is already activated to start creating a filter.For example, if you wanted to use 'GST', but not 'PST', you would select: If you want to perform a comparison using "does not contain" or "is not equal to", SQL requires two expressions. As you make your selection, the next selection is activated and its drop-down list populated with applicable choices. The dialog guides you to build equations. You can build simple or complex equations using information from as many SQL tables as you like. Each expression in the equation is built in the lower half of the screen and then copied to the Filter pane once it is complete. You can filter by alternate code, description or date. Use this dialog to build alternate code equations easily. You are here: Help Topics > The Document Manager > Working with documents and folders > Filtering with alternate codes Alternate Code Editor
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |