NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{Note | Changes to scripts in 6.0 are outlined in [[Script changes 6.0]].}}
{{TOC right}}
==Workarounds==__NOEDITSECTION__
{{Warning | ICR-114: The update query in [[Multi-select CDFs]] needs to be added as a ''Data.RunSQLStatement'' if any of the fields that are imported are multi-select.}}
==Approval information is not set==__NOEDITSECTION__
The approval function was changed in 5.08.02 and ''Approved by'' and ''Approved date'' needs to be set in the script in Pojo '''Fieldreport'''.
<pre>
Attribute.SetDate("ReportVerifiedDate", Data.CurrentDate());
Attribute.SetString("VerifiedBy", "migration");
</pre>
==ID number gets decimals==__NOEDITSECTION__
Especially when using Excel as indata it is common that item ID becomes e.g. Assistance-10.0 which is fixed with 2 Cast.<br>
<pre>
Attribute.SetString("LocalId", "Assistance-" & Cast.String(Cast.Int(Row.GetAttribute("ID"))));
</pre>
==Limitations==__NOEDITSECTION__
Unfortunately it is still not possible to use the following in scripts:
* greater than (>)
* less than (<)
* LIKE (e.g. Eriks* or Eriks%)
{{NavBox Hub}}
[[Category:NoPublic]]
[[Category:NAA]]
