How to update an object in a process

KOBRETI

Hi, guys,

I need to do the following - I have a folder object, named DocumentF. On the folder edit page I have a button, that needs to calculate the document_number field according to some logic.

I have created a stateless process, that recieves the id of the current folder object, but can't figure out how exactly to do what i need.

I have setup a process package of the folder type and tried the following 2 things:

- I assign the id incoming variable to the package object_id - i get a message that the package can't be found

- I wrote a DQL to extract the corresponding object, but I don't know how to specify the id parameter in the DQL, and i get the same result. Here is the DQL that I tried, but I suppose it's wrong:

SELECT *

FROM "egov_documentf"

WHERE "r_object_id" = 'doc_id'

Any help for the newbie?

raman.walia

What you want to do is give you DQL in the DQL editor of the Activity Template but put a '?' for r_object_id. Something like

select * from egov_documentf where r_object_id = ?

and then hit the "Set Parameter type" button on the activity template itself. Once you have set the type of the parameter in the popup dialong, click Next button to set the mapping.

Let me know if you still having problem, I can give some screen shots.

Raman