I have an application written using the the Phonegap plugin (1.3) and Cordova. I am trying to improve the performance of a filtering and sorting a large data set (3K rows).
I created an index the emits a 3 value array of [account ID, Inspector ID, Date Time integer as YYYYMMDDHHMMSS] which works fine.
When I query the view using thew following (REST API).
It returns rows even though the startkey does not exist in the view. It looks like it is doing a greater than or equal to instead of an equal to on the startkey. Is there any way to make this do an “equal to” on start key? I need the date as part of the key array to sort it properly so I can page the data to the screen in the correct order.
Sample row in result set:
“key”: [“113181201629554057946119539758595057121”, “202286596277076628159627591404617138106”, 20160722144600]