Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Gayathri Lakshmanan (GayathriL)
NCS Pte. Ltd.
Consultant
NCS Pte. Ltd.
SG
GayathriL Member since 2018 2 posts
NCS Pte. Ltd.
Posted: Jun 3, 2019
Last activity: Jun 17, 2019
Posted: 3 Jun 2019 6:41 EDT
Last activity: 17 Jun 2019 12:08 EDT
Closed

Is there an optimized way to identify unresolved Work items without assignment?

We are trying to identify cases which are not resolved and which doesn't have any assignments. The only way we had was to join the Work table and the Assign table. Would like to know if there is any other way which would be good in performance.

Thanks,
Gayathri L

***Edited by Moderator: Lochan to update platform capability tags***

To see attachments, please log in.
Case Management

Posted: 6 years ago
Posted: 14 Jun 2019 5:19 EDT
Marc Lasserre (MarcLasserre_GCS)
PEGA
Technical Account Manager
Pegasystems Inc.
FR

Hello, 

I believe you got the right approach. Another one would be to open the cases and check pxFlow content but I don't think the performance will be extremely better.

 

To see attachments, please log in.
Posted: 6 years ago
Posted: 17 Jun 2019 12:08 EDT
Bhavya Tyagi (Bhavya)
Mastek
Architect
Mastek
GB

HI

The join of Work and Assign table is the best possible way to do it. Its quick and should not have much impact on performance.

Regards

Bhavya

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice