[BUG][Discover] Unable to sort boolean scripted fields

[ananzh]

This is a legacy issue and not caused by Discover 2.0. This functional test is skipped due to this bug:

//add a test to sort boolean
      //existing bug: https://github.com/elastic/kibana/issues/75519 hence the issue is skipped.
      // TODO: replace updateExpectedResultHere with actual data value once bug is fixed
      it.skip('should sort scripted field value in Discover', async function () {
        await sleep(50000);
        await testSubjects.click(`dataGridHeaderCell-${scriptedPainlessFieldName2}`);
        await PageObjects.discover.clickTableHeaderListItem(
          scriptedPainlessFieldName2,
          'Sort True-False'
        );
        await PageObjects.header.waitUntilLoadingHasFinished();
        await testSubjects.click('dataGridHeaderCell-@timestamp');
        await PageObjects.discover.clickTableHeaderListItem('@timestamp', 'Sort A-Z');
        await PageObjects.header.waitUntilLoadingHasFinished();
        const sortedDataByTimeField = await PageObjects.discover.getDataGridTableValues();
        expect(sortedDataByTimeField[0][0]).contain('updateExpectedResultHere');
        expect(sortedDataByTimeField[0][1]).contain('true');

        await testSubjects.click('dataGridColumnSortingButton');
        await PageObjects.discover.removeSort(`${scriptedPainlessFieldName2}`);
        await PageObjects.header.waitUntilLoadingHasFinished();
        const sortedDataByPainlessField = await PageObjects.discover.getDataGridTableValues();
        expect(sortedDataByPainlessField[0][0]).contain('updateExpectedResultHere');
        expect(sortedDataByPainlessField[0][1]).contain('false');
      });

[vvavdiya]

I'd like to take a look at this.
@ananzh can you please help with more context/details of the issue.

[shawnkchan]

Hi, I would like to be assigned this issue! Thank you

[ananzh]

• screen record for helping reproduce the bug

boolean-scripted-field-bug-reproduce.mov