Change the default string condition to 'Contains' instead of 'Starts With'

[Mike]

Is it possible to change the default string condition from 'Starts With' to 'Contains'?  I tried changing the Operators list with a new one starting with Contains/contains, but the control still uses 'Starts With' as the default.

Blazor control, .NET environment, Windows/MacOS platforms.

[Kundurthi Naga Siddartha Kundurthi Vennela Prasad]

Hi Mike,

 

Yes, it is possible to change the default string condition to Contains instead of Starts With in the Syncfusion Blazor QueryBuilder. The key is to use the DefaultSelectedOperator property at the QueryBuilder level, which sets the default operator for string fields.

 

Here’s a minimal example showing how you can configure it:

@using Syncfusion.Blazor

@using Syncfusion.Blazor.QueryBuilder

 

<SfQueryBuilder TValue="EmployeeDetails" DefaultSelectedOperator="QueryBuilderOperatorType.Contains">

    <QueryBuilderColumns>

        <QueryBuilderColumn Field="EmployeeID" Label="Employee ID" Type="ColumnType.Number"></QueryBuilderColumn>

        <QueryBuilderColumn Field="FirstName" Label="First Name" Type="ColumnType.String"></QueryBuilderColumn>

        <QueryBuilderColumn Field="TitleOfCourtesy" Label="Title of Courtesy" Type="ColumnType.Boolean" Values="Values"></QueryBuilderColumn>

        <QueryBuilderColumn Field="Title" Label="Title" Type="ColumnType.String"></QueryBuilderColumn>

        <QueryBuilderColumn Field="HireDate" Label="Hire Date" Type="ColumnType.Date"></QueryBuilderColumn>

        <QueryBuilderColumn Field="Country" Label="Country" Type="ColumnType.String"></QueryBuilderColumn>

        <QueryBuilderColumn Field="City" Label="City" Type="ColumnType.String"></QueryBuilderColumn>

    </QueryBuilderColumns>

</SfQueryBuilder>

 

Important Notes:

• The property DefaultSelectedOperator="QueryBuilderOperatorType.Contains" ensures that Contains is used as the default operator for string fields.
• You don’t need to override the operators list manually unless you want to customize the available options. The default operator is controlled separately by DefaultSelectedOperator.

 

This approach works consistently across Windows and macOS platforms in a .NET Blazor environment.

 

For your reference, we’ve also included a sample showing this in action along with a GIF demonstration:

Gif:

Sample: https://blazorplayground.syncfusion.com/embed/rthHtUVfJFSkPdIj?appbar=true&editor=true&result=true&errorlist=true&theme=fluent2