topic Re: Many to many relations in Alfresco Archive

Many to many relations

gianluca1 — Wed, 01 Jun 2011 11:40:14 GMT

Hi,suppose that I have to create a simple crm application with this process/form- customers- companies- projectsIs it possible to have a field (autocomplete input or drop down) in the "insert project task" form that query the data in the "companies list" and save the many - to - many relation in the

Re: Many to many relations

frederikherema1 — Mon, 06 Jun 2011 08:04:10 GMT

No sure what you're talkin about, activiti-explorer? Or just using activiti as a jar?

Re: Many to many relations

gianluca1 — Mon, 06 Jun 2011 08:50:00 GMT

Thank you for your reply. I'm completely new to activiti, I think that be able to make a many to many relation between different process in a GUI (so the activiti explorere I guess) will be the best, but I can consider alternative method.

Re: Many to many relations

frederikherema1 — Mon, 06 Jun 2011 08:59:41 GMT

Activiti explorer is just a simple app to view your tasks and completing them, that's it. Of you want to create an application that does other stuff and uses your model as wel, you're on your own. You can use activiti as a library and use the API, which is documented and described in the userguide.

http://activiti.org/userguide/index.html

Re: Many to many relations

gianluca1 — Mon, 06 Jun 2011 09:07:47 GMT

Thank you, I red the docs, but I didn't found anything related to my question. I would like to know if it is possible to have in process A a relation to data inserted in process B, and store this information in the database (think this as a many-to-many relations between different processes).

Re: Many to many relations

frederikherema1 — Mon, 06 Jun 2011 09:25:39 GMT

You can use process-variables to store the ID of the referenced process I suppose… Offcourse, there will be no foreign-key constraint of index in the database.

However, you can query all process-instances related to another, eg:


List<ProcessInstance> referencing = runtimeService.createProcessInstanceQuery().processVariableValue("refId", otherPocessInstance.getId()).list();