Back

updateByKey()

Name	Type	Required	Default	Description
key	any	Yes		Primary key value(s) of the record to fetch. Separate with comma if passing in multiple primary key values. Accepts a string, list, or a numeric value.
properties	struct	No	[runtime expression]	The properties you want to set on the object (can also be passed in as named arguments).
reload	boolean	No	false	Set to `true` to force Wheels to query the database even though an identical query for this model may have been run in the same request. (The default in Wheels is to get the second query from the model's request-level cache.)
validate	boolean	No	true	Set to `false` to skip validations for this operation.
transaction	string	No	[runtime expression]	Set this to `commit` to update the database, `rollback` to run all the database queries but not commit them, or `none` to skip transaction handling altogether.
callbacks	boolean	No	true	Set to `false` to disable callbacks for this method.
includeSoftDeletes	boolean	No	false	Set to `true` to include soft-deleted records in the queries that this method runs.

1. Update a record by key using a struct of properties
result = model("post").updateByKey(33, params.post);
// Returns true if the update was successful

2. Update a record by key using named arguments
result = model("post").updateByKey(
 key=33,
 title="New version of Wheels just released",
 published=1
)

3. Include soft-deleted records in the update
result = model("user").updateByKey(
 key=42,
 properties={isActive=true},
 includeSoftDeletes=true
)

4. Disable validation and callbacks
result = model("post").updateByKey(
 key=33,
 properties={title="Force Update"},
 validate=false,
 callbacks=false
)