Search code examples
ibm-mobilefirstjsonstoremobilefirst-cli

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

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

Solution

  • 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