> For the complete documentation index, see [llms.txt](https://aeudoc.gitbook.io/developer/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://aeudoc.gitbook.io/developer/backend/data-repository/read-all-columns.md). # Read All Columns ## Syntax ``` Get(filter, orderBy, includeProperties, rows); ``` ## Arguments
ArgumentData TypeDescriptionDefault Value
filterExpression<Func<T, bool>>

Criteria by which the records of the repository should be filtered.

This parameter must not be empty.

null

orderBy

Func<IQueryable, IOrderedQueryable>

Order in which the filtered records should be listed.

This parameter is optional.

null
includePropertiesstring

Navigation properties (recognized by the key word "virtual") that should be included.

This parameter is optional.

""
rowsint

Maximal number of records that should be filtered.

This parameter is optional.

0
## Description Gets all records from a repository that fulfill the criteria specified in the parameter *filter*. (Because it loads all columns instead of just specific ones, it is usually slower than "GetFields".) If *orderBy* is not null, it first orders the records according to the attributes specified in the parameter *orderBy* before getting the records from the newly ordered list. If *includeProperties* is not null, it additionally loads the navigation properties that are specified in the parameter *includeProperties*. Navigation properties are "virtual" properties of the repository, i.e. they are not real properties and are accessed by navigating to another object. They would not get loaded unless specified in this parameter. If *rows* is not 0, it makes sure that the number of filtered records does not exceed the specified number. ## Example ### Example 1: Filtering records by only one criterion The following program illustrates the function call with only one criterion: ``` var orderList = repo.Get(x => x.ProductID == "ADAM-567-BTO"); ``` Function will load all the records from the repository that have "ADAM-567-BTO" as Production ID and store the result into the variable "orderList". ### Example 2: Filtering records by multiple criteria The following program illustrates the function call with multiple criteria: ``` var orderList = repo.Get(x => x.ProductID == "ADAM-567-BTO" && x.Quantity > 10 && x.IsUrgent == true); ``` Function will load all the records from the repository that have "ADAM-567-BTO" as Production ID, have a Quantity of more than 10 and are Urgent, and store the result into the variable "orderList". ### Example 3: Filtering records by multiple criteria with order The following program illustrates the function call with multiple criteria and specified order: ``` var orderList = repo.Get(x => x.ProductID == "ADAM-567-BTO" && x.Quantity > 10, o => o.OrderBy(c => c.Timestamp); ``` Function will order the records by their Timestamp attribute, load all the records from the ordered repository that have "ADAM-567-BTO" as Production ID and a Quantity of more than 10, and store the result into the variable "orderList". ### Example 4: Filtering records by multiple criteria with order + maximum limit The following program illustrates the function call with multiple criteria, specified order and maximum limit: ``` var orderList = repo.Get(x => x.ProductID == "ADAM-567-BTO" && c.Quantity > 10, o => o.OrderBy(c => c.Timestamp), "", 100); ``` Function will order the records by their Timestamp attribute, load a maximum of 100 records from the ordered repository that have "ADAM-567-BTO" as Production ID and a Quantity of more than 10, and store the result into the variable "orderList". ### Example 5: Filtering records by multiple criteria with order + maximum limit and including an virtual property The following program illustrates the function call with multiple criteria, specified order, maximum limit and external property: ``` var orderList = repo.Get(x => x.ProductID == "ADAM-567-BTO" && c.Quantity > 10, o => o.OrderBy(c => c.Timestamp), "SapOrder", 100); ``` Function will order the records by their Timestamp attribute, load a maximum of 100 records from the ordered repository that have "ADAM-567-BTO" as Production ID and a Quantity of more than 10, include the virtual property "SapOrder" (a navigation property of "Production Order") and store the result into the variable "orderList".