Is it possible to get a report of the accepted ideas, including authors, for a specific time period?
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 ?
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.
Thanks guys. @lolagoetz I'm looking for when status changes to accepted.
@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. 😞
@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.
Welcome to the Technology board!
Curious about our platform? Looking to connect on social technology? You've come to the right place!