Microtronics myDatalog4, Руководство пользователя, Страница: 96 / 145

Example above provides a list of the fields in the "Device" table (
geraetid
):
<Result>
<Field title="connection path (GPRS or not)"> conn_path </Field>
<Field title="Serial number">devsn</Field>
<Field title="Device class">devclass</Field>
<Field title="Telephone number">telnr</Field>
<Field title="Device flags">devflags</Field>
<Field title="Firmware version">swversion</Field>
<Field title="Modem version">modemversion</Field>
<Field title="OS version">osversion</Field>
<Field title="Last connection" units="<%data locals.time_code%>&nbsp;
<%data locals.offset_record.lastcon%>">lastcon</Field>
<Field title="Last wakeup" units="<%data locals.time_code%>&nbsp;
<%data locals.offset_record.lastwakeup%>">lastwakeup</Field>
<Field title="Last disconnection" units="<%data locals.time_code%>&nbsp;
<%data locals.offset_record.lastdisc%>">lastdisc</Field>
<Field title="Last transmission error" units="<%data locals.time_code%>&nbsp;
<%data locals.offset_record.lasterr%>">lasterr</Field>
<Field title="Last Aloha connection" units="<%data locals.time_code%>&nbsp;
<%data locals.offset_record.lastaloha%>">lastaloha</Field>
<Field title="Firmware update">fw_update</Field>
<Field title="Firmware type">fw_release_type</Field>
<Field title="Hardware version"> dev_hw </Field>
</Result>
A list of possible table identifiers is provided in "Structure of the database" on page 73.
10.3.1.1.2 List of site types
You can access a list of all the types of sites that are supported by the myDatanet server by
specifying the xPath query
SiteTypes
:
https://server-URL:8080/SiteTypes?user=u1&password=p1
Result:
<Result>
:
<SiteType class="2700" title="myDatalog4"> FFFF2700 </SiteType>
:
</Result>
10.3.1.1.3 Filter conditions
The filter condition is always within square brackets
[]
and comprises expressions that can be
linked by keywords such as
and
and
or
. The expressions can be prioritised by using round brackets
()
. Only
and
links are permissible at the highest level. A filter expression comprises a field name,
an operator and a constant. All of the fields in the table can be used.
Note: Upper and lower case are taken into consideration for the name of the site. The
condition must not be specified with an inverted comma
’
when a filter is applied to
id
or
ref
.
96 Rev. 01