I'm wondering if there's a way to use MQL to get at data that Mingle history knows, but is not recoded in a card property.
The specific thing I'm trying to get at is "Who created the card?" We didn't set up a property on this when we set up our cards, so there's no property (hidden or otherwise) I can query on if I want to find all cards created by person X.
However, Mingle clearly knows this data, because it tracks histories on all cards, and looking at the history tab I can find who created the cards.
Is there a way for me to get at this data from the history and use it in an MQL query or similar?
---Update---
To be clear--I know I can get at this information on the History tab using clever settings of the filters. However, this ONLY appears to let me filter on "event" type items. What I'm really after is to be able to create, say, a grid view of "All items of type story created by X that currently have property set foo".
Comments
2 comments
Mike
We currently do not have 'created by' fully supported in Mingle. You can see this on list view columns and, like you said, in the history of the cards. This is however, not supported in MQL.
There has been a long standing feature request (see list below) to support 'created on', 'modified on', 'created by' and 'modified by' in card filters and MQL but until recently the team had not prioritised this feature. We have however, recently begun addressing some of this request, when in the 3.0 release 'created on' and 'modified on' will be supported in MQL. It is our intention to further add support for 'created by' and 'modified by' in future releases.
In the meantime, I find that using 'created by' in the list view and sorting by that column helps me to find a list of cards created by a specified user fairly easily although I understand this will be harder than just filtering by that user.
Thanks Suzie
Here are some related requests for this feature:
You need to get this data into a card property into order to filter or report on it. For now (Mingle 2.3.1) you need to get the "Created by" data into card property that you create.
The "Created by" value does not get included when you export to Excel, but there is a (somewhat manual) way to get this data into a card property.
Please sign in to leave a comment.