Report of who had accepted idea?

[kgroneman]

Is it possible to get a report of the accepted ideas, including authors, for a specific time period?

[cblown]

Hey..

I'm not sure about the Admin reports, but you could get something like this from the V2 API Browser in Studio using something like this 

SELECT author.login FROM messages WHERE conversation.style='idea' AND status.key = 'accepted' AND post_time < 2020-06-09T10:04:30-08:00 AND post_time > 2020-05-01T10:04:30-08:00 

BTW. I haven't tested the above ^ so it might need some tweaking @peterlu ?

[lolagoetz]

Are you looking for when they were submitted, or when the status changed to accepted, @kgroneman ? I'm trying to remember whether status change is tagged as an event so you can report on it.

[kgroneman]

Thanks guys.  @lolagoetz  I'm looking for when status changes to accepted.   

[lolagoetz]

@kgroneman I’m doing this from memory, but you can always do a blank search in your ideas board and then do an export (being able to do this requires that it already be enabled by Khoros support). In the export, you can check and see if there’s a column that shows the status change. I don’t have an old sample to check that and see.

[peterlu]

SELECT author.login, subject, view_href FROM messages WHERE conversation.style='idea' AND status.key = 'accepted' AND post_time < 2020-06-09T10:04:30-08:00 AND post_time > 2020-05-01T10:04:30-08:00

Then you may need to write some code to print it out as CSV file. Hope this helps.

[kgroneman]

@lolagoetz   The csv file has the status and it has last edit author and time, but the last edit author/time are the original author, not status changes.   I guess status changes don't count as an edit.   😞

[kgroneman]

@peterlu I'll have to give that a try, but it looks like it only pulls post time not accepted time.  That's what I'm looking for.  I guess I wasn't real clear about that. Thanks.