DocumentJournalManager.<Document journal name>.Select

Syntax:

Select(<StartDate>, <EndDate>, <Filter>, <Order>)

Parameters:

<StartDate> (optional)

Type: Date.
Start date and time of document selection period. If no parameter is specified, documents are selected starting from the first document in the database.
Default value: Empty date.

<EndDate> (optional)

Type: Date.
End date of selected documents period. If no parameter is specified, documents are selected starting from the first document in the database.
Default value: Empty date.

<Filter> (optional)

Type: Structure.
The structure key refers to a field name, while the structure value refers to the key filter value. You can set only the "Date" and columns of the document journal, for which indexing was enabled during the configuration.
If the parameter is not specified filter is not used.

<Order> (optional)

Type: String.
If no parameter is set, document selection is ordered chronologically in an ascending order.
Specifies the order of returning documents. You can specify the "Date" field or one of the document journal rows provided that all document attributes included in this row are of the same basic type (for example, Numberor String), and all documents in a journal are shown in that column, and indexing was enabled for this column during configuration. After specifying a field name, you can specify the sort order using a space as a separator. To sort in an ascending order choose "Asc", otherwise - "Desc". Sort ascending is used by default.
If no parameter is set, document selection is ordered chronologically in an ascending order.

Returned value:

Type: DocumentSelection.

Description:

Forms selection of documents that are logged in the journal for a certain period.

Availability:

Server, thick client, external connection, Mobile application (server).

Example:

JournallSelection = DocumentJournals.Trade.Select(, WorkingDate);

    

1C:Enterprise Developer's Community