...
| Note |
|---|
Currently only writing new record records to a separate database table is supported, that is you can not currently update an existing record in an external database table. |
So far all attribute values entered by the user were have been written directly to the underlying spatial table, but it's also possible to write values, including those entered by the user and those available via value formulas, to another database table. This can be done by creating an audit edit configuration item and attaching it to an existing edit configuration item.
...
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
<edit:config id="custom.edit">
<entity>graffiti</entity>
<label>Grafitti</label>
<description>Report graffiti for removal</description>
<geometry>
<point minimum="1" maximum="1"/>
</geometry>
<parameter id="id" hidden="true" label="Id" column="ID" value="auto()"/>
<parameter id="description" label="Description" controlType="text-area" column="DESCRIPTION"/>
</edit:config>
<edit:audit id="custom.audit">
<edit>custom.edit</edit>
<datasource>datasource.main</datasource>
<table>EDIT_AUDIT</table>
<parameter column="ID" value="id()"/>
<parameter column="DESC" parameter="description"/>
<parameter column="USER" value="userid()"/>
<parameter column="MODIFIED" value="datetime()"/>
</edit:audit>
|
...