Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
Hi all,
I'm trying to make some database updates in my process but it doesn't seems to work...
here is my update query : UPDATE `dir_user` SET `holidays`=(`holidays`-1) WHERE `id`='admin';
I use Heidi SQL to brows my database and to try this query (which worked).
I can't find in the logs any trace of the database query, should there be some ?
How can I check if my query worked ?
I'd also need to use a conditionnal route in my process, with conditions on my database datas, is it possible with the classic database plugin ?
With another plugin ?
Any other way ?
thanks,
Antoine
3 Comments
Sam Choo
Hi Antoine,
Did you specify the port number in the DB URL? If you're using the standard Windows installer, it should be on Port 3307.
antoine le maire
That was my problem !
thanks,
Antoine
Sam Choo
You're welcome. :-)