It would be nice if the auto generated update handler would not include the added_by and added_on trace fields. Because they are automatically included in the update handler you have to set a value for them, even though technically those two fields should never be overwritten. There are workarounds ofcourse, but iâd rather use the auto generated update handler as is. Our project is in Dutch, so if langauge can also be considered when excluding the added trace fields, that would be nice, because we are using toegevoegd_op en toegevoegd_door as added_by/on.
Completed
Exclude added_by/added_on from auto generated update handler
+23NewâOpen
+2I like the general idea but I think it should be more generic. Like give a developer the option for a column to set whether this column is used in the automatically generated handlers or not.
+23I like the general idea but I think it should be more generic. Like give a developer the option for a column to set whether this column is used in the automatically generated handlers or not.
We could provide a Tag that developers then can attach to Columns to exclude them from the automatically generated handlers, but maybe we can think of another way đ
+2I like the general idea but I think it should be more generic. Like give a developer the option for a column to set whether this column is used in the automatically generated handlers or not.
We could provide a Tag that developers then can attach to Columns to exclude them from the automatically generated handlers, but maybe we can think of another way đ
That would work but is also not a great user experience. Maybe you could add it as options in this screen, that seems a logical place:Â
Â
+7Agree with Remco. It should be a formal property per column.
- Include in insert handler (default = true)
- Include in update handler (default = true)
+4OpenâWorking on it!
+4Hi all,
We have added in the upcoming release a way that you can exclude columns for the generated insert and update statement. These setting can be found via User Interface --> Subjects --> Columns --> tab: Performance
There you can uncheck if you don't want that column to be used in the auto generated statement. There are some restrictions for the insert handler checkbox. This can not be unchecked if the column is:
- Primary key
- Mandatory without default value
Note that it may break your dynamic model if you use select * into #cols from col. Please verify your dynamic model code and add the new columns if needed.
+4Working on it!âNext release
+23Next releaseâCompleted
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.