CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

How can I get a list of Cases with no associated Activities?

edited Aug 26, 2016 5:00AM in CRM On Demand - Reports and Dashboards (MOSC) 1 commentAnswered

We are trying to build a report to show latest activity times for open cases (or null if a case has no activity history).  It appears the Activity metric "# of Activities" would be the way to go, but I can't get any results to appear for cases I know have no activities, I just get an empty result set.

1. Start new Report based on the "Activities" Reporting area.

2. Add Case Number and "# of Activities" to the Columns list

3. Add a Case Number filter for a case known to have no activities.

The return is an empty set (no data), rather than the Case Number with a # of Activities value of 0.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center