nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Retrieving CandidateGroup Task

frankee787

Dear All,
I understand , inorder to retrieve Task assigned to single "CandidateGroup"…you can use the API as follows

getTaskService().createTaskQuery().taskCandidateGroup("candidateGroup").list();

However, if a task is assigned to multiple "CandidateGroup"…you would have to use the API probably in a loop as follows

for loop

getTaskService().createTaskQuery().taskCandidateGroup("candidateGroup"+).list();

end loop;

Is there a better way to do this , where in which it queries in one hit to the database ?

Regards,
Franklin

Find more posts tagged with

Comments

ronald_van_kuij

Create your own query? And I do not mean with the query api, but in the mybatis config file, or even plain jdbc

frankee787

Thanks Ronald.

I really didn't think about that possibility.

However, is this a common use case?

Would it be worthwhile for it to be part the API?

I have also noticed that a similar situations with Task assignment where each entity in the assignment takes a roundtrip to the DB(Correct me if my understanding is wrong).

Regards,
Franklin

ronald_van_kuij

However, is this a common use case?

yes and no… at least in my case. Yes, retrieving multiple group lists is, but in my case it is limited to 5 and I need the lists separated after retrieval, since I want to display them per group. Adding this additional logic which might require additional queries to the db (not sure, but it might) for me did not outway the 1 query to retrieve all

Would it be worthwhile for it to be part the API?

Yes and no (yes and not sure actually), see the answer before

I have also noticed that a similar situations with Task assignment where each entity in the assignment takes a roundtrip to the DB(Correct me if my understanding is wrong)

I recall something like this yes, but thought it was fixed (check Jira)

frankee787

yes and no… at least in my case. Yes, retrieving multiple group lists is, but in my case it is limited to 5 and I need the lists separated after retrieval, since I want to display them per group. Adding this additional logic which might require additional queries to the db (not sure, but it might) for me did not outway the 1 query to retrieve all

If you were going to display the lists as separate groups then there is no reason to query them together and then separate them, atleast thats what I believe.

I recall something like this yes, but thought it was fixed (check Jira)

I believe this is still there. The method signature is getTaskService().saveTask(task) So I am assuming it will do it as different db statements. Anyways, I shall skim through the JIRA and see.

Thanks a lot,
Franklin

tstephen

I created http://jira.codehaus.org/browse/ACT-796 in April, which I believe is what you are looking for. There is a patch attached but it doesn't look like anyone has gotten to it yet.

Tim

frankee787

Thats exactly what I am looking for.

Thanks,
Franklin