Using Triggers in ODK Aggregate Database table may affect form definition

When I create trigger on ODK Aggregate form's tables, ODK Aggregate gives
an Error that Your Form definition is incomplete or missing.

A form definition is not complete until
(1) a _form_info_submission_association record is written and
IS_PERSISTENCE_MODEL_COMPLETE is set to 1 (true)
and
(2) there is a _form_info record for this same form id and _IS_COMPLETE is
set to 1 (true).

Your trigger should guard its actions based upon those two criteria.

··· On Thu, Mar 2, 2017 at 9:22 PM, Uday Vedpathak wrote:

When I create trigger on ODK Aggregate form's tables, ODK Aggregate gives
an Error that Your Form definition is incomplete or missing.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Keep in mind that ODK Aggregate does not use transactions in the database.
It instead relies on a specific ordering of reads and of writes to
accomplish atomic changes.

··· On Fri, Mar 3, 2017 at 9:09 AM, Mitch Sundt wrote:

A form definition is not complete until
(1) a _form_info_submission_association record is written and
IS_PERSISTENCE_MODEL_COMPLETE is set to 1 (true)
and
(2) there is a _form_info record for this same form id and _IS_COMPLETE is
set to 1 (true).

Your trigger should guard its actions based upon those two criteria.

On Thu, Mar 2, 2017 at 9:22 PM, Uday Vedpathak udayvedpathak06@gmail.com wrote:

When I create trigger on ODK Aggregate form's tables, ODK Aggregate gives
an Error that Your Form definition is incomplete or missing.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com