IBM Advanced Find JSONStore saying "INVALID_SEARCH_FIELD" when the advanced query exceeds 999 records

202 Views Asked by At

VERSION OF MFP JSONSTORE PLUGIN: 8.0.2017033009

Hi I have a JSONStore with 2000 records and want to filter out only 1217 records from them which are similar to one property.

So i used WL.JSONStore.QueryPart().inside('PROPERTY', [...PROPERTYVALUEARRAY]);

Everything works fine till PROPERTYVALUEARRAY is limited to 999 records but when it exceeds/touches 1000 we are doomed the JSONstore API as below started returning the error as in picture.

WL.JSONStore.get("JSONSTORENAME").advancedFind([query]).then(res => { console.log(res)}).fail(res => { console.log(res)});

enter image description here

1

There are 1 best solutions below

0
manjunath kallannavar On BEST ANSWER

Retrieving huge/large JSONStore data has been fixed in latest ifix releases .

Use ifix version later than iFix 8.0.0.0-MFPF-IF20170705-1849.

For more details about iFix release see here : MobileFirst Foundation iFix 8.0.0.0-MFPF-IF20170705-1849 released