Search by SQL - Internal Server Error

[curly1747]

I recently encountered the error message "Unable to search by SQL - I.toISOString is not a function" when loading the design page.
It seems to be caused by the Date Range component.
Please help check.

[linear]

BUDI-9033 Search by SQL - Internal Server Error

[ConorWebb96]

Hey @curly1747,

Can you try updating to the latest version of Budibase. This looks to be fixed in one of the releases last week.

[danielMensah]

Receiving the same issue even now

I have updated to the latest version

[ConorWebb96]

Hey @danielMensah,

Can you provide a simple app export + table create scripts where this issue is happening? I haven't been able to re-create this locally.

[curly1747]

Hey @curly1747,Can you try updating to the latest version of Budibase. This looks to be fixed in one of the releases last week.

It seems that a bug occurs in the Data Range component when performing a query to a column with a "date only" format (Date/time).

I tried removing the "date only" format in the database, and the error no longer occurred.

I am using the latest version 3.4.13 (When I reported it, I was using version 2.x.x - I don't remember exactly).