<< Click to Display Table of Contents >> Navigation:  »No topics above this level« FieldCondition structure

This structure is used by webservices and consists of a fieldname (Field), operation (Operation) and a value (Value) for the field.

 

Fieldnames are technical specifications for a field in an entity/table and can be found in the Data Dictionary.They're shaped <ENTITY.FIELD> like: KLANTCONTRACT.CONTRACTNUMMER.

Should a field specify that a listvalue should be used, then a possible value can also be found in the datadictionary. Should there be a code in the table with possible values for a certain list value then this should be used (as a string value) and in other cases the number should be used (as a Number value)

Possible values for (Operation) are: =, >, >=, in, <, <=, like, <>, not in, not like, relates

Examples:

 

String value

<crud:FieldCondition>
  <crud:Field>KLANTCONTRACT.CONTRACTNUMMER</crud:Field>
  <crud:Operation>LIKE</crud:Operation>
   <crud:Value xsi:type="xsd:string">C*</crud:Value>
</crud:FieldCondition>

 

Number value

<crud:FieldCondition>
   <crud:Field>KLANTCONTRACT.KLANTID</crud:Field>
  <crud:Operation>=</crud:Operation>
   <crud:Value xsi:type="xsd:long">822</crud:Value>
</crud:FieldCondition>

 

Geonode value

<crud:FieldCondition>
   <crud:Field>TABBDG.GEOLOC</crud:Field>
  <crud:Operation>relates</crud:Operation>
   <crud:Value xsi:type="crud:GeoNode">822</crud:Value>
       <crud:CoordSysNumber xsi:type="xsd:long">4326</crud:CoordSysNumber>
       <crud:X xsi:type="xsd:decimal">  4.436777132633663</crud:X>
       <crud:Y xsi:type="xsd:decimal">51.147314401341596</crud:Y>
   </crud:Value>
</crud:FieldCondition>

 

 

The used prefixes xsi en xsd must be announced SOAP Envelope: xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"

 

---