Navigation:  Configuration > Characteristics >

Sql Text Test Results

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic
Show/Hide Hidden Text

On this tab the following fields can be viewed:

 

hmtoggle_plus1Sql Text Test Results

This tab is applied to test the results of the SQL text created via the SQL Text tab.

If too many results are displayed, the "where" clause was not specific enough and should be enhanced.

 

If the results are in line with expectations, return to the "Maintenance" tab and specify the tables to which the characteristic can be linked.

 

Keep in mind that the value appearing in column 1, will be the value that is saved when the characteristic is linked to a key on a table and will be the value displayed when an inquiry is performed for the characteristic link.