[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

[paulstn]

Screen.Recording.2025-01-15.at.11.12.30.AM.mov

[ananzh]

TESTID-80 is re-scoped to

--------------DQL Tests----------------

Initial Editor Interaction

Open the editor and place cursor inside
Verify suggested fields appear


Grammar Keyword Selection

Select any grammar keyword
Verify a colon is automatically added
Verify field value suggestions appear


Invalid Field Testing

Type a non-existent field name followed by a colon
Verify no suggestions appear
Verify suggested fields list remains accessible


Special Character Suggestions

Type underscore (_)
Verify suggested fields include:

*id
*source
Other relevant field suggestions




Category Field Testing

Select 'category' field
Verify field value suggestions appear
Verify grammar keywords (AND/OR) appear
Select 'AND'
Verify new field suggestions appear
Select another field
Verify compound query suggestions appear



--------------PPL Tests--------------

Initial Source Command

Type 's'
Verify Monaco editor displays correctly
Verify 'source' appears in suggestions
Select 'source'


Operator Suggestions

After space, verify '=' operator suggestion
Select '='
Verify field suggestions appear


Index Pattern Suggestions

Verify suggestions include:

data_logs_small_time_1*
data_logs_small_time_2*




Pipe Operator Testing

Select data_logs_small_time_1*
Type '|'
Verify pipe operator suggestions


Command Suggestions

Type 'h'
Verify 'head' suggestion appears
Delete 'h' and type 'w'
Verify 'where' suggestion appears


Where Clause Testing

Select 'where'
Verify field suggestions:

Confirm 'bytes_transferred' appears
Confirm 'bytes_transferred_1' does not appear
Confirm nested fields (e.g., personal.address.city) do not appear


Select 'category'
Verify field value suggestions
Verify AND/OR suggestions after space
Select 'AND'
Select another field
Verify compound query suggestions



--------------SQL Tests--------------

Initial SELECT Statement

Type 'S'
Verify 'SELECT' suggestion
Select 'SELECT'
Verify automatic space addition


Field Selection Suggestions

Verify field suggestions include:

'*' (asterisk)
All available fields


Test partial field search:

Type 'b' (should show bytes_transfer)
Type 'x' (should show no suggestions)


Select '*'


FROM Clause

Verify 'FROM' suggestion appears
Select 'FROM'
Verify index pattern suggestions:

data_logs_small_time_1*
data_logs_small_time_2*




WHERE Clause

Verify 'WHERE' suggestion appears
Select 'WHERE'
Verify field suggestions:

Confirm 'bytes_transferred' appears
Confirm 'bytes_transferred_1' is not shown
Confirm nested fields are not shown


Select 'category'
Verify field value suggestions
Verify AND/OR suggestions
Select 'AND'
Select another field
Verify compound query suggestions



Related Issues to Verify:

#8964: Grammar keyword suggestions
#8965: Field suggestions
#8966: Field value suggestions
#8967: Compound query suggestions

So I won't cover #8969 and #8968 since they are more syntax issues and should be in unit. The reason to have one test to check all the grammer, fields, and fields values can show correctly.

Resolved in #9322 file autocomplete_query.spec.js