Tips and Tricks

Mingle Tips and Tricks

This is a public Custom Hive  publicRSS

Mingle Tip

    Andy Yates
    Using MQL to filter a list by comparing two property values
    Mingle Tip posted July 30, 2009 by Andy Yates
    1319 Views
    Tip Name:
    Using MQL to filter a list by comparing two property values
    Tip Description:

    I have two date properties on my story cards - 'Target Completion Date' - when I initially intended to get this work finished - and 'Estimated Completion Date' - when I currently think this might be complete.

    I'd like to get a list of all of the cards where the 'Estimated Completion Date' is after the 'Target Completion Date'.

    I can do this, using the MQL conditions in the Advanced Filter.  Note that I need to use the PROPERTY keyword in front of the second property being compared.

    Screenshot:
    Code Sample: