Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderator: amosbatto

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
By HeshanKaru1994
#824580
Hi,
When I'm inserting to the database I'm converting to local time (UTC +5.30) and add,but when I'm retrieving from the database and display in the grid that value do not show that value(instead show without UTC +5.30)
By HeshanKaru1994
#824600
Hi, the problem is that when I insert the data to the db I use a similar way to convert the timezone but when I retrieve that same value from the db it shows according to a different time(in the db it saves correctly)
User avatar
By amosbatto
#824617
You can use a trigger like this:
Code: Select all
@@myDatetimeAdjusted = date("Y-m-d H:i:s",  strtotime(@@myDatetime, '+5 hours 30 minutes' ));
PS: If you are using ProcessMaker Enterprise Edition, remember that It has automatic datetime conversion to the time zone of the user.
Deleting the processes.

Are you sure that you are using version 1.245 f[…]

Changing the login page

In your pmos.conf, try changing from: Redir[…]

Clearing a datetime field

Is there a way to clear a date area inside of a […]

add dropdown to search process

I have to add dropdown list to search process. How[…]