[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

[paulstn]

Screen.Recording.2025-01-15.at.11.16.29.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