topic Re: Fetch and update from database in activiti Explorer in Alfresco Archive

Fetch and update from database in activiti Explorer

vaib — Mon, 08 Jun 2015 12:55:35 GMT

As per my application I have changed the database to Oracle,so i am not able to fetch any value from my table(i Have two table one is user master and second one is updatw usermaster).Kindly Suggest me a way to fetch the record from the database and update. can you help me out with demolink and its i

Re: Fetch and update from database in activiti Explorer

vaib — Tue, 09 Jun 2015 13:18:53 GMT

any sugesstion is very helpful

Re: Fetch and update from database in activiti Explorer

jbarrez — Fri, 12 Jun 2015 09:53:39 GMT

I'm not really following exactly what you want - you kinda are jumping from topic to topic.

Is this about doing a database query? or is this about users and roles?

What is your use case? What do you need to the roles for?

Re: Fetch and update from database in activiti Explorer

vaib — Tue, 16 Jun 2015 04:53:17 GMT

We have a java web application, wherein there is a user management and roles and permission modules. Now each user belongs to a particular domain. We have a list of pre-defined domains. And each user will also be linked to a particular role. All these information is currently being maintained in the application's RDBMS structure.
Now, we need to create a simple workflow, wherein the process is defined based on the roles. Example, first user belonging to Role-A will initiate the task and then it moves to user belonging to Role-B for approval and once approved the task ends. The level of approvals may be customizable. From what I have understood and done in Activiti, it uses information from its own database. So how do we flow our data into activiti or use both at same time??

Also, while creating a workflow, how do we ensure that when the process moves from Role-A to Role-B user, only the Role-B user belonging to the particular domain of Role-A user gets notified about the approval?
Please let me know your suggestions on the same, or if any other details are needed.

Re: Fetch and update from database in activiti Explorer

jbarrez — Tue, 16 Jun 2015 09:23:52 GMT

> it uses information from its own database. So how do we flow our data into activiti or use both at same time??

Activiti uses its own user/group database by default.
If you decide to not use it, you can put into the assignee field whatever you want. However, then you need to do the resolving in the layer of logic you write above Activiti.

> how do we ensure that when the process moves from Role-A to Role-B user, only the Role-B user belonging to the particular domain of
> Role-A user gets notified about the approval

That would be again something you'd have to manage in the layer above. Activiti only cares about assignments and offers queries to retrieve the information. It does not have an opinion on roles, user hierarchies, groups, etc.

Re: Fetch and update from database in activiti Explorer

vaib — Tue, 16 Jun 2015 13:12:23 GMT

Thank you for the response. By the word "managing in the layer above" do you mean that we should perform the operations using the rest-apis available of activiti?

Appreciate your help.

Re: Fetch and update from database in activiti Explorer

jbarrez — Tue, 30 Jun 2015 18:42:19 GMT

No, Activiti is a jar, and you can simply call the API's in java. So you can have your own custom logic 'above' activiti that calls the activiti api's.