I have followed the docs and none of these worked:

?$filter=FieldValues/Product_Name eq 'XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX'

However when I searched using ?$filter=Name eq 'Item Name' then it generated a result.

Is there anything that I've missed here? Perhaps a configuration? I have done rebuilding my search index and populated my schema but still to no avail.

EDIT: I'm using Sitecore 9.0.2

  • What version of Sitecore do you have?
    – x3mxray
    May 8 '20 at 10:38
  • @x3mxray I'm using 9.0.2
    – Lala
    May 8 '20 at 10:44
  • FieldValues property should work in 9.0.2 according official documentation, but I`m not sure (earlier versions have property "Fields" instead of "FieldValues"). You can easy check it (for example by querying "$expand=FieldValues" and "$expand=Fields").
    – x3mxray
    May 8 '20 at 10:55
  • @x3mxray I may have found the root cause, now. Well actually I was using a multilist as one of my search criteria, and it turns out dashes could have been treated as a space so the GUID XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX is treated as XXXXXXXX XXXX XXXX XXXX XXXXXXXXXXXX (which will result to nothing), is there a way that I can improve this?
    – Lala
    May 8 '20 at 11:59
  • OData has special guid keyword. Try this one: $filter=FieldValues/Product_Name eq (guid'" + yourId + "'). Query should be like: $filter=FieldValues/Product_Name eq (guid'D37A2617-1AB6-48C6-BB5A-0582395DD622')
    – x3mxray
    May 8 '20 at 12:20

Remove the quotes and use this syntax

?$filter=FieldValues/Product_Name eq 3d9e15a7-f5b1-49b5-ad54-471f1df7427b

(guid must be on lowercase)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.