oData query filter

(0) Share

Report

Posted on by Community Member

Hello,

In my custom Javascript Code, i use this oData query :

$select=asip_asip_sous_motif_incident/asip_name,asip_asip_motif_incident/asip_name,IncidentId,asip_asip_categorie_entity_incident/asip_name,asip_asip_produitservice_incident/asip_name,StateCode,CreatedOn,Title,TicketNumber,asip_contact_incident/FullName,asip_contact_incident/FirstName,asip_contact_incident/LastName,CaseTypeCode &$expand=asip_contact_incident,asip_asip_categorie_entity_incident, asip_asip_produitservice_incident,asip_asip_motif_incident,asip_asip_sous_motif_incident &$filter= (substringof('CAS-00003-Q9Y2Z5',TicketNumber) eq true) and (asip_contact_incident/FullName eq 'SYPNIEWSKI Paul')

When executing, the system throw this exception :

Error: Error : 400: Bad Request: filter conditions of different entity types, in the same expression, are not supported

Why do i have this exception? What can I do?

Thanks,

Paul

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Rajkumar Rajaraman on at

Like (1)

Report

RE: oData query filter

Guido pointed correctly, filtering on two entities is not supported with oData Filter

Was this reply helpful? Yes No