Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

filtering with Incidents.i_id versus incidents.ref_no

edited Mar 8, 2017 4:58PM in Reporting & Analytics for B2C Service 6 comments

Content

I have a few reports that run without problems when I filter by the incidents.i_id field, but not when I use the incidents.ref_no field.

Is there a way to add the ref_no when adding the filter, but then in the back-end convert the ref_no to the i_id and filter by the i_id instead?

It seems that the Rule Log report runs this way. But, since it is an internal report, I am not able to see how the report does the conversion.

Has anyone figured this out?

Version

Service Cloud November 2016 SP3

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!