This option enables the addition of filter fields for the configuration. Tip: You can enable the multiple research in the research fields when selecting the option F3 Multiple? For the negative research (inverted), enter Term the expression <>. For example: AND NSZ010.NSZ_NUMCAS <> #DADO# Informações |
---|
| Necessary fields to organize the researches are available. If there are imported date and the fieldsTable Name and Term bring the reference of the table with different nomenclature, that is, in use, the company 01, but if the import data is company 99, then the reference is NSZ990, when the correct is NSZ010. To execute this adjustment in Other Actions/Update table name to correct data of table in the fields quoted. When activating this option, view notification message indicating there is updating in the fields NAME TABLE and TERM of the tab Configure Field, so tables have their names according to Company/Branch. To confirm, click Yes. |
Note: - To add this configuration in this tab option, view from the left to the right:
- Tables;
- Fields;
- Field Details;
- Notes;
2. On the screen footnote distributed in columns, see: - Code;
- Description;
- Table Name;
- Field Name;
- Term;
- Owner;
- F3 Diff.;
- F3 Query;
- Return F3;
- F3 multiple?
- Research Tp?
3. Select a table, according to the Tables list. 4. Select a field, according to table fields and double click it. 5. The details of the fields are filled out. Check whether you want to edit any configuration 6. Click Save. Important: In case of new table, add the fields, then view the Agreement tab in the Processes routine. Multiple negative search - Click Add, select the table and the field to be configured to filter queries.
2. Select the field using F3 with multiple return selecting the field Multiple F3? 3. When using this type of return, edit the field term, taking into account the return of the field is in the following format: (‘valor1’, ‘valor2’), so the term of this field must have clause “IN” instead “=”. Example: AND NT0010.NT0_COD in (#DADO#) 4. Click Save. 5. To configure a field, and using it as negative/inverted value, run step n°2 and edit the term of the field so the query is different than the value enter. Example: AND NSZ010.NSZ_CCLIEN <> #DADO# 6. In the Tab Configure Research click New, select the type Process then add the configured fields. 7. Click Save. |