-
SELECT EmployeeID- calls the column in the external database that provides the Keyword Value.
-
FROM Employees- retrieves the name of the database table that stores the values retrieved by the Keyword Data Set.
-
WHERE EmployeeID LIKE ‘_filter_%'- provides filtering for returned values.
If you attempt to concatenate (combine) Keyword Values from multiple columns for a Keyword Type with the Keyword Type Must Exist option selected, the query does not return any results. For example, the Keyword Type Must Exist option is selected for the Employee ID Keyword Type. If the first line of your query is SELECT EmployeeID + EmployeeNumber, and the last line of your query is WHERE EmployeeID LIKE '_filter_%', the query is searching for a combined value from the EmployeeID and EmployeeNumber columns and attempting to match it with a value in the EmployeeID column. Because the resulting value does not exist in the EmployeeID column, no results can be returned.