Please Share your Product Ideas with us!

All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.

AutoGen Update rules: the clause WHERE <fieldname> IS NULL should not be added if Console.dbo.ttTargetField.DefaultValue is populated

When creating the Update rules via AutoGen, the clause

WHERE <fieldname> IS NULL

is added to the UpdSel views by default.

This where clause filters out all records if the field to be updated has a default value set up in Design.

As a consequence the update rule needs to be manually edited after AutoGen creates it, having to remove the where clause to make it work correctly.

Ana GARCIA RUBIO
May 18 2018
Shipped

Advanced Data Migration (SST) / Autogen

Comments (1)
Votes (2)

Attach files

Enter a subject

Admin

Jon Green commented

August 24, 2018 10:31

Thanks for sending this idea. We will place this into backlog as part of the improvements to the autogen logic.

×
Attachments Open full size