Skip to main content The Trailblazer Community will be unavailable from 2/1/2025 to 2/2/2025. Please plan your activities accordingly.
How to resolve 

Select Id ,name,(Select Product_dashcode__c from IX_V1__PP_Relationships__r)from IX_V1__ICIX_Product__c

                                                             Where Name 

                                                             LIKE:newSearchText 

                                                             OR Product_dashcode__c=:productName 

It showing 

                           OR Product_dashcode__c=:productName

                              ^

ERROR at Row:5:Column:65

No such column 'Product_dashcode__c' on entity 'IX_V1__ICIX_Product__c'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
1 answer
  1. Jul 24, 2018, 8:00 AM
    Hi Sandy,

    According to your query, it seems "Product_dashcode__c" is a field of IX_V1__PP_Relationship__c object. Where as you are trying to use it in Where condition of another object IX_V1__ICIX_Product__c.

    Mightbe it will be like that:

    [Select Id ,name,(Select Product_dashcode__c from IX_V1__PP_Relationships__r WHERE Product_dashcode__c=:productName ) from IX_V1__ICIX_Product__c Where Name  LIKE:newSearchText ]

                                                               

    Thanks

    Niraj
0/9000