• Michael Courtney
  • NEWBIE
  • 30 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
I have a custom Case field labeled Component with API Name Component__c.  I have written my first ever SOQL: Select Id, DurableId, Value, Label, IsDefaultValue, IsActive, ValidFor, EntityParticleId FROM PicklistValueInfo.  It givese the following error message: [object Object]: PicklistValueInfo: a filter on a reified column is required [EntityParticleId,DurableId].  I can add WHERE EntityParticleId = 'Case.Priority' to get similar results to what I am looking for on a standard Case field but nothing I have tried will give results for my custom field.  I have tried Case.Component__c, Case.Component, Component, Component__c.  It also seems to require the operator to be equals so I cannot even do a LIKE.  How can I find the EntityParticleId for a custom field?  Thanks to anyone that can help and fogive my ignorance on what I am sure will be a very simple answer.  I promise I tried to Google it first.
I have a custom Case field labeled Component with API Name Component__c.  I have written my first ever SOQL: Select Id, DurableId, Value, Label, IsDefaultValue, IsActive, ValidFor, EntityParticleId FROM PicklistValueInfo.  It givese the following error message: [object Object]: PicklistValueInfo: a filter on a reified column is required [EntityParticleId,DurableId].  I can add WHERE EntityParticleId = 'Case.Priority' to get similar results to what I am looking for on a standard Case field but nothing I have tried will give results for my custom field.  I have tried Case.Component__c, Case.Component, Component, Component__c.  It also seems to require the operator to be equals so I cannot even do a LIKE.  How can I find the EntityParticleId for a custom field?  Thanks to anyone that can help and fogive my ignorance on what I am sure will be a very simple answer.  I promise I tried to Google it first.
I have a custom Case field labeled Component with API Name Component__c.  I have written my first ever SOQL: Select Id, DurableId, Value, Label, IsDefaultValue, IsActive, ValidFor, EntityParticleId FROM PicklistValueInfo.  It givese the following error message: [object Object]: PicklistValueInfo: a filter on a reified column is required [EntityParticleId,DurableId].  I can add WHERE EntityParticleId = 'Case.Priority' to get similar results to what I am looking for on a standard Case field but nothing I have tried will give results for my custom field.  I have tried Case.Component__c, Case.Component, Component, Component__c.  It also seems to require the operator to be equals so I cannot even do a LIKE.  How can I find the EntityParticleId for a custom field?  Thanks to anyone that can help and fogive my ignorance on what I am sure will be a very simple answer.  I promise I tried to Google it first.