DPE WorkflowSystem 3.x

DbSearchEntriesByFilter

Searches DigaSystem table for matching entries.

DbSearchEntriesByFilter.png

Properties

DbSearchEntriesByFilter_Properties.png

Input

Name

Description

Table

A DigaSystem table id, e.g. "vm-sql-digas\galileo". Often taken from workflow argument Arg_TableId.

MaxResults

Limit number of results.

XmlFilter

XmlFilter Syntax And Examples

QuerySortOrders

Comma-separated list of sort orders, e.g. “Title Desc,Editor Asc“

Not specifying a value uses the default sort order of DPE ContentService.

Only since DPE v2.4: Set this field to empty string to not use a sort order and make the operation more performant.

ReturnldsOnly

When set to true: omits reading all metadata besides entry ids.

Output

Name

Description

DbCount

Total count of matching entries in database (independent of MaxResults). 

Only since DPE v2.4: property is optional. Leave it empty if you do not need this information amd make the operation more performant.

DbEntries

Matching entries (limited by MaxResults).