In classic Creatio pages, to delete a new record you would use a DeleteQuery. Now, in Freedom UI pages you can delete records using the Model class that is a part of the Creatio DevKit SDK.
To use the devkit, you’ll need to add “@creatio-devkit/common” to the modules list of your page. This will look like this (note the “@creatio-devkit/common” in the square brackets and the sdk without quotes in the parenthesis):
define("UsrMyCustomEntity_FormPage", /**SCHEMA_DEPS*/["@creatio-devkit/common"] /**SCHEMA_DEPS*/,
function/**SCHEMA_ARGS*/(sdk)/**SCHEMA_ARGS*/ {
return {
// ... the rest of the page here
};
});
Now, with that module available, you can access things in the SDK, such as the Model class. We’ll use this model class to create a model for a specific entity. Then, we’ll pass an array of filters for the record (or records) we want to delete. In this sample, we’ll be deleting a single account, so we’ll first create an account model, then pass the details of the account to delete to the Model’s delete function. Let’s look at the code to delete an account:
// create account model
const accountModel = await sdk.Model.create("Account");
// delete the new account
const result = await accountModel.delete([{
type: sdk.ModelParameterType.PrimaryColumnValue,
value: someAccountId
}]);
The result returned by the insert provides an object with the following properties:
- success: true/false
- rowsAffected: Number of rows affected by the operation, in this case, 1
Have you found a way to pass in custom filters (instead of the primary key filter shown in this article) to a delete model class query similar to how that can be done for the load function? I seem to be getting the following when trying to swap out the sdk.ModelParameterType.PrimaryColumnValue for a sdk.ModelParameterType.Filter:
{
“success”: false,
“rowsAffected”: 0,
“errorInfo”: “r.map is not a function”
}
Request that gives these results:
const delResults = await audGenModel.delete({
parameters: [{
type: sdk.ModelParameterType.Filter,
value: newFilters
}]
});
I’ve tried using the pre-8.1.1 workaround for the filters but get the same error response.
Hi Harvey,
Just confirmed that it does work for me. Just guessing, could it be that the records you’re deleting with the filter have related records, so they can’t be deleted? (If you delete them manually via the UI, do you get the popup about cannot be deleted due to related records?)