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

How to pull in a column full name of ctype_id=10 the main name not the representative the name =10?

edited Feb 9, 2023 2:02PM in Reporting & Analytics for B2C Service 6 comments

Summary:

I have build a report and trying to pull with if(contact.ctype_id=10). I tried substring but it doesn't work, I guess I didn't make the correct combination of columns from the tables, but if the ctype_id=10, why is not getting the name that ==10? Not sure what else I can do?


Content (required):

Currently I have this in the column but is not working? It pulls only No Value while there are names

if(contacts.ctype_id =incidents.i_id,if(contacts.ctype_id = 10, contacts.full_name))

Version (include the version you are using, if applicable):

21D

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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