JiwaAPI

BM_WorkOrderStagesQuery

**BM_WorkOrderStagesQuery** Parameters:
Name	Parameter	Data Type	Required
RecID	query	string	No
RecIDStartsWith	query	string	No
RecIDEndsWith	query	string	No
RecIDContains	query	string	No
RecIDLike	query	string	No
RecIDBetween	query	string[]	No
RecIDIn	query	string[]	No
BM_WorkOrder_RecID	query	string	No
BM_WorkOrder_RecIDStartsWith	query	string	No
BM_WorkOrder_RecIDEndsWith	query	string	No
BM_WorkOrder_RecIDContains	query	string	No
BM_WorkOrder_RecIDLike	query	string	No
BM_WorkOrder_RecIDBetween	query	string[]	No
BM_WorkOrder_RecIDIn	query	string[]	No
ItemNo	query	int?	No
ItemNoGreaterThanOrEqualTo	query	int?	No
ItemNoGreaterThan	query	int?	No
ItemNoLessThan	query	int?	No
ItemNoLessThanOrEqualTo	query	int?	No
ItemNoNotEqualTo	query	int?	No
ItemNoBetween	query	int[]	No
ItemNoIn	query	int[]	No
Name	query	string	No
NameStartsWith	query	string	No
NameEndsWith	query	string	No
NameContains	query	string	No
NameLike	query	string	No
NameBetween	query	string[]	No
NameIn	query	string[]	No
BM_WarehouseProductionLineWorkCentre_RecID	query	string	No
BM_WarehouseProductionLineWorkCentre_RecIDStartsWith	query	string	No
BM_WarehouseProductionLineWorkCentre_RecIDEndsWith	query	string	No
BM_WarehouseProductionLineWorkCentre_RecIDContains	query	string	No
BM_WarehouseProductionLineWorkCentre_RecIDLike	query	string	No
BM_WarehouseProductionLineWorkCentre_RecIDBetween	query	string[]	No
BM_WarehouseProductionLineWorkCentre_RecIDIn	query	string[]	No
RequiredCapacity	query	decimal?	No
RequiredCapacityGreaterThanOrEqualTo	query	decimal?	No
RequiredCapacityGreaterThan	query	decimal?	No
RequiredCapacityLessThan	query	decimal?	No
RequiredCapacityLessThanOrEqualTo	query	decimal?	No
RequiredCapacityNotEqualTo	query	decimal?	No
RequiredCapacityBetween	query	Nullable<Decimal>[]	No
RequiredCapacityIn	query	Nullable<Decimal>[]	No
Status	query	byte?	No
StatusGreaterThanOrEqualTo	query	byte?	No
StatusGreaterThan	query	byte?	No
StatusLessThan	query	byte?	No
StatusLessThanOrEqualTo	query	byte?	No
StatusNotEqualTo	query	byte?	No
StatusBetween	query	byte[]	No
StatusIn	query	byte[]	No
RowHash	query	byte[]	No
StartDate	query	DateTime?	No
StartDateGreaterThanOrEqualTo	query	DateTime?	No
StartDateGreaterThan	query	DateTime?	No
StartDateLessThan	query	DateTime?	No
StartDateLessThanOrEqualTo	query	DateTime?	No
StartDateNotEqualTo	query	DateTime?	No
StartDateBetween	query	DateTime[]	No
StartDateIn	query	DateTime[]	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**BM_WorkOrderStages** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
BM_WorkOrder_RecID	form	string	No
ItemNo	form	int	No
Name	form	string	No
BM_WarehouseProductionLineWorkCentre_RecID	form	string	No
RequiredCapacity	form	decimal?	No
Status	form	byte	No
RowHash	form	byte[]	No
StartDate	form	DateTime	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml

