SUNNY SINHA

SUNNY SINHA

  • 1.9k
  • 144
  • 167

filter data for more than 5k items through pnpjs SPFx

Mar 15 2021 9:30 AM

here is the situation :

  1. I have a list with 50k items.
  2. I have to get data from that list with a filter on status column (Status = true).
  3. So basically there are items with status true/false.
  4. When i will filter (Status = true) the items returned are 18k.

await sp.web.lists .getByTitle("listName") .items.select("ID", "Status", "Title") .filter("Status eq 'True'").get();

This is not working. :(


Answers (1)