Date Range Filter in datalist using api builder return wrong value

Confluence User - 23 Dec, 2021

Dear Expert/Justin,


Last week i got ask question about date range parameter for api, then i did update the api plugin based on justin feedback and followed all the instruction as per below :

From API Builder BETA4 onwards, the List API supports date range filtering. See KB guide here: https://dev.joget.org/community/display/marketplace/List

You can download the latest version in the Joget Marketplace: https://marketplace.joget.org/jw/web/userview/mp/mpp/_/vad?id=api_builder_dx


but then i noticed some of data return wrong value even i filter using correct date format,

using swagger ui/postman :

from the image below you can see the filter date range is from 01/12/2021|01/12/2021 but the value still include 02/12/2021 date



Hopefully i can found solution on this, tq so much.

forms;api;datalists

2


24 Dec, 2021
confluenceUser
confluenceUser

Hi, I believe the problem could be due to the format of the date value. For proper comparison, the date should be stored in yyyy-MM-dd format.

24 Dec, 2021
confluenceUser
confluenceUser

Hi Anders,


Not all data return wrong value, some of data working fine i think there might have bug on this BETA4 plugin.

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print