You need to sign in to do that
Don't have an account?
Michael Courtney
entityparticleid of custom field
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.
Michael Courtney
It took some trial and error, but this query allowed me to find the EntityParicleId: SELECT EntityDefinitionId, QualifiedAPIName, FieldDefinitionId FROM EntityParticle WHERE EntityDefinition.QualifiedApiName ='Case'. In this case it was Case.00Na000000BOpLH so it appears to be formatted as Object.SalesforceID.
Nicola Mitcham
Michael thank you so much, you seem to be the only comment online that has actually cracked this, so helpful thank you!
Nadine Rapoza
Four years later, this is still relevant! Thanks so much for making my job easier.
Mo A
Unbelievable that there isn't a better way! Will we ever get the function like toLabel (https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_tolabel.htm) in Tableau CRM?
malik Smith 2
i am unable to understand please help me with this 8 ball poll (https://bestapk4u.com/8-ball-pool-mod-apk/)
Projectors Point
On my site Projectors Point (https://projectorspoint.com/) , any one can review top Projectors todays in the market. In our top pic collection, we've picked featured projectors that meet to your budget and requirements.