We are using some roles, like HR Rep and Supervisor, and I'd like to automate the category filtering maintenance by having the flow make comparisons between HR07, the Resource Manager, and the workflow tables to determine the changes required. I'm having no problems querying the data or figuring out what changes I have to make to the tables. As far as I can see there are three tables we need to potentially update: WFUSERTASK, WFTASK, and WFUSRPROFL.
Any ideas as to how to automate the table updates? I can't use an ags call because there are no longer any programs that update these tables, correct? So how can I pull this off without creating programs? At our shop, getting cobol programs written, even easy paints, is very difficult as we are minimally customized whenever possible (we are a very large organization).
Thank You
User Proflie Update Web Program: bpm/xml/userProfileForm.do Post String: method=Add&id=UserId&filterCategory=Y User Task Update: Web Program: bpm/xml/userTaskForm.do Post String: method=Add&id=UserId&task=Supervisor&filterCategory=Y User Category Update: Web Program: bpm/xml/userCategoryForm.do Post String: method=Add&id=UserId&task=Supervisor&workCategory=Supervisor&workCategoryValue=HRSUPER_CODE (I had to leave off the angle brackets on the variable references)