--- title: "/apps-order-service/api/orders/filter" slug: "apps-order-serviceapiordersfilter" updated: 2026-01-09T07:50:19Z published: 2026-01-09T07:50:35Z canonical: "products.egfabri.cloud/apps-order-serviceapiordersfilter" --- > ## Documentation Index > Fetch the complete documentation index at: https://products.egfabri.cloud/llms.txt > Use this file to discover all available pages before exploring further. # /apps-order-service/api/orders/filter Post/apps-order-service/api/orders/filter Body parametersExpand Allobject idinteger (int64) namestring iconstring domainstring subjectstring sourcestring Valid values[ "DRAFT", "QUOTE", "COMMITED", "DELIVERED" ] firstResultinteger (int32) maxResultsinteger (int32) includeSellerboolean followupDateMissingboolean deliveryDateMissingboolean searchTextstring orderTypes Array of string string orderTypesExcluded Array of string string flowIndicators Array of string string Valid values[ "DRAFT", "QUOTE", "COMMITED", "DELIVERED" ] flowIndicatorsExcluded Array of string string Valid values[ "DRAFT", "QUOTE", "COMMITED", "DELIVERED" ] sellerNos Array of string string sellerNosExcluded Array of string string customerNos Array of string string customerNosExcluded Array of string string customerProjectNos Array of string string customerProjectNosExcluded Array of string string departmentNos Array of string string departmentNosExcluded Array of string string warehouseNos Array of string string warehouseNosExcluded Array of string string orderDateobject (apps-order-service_DateFilter) fromAndIncludingstring (date-time) toAndIncludingstring (date-time) orderDateRelativeobject (apps-order-service_RelativeDateFilter) fieldstring Valid values[ "RelativeDateField.DATE" ] fromAndIncludinginteger (int32) toAndIncludinginteger (int32) followupDateobject (apps-order-service_DateFilter) fromAndIncludingstring (date-time) toAndIncludingstring (date-time) followupDateRelativeobject (apps-order-service_RelativeDateFilter) fieldstring Valid values[ "RelativeDateField.DATE" ] fromAndIncludinginteger (int32) toAndIncludinginteger (int32) deliveryDateobject (apps-order-service_DateFilter) fromAndIncludingstring (date-time) toAndIncludingstring (date-time) deliveryDateRelativeobject (apps-order-service_RelativeDateFilter) fieldstring Valid values[ "RelativeDateField.DATE" ] fromAndIncludinginteger (int32) toAndIncludinginteger (int32) coveragePercentobject (apps-order-service_DecimalFilter) fromAndIncludingnumber toAndIncludingnumber sumOrderTotalobject (apps-order-service_DecimalFilter) fromAndIncludingnumber toAndIncludingnumber sumOrderCostobject (apps-order-service_DecimalFilter) fromAndIncludingnumber toAndIncludingnumber lastChangedTimestampobject (apps-order-service_DateFilter) fromAndIncludingstring (date-time) toAndIncludingstring (date-time) lastChangedTimestampRelativeobject (apps-order-service_RelativeDateFilter) fieldstring Valid values[ "RelativeDateField.DATE" ] fromAndIncludinginteger (int32) toAndIncludinginteger (int32) sortFields Array of object (apps-order-service_SortField) object orderFieldstring Valid values[ "ORDER_ID", "ORDER_FLOW_INDICATOR", "ORDER_TYPE", "ORDER_NO", "DELIVERY_METHOD", "DELIVERY_TYPE", "PURCHASE_ORDER_NUMBER", "EXTERNAL_ORDER_NO", "EXTERNAL_ORDER_STATUS", "ORDER_DATE", "DELIVERY_DATE", "FOLLOWUP_DATE", "WAREHOUSE_NO", "CUSTOMER_NO", "CUSTOMER_NAME", "CUSTOMER_PROJECT_NO", "CUSTOMER_PROJECT_NAME", "SELLER_NO", "SELLER_NAME", "SUM_ORDER_TOTAL", "SUM_ORDER_COST", "COVERAGE_PERCENT", "ORDER_INFO_CODE", "CREATED", "LAST_CHANGED" ] sortTypestring Valid values[ "ASC", "DESC" ] selectFields Array of string string Valid values[ "ORDER_ID", "ORDER_FLOW_INDICATOR", "ORDER_TYPE", "ORDER_NO", "DELIVERY_METHOD", "DELIVERY_TYPE", "PURCHASE_ORDER_NUMBER", "EXTERNAL_ORDER_NO", "EXTERNAL_ORDER_STATUS", "ORDER_DATE", "DELIVERY_DATE", "FOLLOWUP_DATE", "WAREHOUSE_NO", "CUSTOMER_NO", "CUSTOMER_NAME", "CUSTOMER_PROJECT_NO", "CUSTOMER_PROJECT_NAME", "SELLER_NO", "SELLER_NAME", "SUM_ORDER_TOTAL", "SUM_ORDER_COST", "COVERAGE_PERCENT", "ORDER_INFO_CODE", "CREATED", "LAST_CHANGED" ] aggregateFields Array of string string Valid values[ "ORDER_ID_COUNT", "ORDER_TOTAL_EX_VAT_SUM", "ORDER_TOTAL_EX_VAT_AVERAGE", "ORDER_TOTAL_INC_VAT_SUM", "ORDER_TOTAL_INC_VAT_AVERAGE", "ORDER_COST_EX_VAT_SUM", "ORDER_COST_EX_VAT_AVERAGE", "COVERAGE_PERCENT_AVERAGE", "MARGIN_SUM", "MARGIN_AVERAGE" ] forOrderTreeboolean Responses200 OK Expand Allobject entities Array of object (apps-order-service_Order) object versioninteger (int64) orderFlowIndicatorstring Valid values[ "DRAFT", "QUOTE", "COMMITED", "DELIVERED" ] orderNointeger (int64) parentOrderNointeger (int64) externalOrderNostring Deprecated externalOrderStatusstring Deprecated orderTypestring Deprecated externalOrderReferences Array of object (apps-order-service_ExternalOrderReference) object externalSystemCodestring externalOrderNostring externalOrderStatusstring externalOrderTypestring departmentNostring warehouseNostring customerobject (apps-order-service_Customer) customerNostring namestring phonestring mobilestring faxstring urlstring emailstring organizationNumberstring defaultOrderDiscountPercentnumber vatFreeboolean addressobject (apps-order-service_Address) namestring address1string address2string postalCodestring citystring countrystring articleCustomerobject (apps-order-service_ArticleCustomer) namestring organizationNumberstring glnstring customerProjectobject (apps-order-service_CustomerProject) idstring projectNostring namestring externalProjectNostring emailstring phonestring mobilestring addressobject (apps-order-service_Address) namestring address1string address2string postalCodestring citystring countrystring orderDatestring (date-time) deliveryDatestring (date-time) expireDatestring (date-time) followupDatestring (date-time) deliveryTypeobject (apps-order-service_DeliveryType) codestring namestring deliveryRouteIdstring deliveryMethodIdstring ourReferencestring customerReferencestring requisitionstring informationstring salespersonobject (apps-order-service_Salesperson) codestring namestring phonestring emailstring responsibleSalespersonobject (apps-order-service_Salesperson) codestring namestring phonestring emailstring deliveryAddressobject (apps-order-service_Address) namestring address1string address2string postalCodestring citystring countrystring coveragePercentnumber orderDiscountPercentnumber totalPurchasePriceExVatnumber totalCostPriceExVatnumber totalDiscountedPriceExVatnumber totalDiscountedPriceIncVatnumber createdTimestampstring (date-time) createdByUserstring lastChangedTimestampstring (date-time) lastChangedByUserstring deletedByUserstring deletedTimestring (date-time) deletedReasonstring orderInfoCodestring calculateVatboolean automaticFeeboolean automaticInvoiceFeeboolean automaticShippingFeeboolean headerTextstring footerTextstring customerPaymentTermCodestring customerContactPersonNostring Deprecated customerContactobject (apps-order-service_CustomerContact) customerContactIdstring namestring phonestring emailstring requiredDepositnumber deductedDepositnumber remainingDepositnumber currencyCodestring targetMarginInPercentnumber priceSourceOrderNostring customerCardNumberstring orderCommands Array of string string Valid values[ "READY_FOR_PACKING", "PACKING_IN_PROCESS", "PACKED_AND_READY", "REST_PROCESSING", "REST_HOLD", "PARTIALLY_DELIVERED", "READY_FOR_TRANSPORT", "TRANSPORT_IN_PROGRESS", "UNKNOWN" ] orderLines Array of object (apps-order-service_OrderLine) object idstring lineNumberinteger (int32) oldLineNumberinteger (int32) lineTypestring Valid values[ "ARTICLE", "TEXT" ] articleNostring articleText1string articleText2string unitCodestring quantitynumber unitPriceExVatnumber unitPriceIncVatnumber costPriceExVatnumber purchasePriceExVatnumber discountPercent1number discountPercent2number specialDiscountPercent1number specialDiscountPercent2number campaignCodestring coveragePercentnumber vatPercentnumber totalCostPriceExVatnumber totalPurchasePriceExVatnumber totalDiscountedPriceExVatnumber totalDiscountedPriceIncVatnumber externalLineStatusstring quantityDeliverednumber quantityRemainingnumber quantityInvoicednumber unitPriceOriginalExVatnumber costPriceOriginalExVatnumber warehouseNostring departmentNostring deliveryTypeCodestring deliveryTypeNamestring deliveryDatestring (date-time) priceCodestring vendorNumberstring externalArticleboolean externalPriceCalculationDescriptionstring externalPriceCostCalculationFactornumber externalPricePurchaseCalculationFactornumber articleTypestring gtinNostring purchaseOrderNumberstring purchaseOrderLineNumberinteger (int32) purchaseOrderStatusstring Valid values[ "PENDING", "FAILED", "OK", "SENT_BY_EMAIL" ] unitVolumeInQmnumber unitWeightInKgnumber parentLineNumberinteger (int32) articleOriginstring Valid values[ "SOLVE" ] lineChosenboolean warehouseEmployeeTextstring transportEmployeeTextstring transportShipmentReferencestring lockKeystring lockDetailsobject (apps-order-service_LockDetails) lockedByUserstring lockedTimestring (date-time) lockSourcestring sourcestring parcels Array of object (apps-order-service_Parcel) object parcelTypestring Valid values[ "TIMBER", "PALLET", "OTHER" ] textstring printerNamestring readyForPickingboolean quoteboolean nexstepExternalOrderNumberstring deletedboolean draftboolean deliveredboolean aggregateobject (apps-order-service_AggregateResult) countinteger (int64) values Array of object (apps-order-service_SelectResultValue) object valueobject stringValuestring fieldstring dataTypestring Valid values[ "INT", "DATE", "STRING", "BIG_DECIMAL" ] alignmentstring Valid values[ "LEFT", "CENTER", "RIGHT" ] totalAggregateobject (apps-order-service_AggregateResult) countinteger (int64) values Array of object (apps-order-service_SelectResultValue) object valueobject stringValuestring fieldstring dataTypestring Valid values[ "INT", "DATE", "STRING", "BIG_DECIMAL" ] alignmentstring Valid values[ "LEFT", "CENTER", "RIGHT" ] columns Array of object (apps-order-service_SelectResultColumn) object fieldstring alignmentstring Valid values[ "LEFT", "CENTER", "RIGHT" ] rows Array of object (apps-order-service_SelectResultRow) object orderIdinteger (int64) lockedboolean deleteAllowedboolean editFollowupDateAllowedboolean values Array of object (apps-order-service_SelectResultValue) object valueobject stringValuestring fieldstring dataTypestring Valid values[ "INT", "DATE", "STRING", "BIG_DECIMAL" ] alignmentstring Valid values[ "LEFT", "CENTER", "RIGHT" ] 400 Bad Request string