Class ObjectQueryExtensions

Namespace

Kentico.Xperience.Admin.Base

Assembly

Kentico.Xperience.Admin.Base.dll

Provides methods for SQL operations while filtering data.

public static class ObjectQueryExtensions

Inheritance

object

ObjectQueryExtensions

Methods

OrderByStartingPriority(ObjectQuery, IEnumerable<string>, string)

Returns a query with its items ordered by whether the values contain a searched for term. Prioritizes items that start with the term over those that only contain it.

public static void OrderByStartingPriority(this ObjectQuery query, IEnumerable<string> searchableColumns, string searchTerm)

Parameters

query ObjectQuery

The query object to perform the OrderBy on.

searchableColumns IEnumerable<string>

A collection of columns by which the query is to be ordered.

searchTerm string

The searchTerm used to determine the priority of ordering.

WhereColumnsContain(ObjectQuery, IEnumerable<string>, string)

Returns a query with filtering those entries that contain a search term in at least one of their columns.

public static void WhereColumnsContain(this ObjectQuery query, IEnumerable<string> searchableColumns, string searchTerm)

Parameters

query ObjectQuery

The query object to perform the Where statement on.

searchableColumns IEnumerable<string>

A collection of columns to be searched for the searchTerm.

searchTerm string

The term to be searched for within the column values.