[Discover Autocomplete] TESTID-80: Autocomplete Languages - DQL, SQL, PPL - Compound queries w/ logical operators

[LDrago27]

Objective

Test that compounding queries through logical operators (AND / OR ) don't interfere with other suggestions. This is mostly to test value suggestion but also other future developments that require another parse of the query or a symbol table.

What to test

Permutations to consider (only if they apply)

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 Value Suggestion	Write a query in the format <field1>: <value> and <field2>:, where field1 and field2 are different. Verify that the next value suggestions are accurate to field2. Append another partially formed value to field2, and check that the suggestions are as expected.	The values that appear without any partially formed value should be correct. The values that appear with it partially formed should be correct.
PPL/SQL Value Suggestion	Write a query in the format SELECT * FROM <index> WHERE <field1> = <value> AND <field2> =, where field1 and field2 are different. Verify that the next value suggestions are accurate to field2.	The values that appear without any partially formed value should be correct.

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