HTTP + XML

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /xml/reply/BM_WorkOrderStagesQuery HTTP/1.1 
Host: jiwaapi.stotthoare.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<BM_WorkOrderStagesQuery xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
  <Fields xmlns="http://schemas.servicestack.net/types">String</Fields>
  <Include xmlns="http://schemas.servicestack.net/types">String</Include>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.servicestack.net/types">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <OrderBy xmlns="http://schemas.servicestack.net/types">String</OrderBy>
  <OrderByDesc xmlns="http://schemas.servicestack.net/types">String</OrderByDesc>
  <Skip xmlns="http://schemas.servicestack.net/types">0</Skip>
  <Take xmlns="http://schemas.servicestack.net/types">0</Take>
  <BM_WarehouseProductionLineWorkCentre_RecID>String</BM_WarehouseProductionLineWorkCentre_RecID>
  <BM_WarehouseProductionLineWorkCentre_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BM_WarehouseProductionLineWorkCentre_RecIDBetween>
  <BM_WarehouseProductionLineWorkCentre_RecIDContains>String</BM_WarehouseProductionLineWorkCentre_RecIDContains>
  <BM_WarehouseProductionLineWorkCentre_RecIDEndsWith>String</BM_WarehouseProductionLineWorkCentre_RecIDEndsWith>
  <BM_WarehouseProductionLineWorkCentre_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BM_WarehouseProductionLineWorkCentre_RecIDIn>
  <BM_WarehouseProductionLineWorkCentre_RecIDLike>String</BM_WarehouseProductionLineWorkCentre_RecIDLike>
  <BM_WarehouseProductionLineWorkCentre_RecIDStartsWith>String</BM_WarehouseProductionLineWorkCentre_RecIDStartsWith>
  <BM_WorkOrder_RecID>String</BM_WorkOrder_RecID>
  <BM_WorkOrder_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BM_WorkOrder_RecIDBetween>
  <BM_WorkOrder_RecIDContains>String</BM_WorkOrder_RecIDContains>
  <BM_WorkOrder_RecIDEndsWith>String</BM_WorkOrder_RecIDEndsWith>
  <BM_WorkOrder_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BM_WorkOrder_RecIDIn>
  <BM_WorkOrder_RecIDLike>String</BM_WorkOrder_RecIDLike>
  <BM_WorkOrder_RecIDStartsWith>String</BM_WorkOrder_RecIDStartsWith>
  <ItemNo>0</ItemNo>
  <ItemNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoBetween>
  <ItemNoGreaterThan>0</ItemNoGreaterThan>
  <ItemNoGreaterThanOrEqualTo>0</ItemNoGreaterThanOrEqualTo>
  <ItemNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoIn>
  <ItemNoLessThan>0</ItemNoLessThan>
  <ItemNoLessThanOrEqualTo>0</ItemNoLessThanOrEqualTo>
  <ItemNoNotEqualTo>0</ItemNoNotEqualTo>
  <Name>String</Name>
  <NameBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NameBetween>
  <NameContains>String</NameContains>
  <NameEndsWith>String</NameEndsWith>
  <NameIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NameIn>
  <NameLike>String</NameLike>
  <NameStartsWith>String</NameStartsWith>
  <RecID>String</RecID>
  <RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RecIDBetween>
  <RecIDContains>String</RecIDContains>
  <RecIDEndsWith>String</RecIDEndsWith>
  <RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RecIDIn>
  <RecIDLike>String</RecIDLike>
  <RecIDStartsWith>String</RecIDStartsWith>
  <RequiredCapacity>0</RequiredCapacity>
  <RequiredCapacityBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </RequiredCapacityBetween>
  <RequiredCapacityGreaterThan>0</RequiredCapacityGreaterThan>
  <RequiredCapacityGreaterThanOrEqualTo>0</RequiredCapacityGreaterThanOrEqualTo>
  <RequiredCapacityIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </RequiredCapacityIn>
  <RequiredCapacityLessThan>0</RequiredCapacityLessThan>
  <RequiredCapacityLessThanOrEqualTo>0</RequiredCapacityLessThanOrEqualTo>
  <RequiredCapacityNotEqualTo>0</RequiredCapacityNotEqualTo>
  <RowHash>AA==</RowHash>
  <StartDate>0001-01-01T00:00:00</StartDate>
  <StartDateBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </StartDateBetween>
  <StartDateGreaterThan>0001-01-01T00:00:00</StartDateGreaterThan>
  <StartDateGreaterThanOrEqualTo>0001-01-01T00:00:00</StartDateGreaterThanOrEqualTo>
  <StartDateIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </StartDateIn>
  <StartDateLessThan>0001-01-01T00:00:00</StartDateLessThan>
  <StartDateLessThanOrEqualTo>0001-01-01T00:00:00</StartDateLessThanOrEqualTo>
  <StartDateNotEqualTo>0001-01-01T00:00:00</StartDateNotEqualTo>
  <Status>0</Status>
  <StatusBetween>AA==</StatusBetween>
  <StatusGreaterThan>0</StatusGreaterThan>
  <StatusGreaterThanOrEqualTo>0</StatusGreaterThanOrEqualTo>
  <StatusIn>AA==</StatusIn>
  <StatusLessThan>0</StatusLessThan>
  <StatusLessThanOrEqualTo>0</StatusLessThanOrEqualTo>
  <StatusNotEqualTo>0</StatusNotEqualTo>
</BM_WorkOrderStagesQuery>

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfBM_WorkOrderStages7kRqkrSv xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.servicestack.net/types">
  <Offset>0</Offset>
  <Total>0</Total>
  <Results xmlns:d2p1="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
    <d2p1:BM_WorkOrderStages>
      <d2p1:_x003C_BM_WarehouseProductionLineWorkCentre_RecID_x003E_k__BackingField>String</d2p1:_x003C_BM_WarehouseProductionLineWorkCentre_RecID_x003E_k__BackingField>
      <d2p1:_x003C_BM_WorkOrder_RecID_x003E_k__BackingField>String</d2p1:_x003C_BM_WorkOrder_RecID_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>0</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_Name_x003E_k__BackingField>String</d2p1:_x003C_Name_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_RequiredCapacity_x003E_k__BackingField>0</d2p1:_x003C_RequiredCapacity_x003E_k__BackingField>
      <d2p1:_x003C_RowHash_x003E_k__BackingField>AA==</d2p1:_x003C_RowHash_x003E_k__BackingField>
      <d2p1:_x003C_StartDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_StartDate_x003E_k__BackingField>
      <d2p1:_x003C_Status_x003E_k__BackingField>0</d2p1:_x003C_Status_x003E_k__BackingField>
    </d2p1:BM_WorkOrderStages>
  </Results>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <ResponseStatus>
    <ErrorCode>String</ErrorCode>
    <Message>String</Message>
    <StackTrace>String</StackTrace>
    <Errors>
      <ResponseError>
        <ErrorCode>String</ErrorCode>
        <FieldName>String</FieldName>
        <Message>String</Message>
        <Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </Meta>
      </ResponseError>
    </Errors>
    <Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </Meta>
  </ResponseStatus>
</QueryResponseOfBM_WorkOrderStages7kRqkrSv>