Mutation on custom item for default field
Hi, i have created a custom object for Campaigns. One of the default fields in each new Object is the Name.
I am trying to run a mutation to update Campaigns by filtering the Name field:
mutation UpdateCampaignByName ($campaign: String!,$data: CampaignUpdateInput!){
updateCampaigns(
filter:{
name: {
eq: $campaign
}
}
data: $data
)
{
id
status
campaignid
}
}
The campaingid is another custom fields that comes from external source. So i am trying technically to update the status and this campaignID record.
I get this error:
{
"errors": [
{
"message": "missing FROM-clause entry for table "_campaign"",
"extensions": {
"code": "INTERNAL_SERVER_ERROR",
"userFriendlyMessage": "An error occurred."
}
}
],
"data": {
"updateCampaigns": null
}
}
I am using 1.5.3 version
2 Replies
is it possible that there is a bug on the creation of the filter functionality for the custom object cause i see:
updateCampaign
id: UUID
data: CampaignUpdateInput
: Campaign
updateCampaigns
data: CampaignUpdateInput
filter: CampaignFilterInput
: [Campaign!]
and in the filter Input the name exists:
Hey @kyrpav I'm not sure if we support filtered update on rows 🤔
Indeed the input having the filter seems to suggest that yes, @Weiko do you have any information about that please ?