EXACTA:
DESCRIPTION:
Make a query where in BRTechnology we will indicate the technology where we will make the query, in BRTable we will place the query to make without the WHERE clause, in BRFieldSearch we will indicate the field that we would put in the WHERE clause to compare, in BRFieldObjective we will indicate the field from which we will collect the exact search data, and in BRFinConsult we can indicate if any other condition or ORDER BY, GROUP BY clause... is necessary.
EXAMPLE:
Source value: "12
BRTechnology: "Prestashop".
BRTabla: "SELECT id_product, name FROM ps_product_lang".
BRSearchType: "id_product".
BRTargetType: "name".
BRFinQuest: ORDER BY id_lang ASC
QuerySQLSentence: "SELECT id_product, name FROM ps_product_lang WHERE id_product = "12" ORDER BY id_lang ASC".
Processed Value: "Wireless Mechanical Keyboard".
CONFIGURATION:
| Operation | Factor | BRTechnology | BRTabla | BRTypeSearch | BRFieldSearch | BRTargetField | BRFinConsult |
| Consultation | Prestashop | SELECT id_product, name FROM ps_product_lang | Exacta | product_id | name | ORDER BY id_lang ASC | |
CONTENTS:
DESCRIPTION:
Make a query where in BRTechnology we will indicate the technology where we will make the query, in BRTable we will place the query to make without the WHERE clause, in BRSearchField we will indicate the field that we would put in the WHERE clause to compare, in BRTargetField we will indicate the field from which we will collect the data of the contained search, and in BRFinConsult it can be indicated if it is necessary some more condition or ORDER BY clause, GROUP BY...
EXAMPLE:
Source value: "12
BRTechnology: "Prestashop".
BRTabla: "SELECT id_product, name FROM ps_product_lang".
BRSearchType: "id_product".
BRTargetType: "name".
BRFinQuest: ORDER BY id_lang ASC
QuerySQLSentence: "SELECT id_product, name FROM ps_product_lang WHERE id_product = "%" ORDER BY id_lang ASC".
Processed Value: "Wireless Mechanical Keyboard".
CONFIGURATION:
| Operation | Factor | BRTechnology | BRTabla | BRTypeSearch | BRFieldSearch | BRTargetField | BRFinConsult |
| Consultation | Prestashop | SELECT id_product, name FROM ps_product_lang | Content | product_id | name | ORDER BY id_lang ASC | |
START:
DESCRIPTION:
Make a query where in BRTechnology we will indicate the technology where we will make the query, in BRTable we will place the query to make without the WHERE clause, in BRFieldSearch we will indicate the field that we would put in the WHERE clause to compare, in BRTargetField we will indicate the field from which we will collect the data of the search which begins with the SourceValue, and in BRFinQuery we can indicate if it is necessary some more condition or ORDER BY clause, GROUP BY...
EXAMPLE:
Source value: "12
BRTechnology: "Prestashop".
BRTabla: "SELECT id_product, name FROM ps_product_lang".
BRSearchType: "id_product".
BRTargetType: "name".
BRFinQuest: ORDER BY id_lang ASC
QuerySQLSentence: "SELECT id_product, name FROM ps_product_lang WHERE id_product = "12%" ORDER BY id_lang ASC".
Processed Value: "Wireless Mechanical Keyboard".
CONFIGURATION:
| Operation | Factor | BRTechnology | BRTabla | BRTypeSearch | BRFieldSearch | BRTargetField | BRFinConsult |
| Consultation | Prestashop | SELECT id_product, name FROM ps_product_lang | Start | product_id | name | ORDER BY id_lang ASC | |
END:
DESCRIPTION:
Make a query where in BRTechnology we will indicate the technology where we will make the query, in BRTable we will place the query to make without the WHERE clause, in BRFieldSearch we will indicate the field that we would put in the WHERE clause to compare, in BRTargetField we will indicate the field from which we will collect the data of the search which ends with the SourceValue, and in BRFinQuery we can indicate if it is necessary some more condition or ORDER BY clause, GROUP BY...
EXAMPLE:
Source value: "12
BRTechnology: "Prestashop".
BRTabla: "SELECT id_product, name FROM ps_product_lang".
BRSearchType: "id_product".
BRTargetType: "name".
BRFinQuest: ORDER BY id_lang ASC
QuerySQLSentence: "SELECT id_product, name FROM ps_product_lang WHERE id_product = "″ ORDER BY id_lang ASC".
Processed Value: "Wireless Mechanical Keyboard".
CONFIGURATION:
| Operation | Factor | BRTechnology | BRTabla | BRTypeSearch | BRFieldSearch | BRTargetField | BRFinConsult |
| Consultation | Prestashop | SELECT id_product, name FROM ps_product_lang | Ends | product_id | name | ORDER BY id_lang ASC | |
