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 ;)