Forum OpenACS Development: Re: get instance workflow id

Collapse
Posted by Iuri Sampaio on
I believe the query has to be diferent
as i said i created a new workflow to my pkg and i see in the table workflows

So the API bug_tracker::bug::get_instance_workflow_id
remains the same and the query changes a bit, from:

fullquery name="bug_tracker::bug::get_instance_workflow_id.get_instance_workflow_id">
querytext
select workflow_Id
from bt_projects
where project_id = :package_id
querytext
fullquery

it should be

fullquery name="bug_tracker::bug::get_instance_workflow_id.get_instance_workflow_id">
querytext
select workflow_id
from workflows
where object_id = :package_id
querytext
fullquery

This way seems more logical to me
But that is just a guess of a newbie user ;)