1

I have followed the docs and none of these worked:

?$filter=FieldValues/Product_Name eq 'XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX'
and
?$filter=contains(FieldValues/Product_Name,'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

8
  • What version of Sitecore do you have?
    – x3mxray
    Commented May 8, 2020 at 10:38
  • @x3mxray I'm using 9.0.2
    – Lala
    Commented May 8, 2020 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
    Commented May 8, 2020 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
    Commented May 8, 2020 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
    Commented May 8, 2020 at 12:20

1 Answer 1

1

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 and acknowledge you have read our privacy policy.

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