Skip to main content

Help

Filter
Messages

Objects

Department pub (Department)
Equipment pub (Equipment)
EquipmentDailyTaskSchedule pub (Equipment Daily Task Schedule)
EquipmentDailyTaskScheduleView pub (Equipment Daily Task Schedule View)
EquipmentStatus pub (Equipment Status)
Feedback pub (Feedback)
ImpositionType (Imposition Type)
Order (Order)
OrderItem (Order Item)
OrderJob (Order Job)
OrderStatistics pub (Order Statistics)
OrderTask (Order Task)
OrderView pub (Order View)
OrderViewSearchableFieldsTemplate (Order View Search Template)
OrderViewStatistics pub (Order View Statistics)
PaperConfig (Paper Config)
PDFXJob (PDFX Job)
PDFXJobCheckResult (PDFX Job Check Result)
PDFXJobFixupResult (PDFX Job Fixup Result)
ProductionTimelineView pub (Production Timeline View)
SearchableFieldsTemplate (Task Board Search Template)
TaskBoard pub (Task Board)
TaskEvent (Task Event)
TaskEventReason (Task Event Reason)
TaskEventView (Task Event View)
TaskStatus pub (Task Status)

Filter

Collection options:

Property Type Title Description
_locale String Locale Locale such as "en_US", "de_DE", "it_IT", "ru_RU", "uk_UA", "sl_SI", "ko_KR"
_pageNo Integer Page number Page number
_perPage Integer Items quantity per page Items quantity per page
_sort String Sort by

i.e.

_sort=PriceAmount-,ID

means sort by PriceAmount descending and ID ascending
_view_collection
or
_view_list 		String First level items view _view_collection - Force view first level items as collection
_view_list - Force view first level items as list (this option is used by default)

Filter options:

Filter type Operator Title Description
_eq = Equal It is default operator. Expression like 
PriceAmount_eq=100
or simple 
PriceAmount=100
finds objects with price amount that equals 100
_lt < Less than 
PriceAmount_lt=100
finds objects with price amount less than 100
_lteq <= Less than or equal 
PriceAmount_lteq=100
finds objects with price amount less than or equal 100
_gt > Greater than 
PriceAmount_gt=100
finds objects with price amount greater than 100
_gteq >= Greater than or equal 
PriceAmount_gteq=100
finds objects with price amount greater than or equal 100

Output options:

Property Type Title Description
_outFormat String Output file format

possible values:

  • json (by default)
  • csv
_outFormat=csv
_outType String Output type

The way to get data:

  • stream - normal output (by default)
  • file - download as a file
_outType=file

Filter example:

https://admin.tracker.mcpdruk.pl/api-v2/crud/Department?token=If5F87X7tMKZB2qVVB1D5XbGCUxEzjDioNZWcIn4AwIP5WIptMZzUFQQn4dAxZXK&_pageNo=2&_perPage=24&_sort=PriceAmount-,ID&PriceAmount_gt=70&PriceAmount_lteq=100

will find Department objects with price amount greater than 70 and less than or equal 100 sorted by price amount descending and id ascending accepting objects on page 2 with maximum quantity 24