Articles in this section

See more

Filtering on data from History

Avatar
Michael Decleene
Updated
Follow 

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

Sort by Date Votes
  • Avatar
    Suzie Prince

    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:


    0
    Permalink
  • Avatar
    Matt Quagliana

    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.



    1. Create a new property of type "team", call it "Creator" (or whatever) and set its default value to "Current User". Also set it to "Transition Only" so it can't be easily changed.

    2. Go to the All tab and filter it to show the cards in question

    3. Show the "Created by" column and sort by it.

    4. Using the checkboxes on the left side of the table to select all of the cards created by a single user

    5. Tag all of the selected card en masse with the Mingle login name of the card creator (use the "Tag" widget above the list)

    6. Repeat step 6 for each person who has created cards

    7. Export the card data to Excel and use the tags data to populate the "Creator" property. The simplest method is to just change the title of the "Tags" column to "Creator". Be sure to delete any "non-Creator" tags, if you have any.

    8. Import the updated data. You only need to import the Number column and the Creator column... feel free to drop the other columns in the spreadsheet before you do the import.

    9. Delete the tags.


    If you set up the default value for Creator (Step 1) you won't have to repeat this process in the future.

    0
    Permalink

Please sign in to leave a comment.