Skip to main content
added 4 characters in body; edited tags
Source Link
Ganesh Sanap - MVP
  • 46.4k
  • 22
  • 31
  • 63

hereHere 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 iI will filter (Status = true) the items returned are 18k.

How will iI filter data for above condition through pnpjsPnP JS SPFx.

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

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

This is not working. :(

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.

How will i filter data for above condition through pnpjs SPFx.

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

This is not working. :(

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.

How will I filter data for above condition through PnP JS SPFx.

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

This is not working.

Source Link

filter data for more than 5k items through pnpjs SPFx

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.

How will i filter data for above condition through pnpjs SPFx.

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

This is not working. :(