cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted
Occasional Contributor

Is there a report to show me the #posts on a specific conversation?

I am trying to cost the number of responses/posts on a specific conversation ID?  For instance if i have an issue that customers are raising on SM i would like to be able to quantify the number of contacts that have come through our SM channels and attach a cost per contact. Is there any report available that will give me this information?

Appreciate any help here folks.

Thanks

Elaine

5 Replies 5
Highlighted
Honored Contributor

@Elaine_ThreeIre

You can use an API to count the replies on a specific conversation

select count(*) from messages where parent.id='123'

To run an API, go to Studio > API Browser 

Give kudos if you find my posts helpful or mark solution if it answers your query
Highlighted
Occasional Contributor

Thanks for your reply I actually found this detail under the combined data export in the smart view.
Highlighted
Honored Contributor

@VikasB Excuse my ignorance.  I've not used the API  browser in Studio before so I tried this.  It returned 0 replies for a thread that has 6 replies.   Then I started wondering if the API browser is only looking at our stage server environment so I tried some other searches using the browser and it seemed to confirm to me that searches in the API browser are only looking at the staging server so are only useful in testing, not in returning actual useful data.    Can you confirm and/or educate me on what the API browser is looking at?  

--
Community manager in the Micro Focus Community. My computer always used to beat me at chess, but it is no match for me now I changed the competition to kick boxing.
Highlighted
Honored Contributor

@Elaine_ThreeIre - You may be able to get to this via the search export reports.  It's not enabled by default, contact support to have it enabled if you can't get it working -> https://lithosphere.lithium.com/t5/Search-tools/Export-community-search-results-to-a-CSV-file/ta-p/3...

Highlighted

I verified the API browser is only looking at stage.   To get the above query to work on your production environment you would need to do this from a browser:

https://[yourcommunity].com/api/2.0/search?q=select count(*) from messages where parent.id='123'

  

--
Community manager in the Micro Focus Community. My computer always used to beat me at chess, but it is no match for me now I changed the competition to kick boxing.