JiwaAPI

HR_StaffSkillsQuery

**HR_StaffSkillsQuery** 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
HR_Staff_RecID	query	string	No
HR_Staff_RecIDStartsWith	query	string	No
HR_Staff_RecIDEndsWith	query	string	No
HR_Staff_RecIDContains	query	string	No
HR_Staff_RecIDLike	query	string	No
HR_Staff_RecIDBetween	query	string[]	No
HR_Staff_RecIDIn	query	string[]	No
HR_Skills_RecID	query	string	No
HR_Skills_RecIDStartsWith	query	string	No
HR_Skills_RecIDEndsWith	query	string	No
HR_Skills_RecIDContains	query	string	No
HR_Skills_RecIDLike	query	string	No
HR_Skills_RecIDBetween	query	string[]	No
HR_Skills_RecIDIn	query	string[]	No
HR_SkillRatings_RecID	query	string	No
HR_SkillRatings_RecIDStartsWith	query	string	No
HR_SkillRatings_RecIDEndsWith	query	string	No
HR_SkillRatings_RecIDContains	query	string	No
HR_SkillRatings_RecIDLike	query	string	No
HR_SkillRatings_RecIDBetween	query	string[]	No
HR_SkillRatings_RecIDIn	query	string[]	No
QualificationDate	query	DateTime?	No
QualificationDateGreaterThanOrEqualTo	query	DateTime?	No
QualificationDateGreaterThan	query	DateTime?	No
QualificationDateLessThan	query	DateTime?	No
QualificationDateLessThanOrEqualTo	query	DateTime?	No
QualificationDateNotEqualTo	query	DateTime?	No
QualificationDateBetween	query	DateTime[]	No
QualificationDateIn	query	DateTime[]	No
Notes	query	string	No
NotesStartsWith	query	string	No
NotesEndsWith	query	string	No
NotesContains	query	string	No
NotesLike	query	string	No
NotesBetween	query	string[]	No
NotesIn	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
RowHash	query	byte[]	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

**HR_StaffSkills** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
HR_Staff_RecID	form	string	No
HR_Skills_RecID	form	string	No
HR_SkillRatings_RecID	form	string	No
QualificationDate	form	DateTime	No
Notes	form	string	No
ItemNo	form	int	No
RowHash	form	byte[]	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/HR_StaffSkillsQuery HTTP/1.1 
Host: localhost 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<HR_StaffSkillsQuery 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>
  <HR_SkillRatings_RecID>String</HR_SkillRatings_RecID>
  <HR_SkillRatings_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_SkillRatings_RecIDBetween>
  <HR_SkillRatings_RecIDContains>String</HR_SkillRatings_RecIDContains>
  <HR_SkillRatings_RecIDEndsWith>String</HR_SkillRatings_RecIDEndsWith>
  <HR_SkillRatings_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_SkillRatings_RecIDIn>
  <HR_SkillRatings_RecIDLike>String</HR_SkillRatings_RecIDLike>
  <HR_SkillRatings_RecIDStartsWith>String</HR_SkillRatings_RecIDStartsWith>
  <HR_Skills_RecID>String</HR_Skills_RecID>
  <HR_Skills_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_Skills_RecIDBetween>
  <HR_Skills_RecIDContains>String</HR_Skills_RecIDContains>
  <HR_Skills_RecIDEndsWith>String</HR_Skills_RecIDEndsWith>
  <HR_Skills_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_Skills_RecIDIn>
  <HR_Skills_RecIDLike>String</HR_Skills_RecIDLike>
  <HR_Skills_RecIDStartsWith>String</HR_Skills_RecIDStartsWith>
  <HR_Staff_RecID>String</HR_Staff_RecID>
  <HR_Staff_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_Staff_RecIDBetween>
  <HR_Staff_RecIDContains>String</HR_Staff_RecIDContains>
  <HR_Staff_RecIDEndsWith>String</HR_Staff_RecIDEndsWith>
  <HR_Staff_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_Staff_RecIDIn>
  <HR_Staff_RecIDLike>String</HR_Staff_RecIDLike>
  <HR_Staff_RecIDStartsWith>String</HR_Staff_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>
  <Notes>String</Notes>
  <NotesBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NotesBetween>
  <NotesContains>String</NotesContains>
  <NotesEndsWith>String</NotesEndsWith>
  <NotesIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NotesIn>
  <NotesLike>String</NotesLike>
  <NotesStartsWith>String</NotesStartsWith>
  <QualificationDate>0001-01-01T00:00:00</QualificationDate>
  <QualificationDateBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </QualificationDateBetween>
  <QualificationDateGreaterThan>0001-01-01T00:00:00</QualificationDateGreaterThan>
  <QualificationDateGreaterThanOrEqualTo>0001-01-01T00:00:00</QualificationDateGreaterThanOrEqualTo>
  <QualificationDateIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </QualificationDateIn>
  <QualificationDateLessThan>0001-01-01T00:00:00</QualificationDateLessThan>
  <QualificationDateLessThanOrEqualTo>0001-01-01T00:00:00</QualificationDateLessThanOrEqualTo>
  <QualificationDateNotEqualTo>0001-01-01T00:00:00</QualificationDateNotEqualTo>
  <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>
  <RowHash>AA==</RowHash>
</HR_StaffSkillsQuery>

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

<QueryResponseOfHR_StaffSkills7kRqkrSv 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:HR_StaffSkills>
      <d2p1:_x003C_HR_SkillRatings_RecID_x003E_k__BackingField>String</d2p1:_x003C_HR_SkillRatings_RecID_x003E_k__BackingField>
      <d2p1:_x003C_HR_Skills_RecID_x003E_k__BackingField>String</d2p1:_x003C_HR_Skills_RecID_x003E_k__BackingField>
      <d2p1:_x003C_HR_Staff_RecID_x003E_k__BackingField>String</d2p1:_x003C_HR_Staff_RecID_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>0</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_Notes_x003E_k__BackingField>String</d2p1:_x003C_Notes_x003E_k__BackingField>
      <d2p1:_x003C_QualificationDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_QualificationDate_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_RowHash_x003E_k__BackingField>AA==</d2p1:_x003C_RowHash_x003E_k__BackingField>
    </d2p1:HR_StaffSkills>
  </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>
</QueryResponseOfHR_StaffSkills7kRqkrSv>