function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Rakesh KumarRakesh Kumar 

error : semi join sub selects can only query id fields, cannot use : 'Line_nov_usr__c '

Hi

 

I am getting an error like " semi join sub selects can only query id fields, cannot use : 'Line_nov_usr__c ' ".

I dont know why its giving such type of error.

Is there any miss or need to do apend something here?

 

code will be:

 

SELECT Line_nov__c,Feild_2_nov__c, Field_3_nov__c, Field_4_nov__c FROM Patient_Survey_ONC_nov__c where Line_nov__c In (Select Line_nov_usr__c from user where id='005U0000000onrNIAQ') and Line_nov__c !=null

 

Any clue or idea.

 

Thanks

Rakesh