G
Ganesh Cherivirala
Guest
Hi, JSON Filter functionality to be implemented in the Business logic of the Read method i.e. Business Entity. We also need a method property i.e. @openapi.openedge.method.property (name="capabilities", value="top,skip,id,orderBy"). Please refer the attached sample code in cls file and generated JSON file. Hope this helps. Regards, Ganesh From: bingo [mailto:bounce-bingo@community.progress.com] Sent: Tuesday, October 28, 2014 11:55 AM To: TU.Rollbase@community.progress.com Subject: RE: [Technical Users - Rollbase] Rollbase Business Entity private cloud - complex filter and sorting RE: Rollbase Business Entity private cloud - complex filter and sorting Reply by bingo Hi, Thanks for the reply. I currently have no filter set so when the read request is sent to OE broker, the filter parameter is "?". This results in retrieving all records and returning a dataset with 1000+ records. Is there a setting in RB to set the JSON parameter to pass "top" and "skip" fields so it only sends a subset for viewing and pagination? The example is the documentation shows {"ablFilter": "CustNum 50", "top": "20", "skip": 5, "orderBy": "CustNum" } but i'm unable to get a filter parameter similar to this. I've tried setting the filter which when debuging looks like this {"ablFilter":"abc_code BEGINS '3'", "orderBy":"abc_code"}. This however still sends hundred of records. The Portal has a setting called "Number of Rows" but that also is unaffected. Looking at the RB cmd window, it says - Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended. After the query runs a few times all available RAM is used up. It doesn't appear to flush the memory. I had to restart RB is clear it. Stop receiving emails on this subject. Flag this post as spam/abuse.
Continue reading...
Continue reading...