0

I'm having some problems with my filter / rest call.

I'm trying to get the items that match some criteria in a list but it returns way to much.

?$select=Employee_x0020_No_&$filter((Employee_x0020_No_ eq '101009') or (Employee_x0020_No_ eq '101030') or (Employee_x0020_No_ eq '101076') or (Employee_x0020_No_ eq '101077') or (Employee_x0020_No_ eq '103055'))&$top=5000

As you can see im trying to get all records where Employee_x0020_No_ (Employee No_ ) is equal to one of these numbers 101009,101030,101076,101077,103055.

It current returns over 2000 items, when I filter the list itself by these parameters it should only return 57 items.

enter image description here

As you can see in the image the first item it returns has Employee_x0020_No_ = 102109. I can't figure out what I'm doing wrong here.

Improve this question

1 Answer 1

Reset to default
0

You are missing = sign after filter.

Try below query:

?$select=Employee_x0020_No_&$filter=((Employee_x0020_No_ eq '101009') or (Employee_x0020_No_ eq '101030') or (Employee_x0020_No_ eq '101076') or (Employee_x0020_No_ eq '101077') or (Employee_x0020_No_ eq '103055'))&$top=5000
Improve this answer
2
  • I have some problem with my filter query/rest call. ?$select=Student_x0020_No,Title,Principal,Student_x0020_Level,Email,ID&$filter=((Student_x0020_No eq '138635')and (isActive eq 1))&$top=5000 This contains more then 5000 records. I can't figure out what I'm doing wrong here.
    – Akshay
    Jul 23, 2018 at 8:46
  • @akshay what error message are you getting?
    – Rohit Waghela
    Jul 23, 2018 at 10:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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