Search for Values
General - Finding Values
The Search for value function of DataChain is accessible from the GenericsData module.
This function allows you to perform a search for values on all or part of the data seen by DataChain or stored in DataChain (such as persisted data and/or extractions generated at repositories).
Performing a search
-
Two search modes can be performed using the Search for values function.
-
Simple search
-
Advanced search
Simple search
The simple search allows you to search for a group of letters (group of letters, word, part of a sentence…) specified in the area on all the data present in the datablocks defined in the
zone.
-
Search criteria input box In the simple mode, this zone is used to enter the group of letters which must be searched for in the data blocks.
-
This area allows you to choose the data blocks (Business Entities and/or DataBlocks) that will be affected by the search. Click in the area to select the data blocks.
Note: this area can be pre-entered. Indeed, a parameter at the level of Business Entities makes it possible to define the default presence of the Business Entity in the
.
Note: in this area, the green labels correspond to the data blocks from the DataBlocks and the labels in black color correspond to Business Entities.
-
Results presentation area. The results are presented in the form of a table. Each row of the table contains the number of rows meeting the search criteria for each data block, the data block label and a magnifying glass icon
. In the event of a positive response, clicking on the magnifying glass icon allows you to view the data returned by the search.
-
The Empty area button is used to empty the area containing the Business Entities and the DataBlocks.
-
Allows you to run the search according to the settings chosen.
Advanced Search
The advanced search for values allows you to carry out a trivialized multi-criteria search. It is used to define a column type (Character string, Numeric or Date), then a criterion value associated with an operator (in line with the column type). This option allows you to define multiple criteria.
-
Search criteria input area In advanced mode, the number of search criteria is multiple. Criteria can be organized into groups and subgroups, linked together by AND or OR.
-
This area is used to delete set criteria, delete groups or add groups.
Note: this area can be pre-entered. Indeed, a parameter at the level of DataBlocks makes it possible to define the default presence of the Entité Métier in the
.
Note: in this area the green labels correspond to the data blocks from DataBlocks and the labels from black color correspond to Business Entities
-
Results presentation area. The results are presented in the form of a table. Each row of the table contains the number of rows meeting the search criteria for each data block, the data block label and a magnifying glass icon
. If the answer is positive, clicking on the magnifying glass icon allows you to view the data.
-
The Add a criterion link allows you to add a criterion in the multi-criteria definition area. Adding a criterion is done as follows:
-
Click on the link
-
Choose a column type (String, Numeric, Date)
-
Specify an operator
-
Specify the value of the criterion
-
-
Allows you to run the search according to the settings chosen.
-
Allows to delete a criterion line, to delete or add a group or a subgroup.
Quick Reference
Value Search
Steps | Objective | Stock | Landmarks |
---|---|---|---|
1 |
Access to the GenericsData module |
Click on GenericData icon |
|
2 |
Value search menu |
Click on label: Value search |
|
3 |
Accuracy of the data blocks concerned |
Choose the Business Entities / DataBlocks |
|
4 |
Search criteria |
Specify the desired value |
|
5 |
Trigger the search |
Use the Search button |
|