[Discover Autocomplete] TESTID-80: Autocomplete Languages - DQL, SQL, PPL - Verify values

[LDrago27]

Objective

Values are a separate process from keywords or fields. They require some sort of querying aggregation done, with a field name also being required. This tests failure points for value suggestion

What to test

Data type:

1. Index Patterns

2. Indexes

3. S3 Connections (future)

4. Cloudwatch

5. Security Lake

Language:

1. DQL

2. PPL

3. SQL

Scenario	Steps	Expected result	Notes
Example (See below)
DQL	Put in a field name, the OSD type should be keyword. Drop a colon after the field name if it isn't already there. Look for suggestions and verify that they are expected values. Test a field that isn't of type keyword, to ensure there aren't any suggested values. Test a partially formed value.	The values should be the top 10 values for the field, using whatever partially formed value there is.
PPL	Form a query in the format `source =	where =. Ensure that the field is in the index and the field is of OSD typekeyword.</li><li>Look for suggestions and verify that they are the expected values.</li><li>Replace the query in step 1 with source =	where in (,and verify the values are as expected.</li><li>Test a field that isn't of typekeyword`, to ensure there aren't any suggested values.
SQL	Form a query in the format SELECT * FROM <table> WHERE <field> = . Ensure that the field is in the index and the field is of OSD type keyword. Look for suggestions and verify that they are the expected values. Replace the query in step 1 with SELECT * FROM <table> WHERE <field> IN (, and verify the values are as expected. Test a field that isn't of type keyword, to ensure there aren't any suggested values.	The values should be the top X values of that field, where X is set in the advanced settings under query:enhancements:suggestValuesLimit.

Pre-requisites

What do we need to make sure the test can be written

Steps to setting up the scenario

1. Have at least 1 existing workspace with index patterns

2. Turn query enhancements on

3. Select the index pattern

4. Select the language for the test

5. Ensure query:enhancements:suggestValues is on and query:enhancements:suggestValuesLimit is set properly

Known Issues

List of known issues to reference that could impact the results of this test case