[nateshnp]

Dear All,

How can i get the list of task what the user has access to create a new case from the database?

Best Regards,
Natesh

[ashkufaraz]

You can use this

Code: Select all

SELECT t.TAS_UID
FROM task t
LEFT JOIN task_user tu ON tu.TAS_UID=t.TAS_UID
WHERE t.TAS_START='TRUE' and tu.USR_UID='00000000000000000000000000000001'

[nateshnp]

Dear ashkufaraz,

Is there an API which i can use to get all the task which are assigned to the user and which are start task. This will be my last resort if there is no API.

Best Regards,
Natesh

[amosbatto]

Natesh, please file a bug report requesting that a new REST endpoint be added which returns the info you need.

Also this endpoint might help a little bit:
http://wiki.processmaker.com/3.0/REST_A ... ting_tasks