NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{Note | All ID are important to be filled in. ''Form ID'' is important for the DEF's Reconcilation tab and I recommend that to update that one as the last one.}}
==Missing Local ID items ==__NOEDITSECTION__ [[Image:Missing local id.png|475px|center]]<div align="center">'' How it should NOT look like''</div>
Start with checking the items and the infoversions. If they are missing a local ID then I strongly recommend to set one which will be very helpful if you need to populate ''Form ID''.
=== Example update query ===__NOEDITSECTION__
== Missing Local ID fieldreport ==__NOEDITSECTION__
If you get output here you '''NEED''' to take action. The easiest solution to populate the ''Form ID'' for DEF is to use the local ID from the infoversion which you have now populated with updating the ones that were missing with the queries above.
fieldreport.fieldreport_localid is null or length(trim(fieldreport.fieldreport_localid)) = 0
</pre>
If you have any output here you need to take action. The queries below help you to identify for which item(s) the rows in the table ''fieldreport'' need to be updated.
=== Accident ===__NOEDITSECTION__
<pre>
</pre>
=== Hazard ===__NOEDITSECTION__
<pre>
</pre>
=== Hazard Reduction ===__NOEDITSECTION__
<pre>
</pre>
=== Location ===__NOEDITSECTION__
<pre>
</pre>
=== MRE ===__NOEDITSECTION__
<pre>
</pre>
=== QM ===__NOEDITSECTION__
<pre>
</pre>
=== Victim ===__NOEDITSECTION__
<pre>
</pre>
=== Example update query ===__NOEDITSECTION__
<pre>
</pre>
== Missing Local ID Auxiliary data ==__NOEDITSECTION__
=== Example update query ===__NOEDITSECTION__
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
