Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

4.1.2 > 4.1.3 break indexedDB queries #1747

Open
dougroutledge opened this issue Jul 17, 2023 · 3 comments
Open

4.1.2 > 4.1.3 break indexedDB queries #1747

dougroutledge opened this issue Jul 17, 2023 · 3 comments

Comments

@dougroutledge
Copy link

It seems every working query is now broken with the last update. Most used the DATE() operator against iso js dates.

@mathiasrw
Copy link
Member

Oh no!

Can you help identify an example of something that was working before that is returning something different now?

@dougroutledge
Copy link
Author

dougroutledge commented Jul 18, 2023

Here is an example.

SELECT 
	userDisplayName AS Name, COUNT(*) AS Val FROM callhistory 

WHERE 
	callType='ucap_in' 
	AND DATE(startDateTime) > DATE('" + today.toISOString().split('T')[0] +"') 

GROUP BY userDisplayName

@paulrutter
Copy link
Contributor

paulrutter commented Jul 12, 2024

@dougroutledge not a solution, but you can now also use CURRENT_DATE() so you no longer need the js code to extract the date without time.

Since 4.5.0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants
@mathiasrw @paulrutter @dougroutledge and others