[TargetProcess filters/queries] #tp

targetprocess.md

Examples

This would get things US that need estimating (based on Feature's state):

?not Tags.Contains('OnHold') and (Feature.EntityState is 'Estimated' or Feature.EntityState is 'Defined')

However, if Calum tags them we might prefer this:

?Tags.Contains('estimate') and not (Feature.EntityState is 'Create' or Feature.EntityState is 'Initial')

Other misc filters:

?Bugs.Count(EntityState is 'Dev ready' or EntityState is 'In Progress' or EntityState is 'Awaiting TL H/O' or EntityState is 'QAT ready') > 0

?Bugs.Where(EntityState is not 'Done' or EntityState is not 'LIVE ready' or EntityState is not 'Awaiting Client S/O' or EntityState is not 'Awaiting Client H/O' or EntityState is not 'UAT ready' or EntityState is not 'Awaiting BA H/O' or EntityState is not 'Awaiting BA S/O')

?UserStories.Count(Name is not "Placeholder" and Name is not "Feature security assesment") > 0
?(UserStories.Count(Name is not "Feature security assessment" and Name is not "Placeholder") > 0) and (EntityState is 'Defined' or EntityState is 'Estimated' or EntityState is 'In Progress' or EntityState is 'Authorised')

?EntityState is 'Not dev ready' or EntityState is 'Dev ready'

?not Tags.Contains("OnHold")

?Feature.UserStories.Count(Name is not "Feature security assessment" and Name is not "Placeholder") > 0) and (EntityState is 'Defined' or EntityState is 'Estimated' or EntityState is 'In Progress' or EntityState is 'Authorised')

?Feature.UserStories.Count(Name is not "Feature security assessment" and Name is not "Placeholder") > 0 and Feature.EntityState is 'Defined'

// 474661 == "MVP"
?Feature.Epic.PortfolioEpic.Id == 47461 and (EntityState.IsInitial is True or EntityState.IsPlanned is True) and (not Name.Contains('Placeholder') and not Name.Contains("Feature security assessment")) and (BusinessValue is 'Must')

?(Release is 'MVP' or Feature.Release is 'MVP' or Feature.PortfolioEpic.Name is 'MVP') and (Feature.UserStories.Count(EntityState is 'Not dev ready') >0) and EntityState is 'Not dev ready'

CASE for Stories and Issues

CASE
WHEN UPPER([State]) == 'AWAITING TL H/O' THEN 'TODO'
WHEN UPPER([State]) == 'QAT READY' THEN 'TODO'
WHEN LEFT(UPPER([State]), 8) == 'AWAITING' THEN 'Feature Complete'
WHEN RIGHT(UPPER([State]), 5) == 'READY' THEN 'Feature Complete'
WHEN UPPER([State]) == 'COMPLETE' THEN 'Done'
ELSE 'TODO'

CASE for Features

CASE
    WHEN
        UPPER([State]) == 'IN PROGRESS'
    THEN
        'In Progress'
    WHEN
        UPPER([State]) == 'COMPLETED'
    THEN
        'Done'
ELSE
    'TODO'

CASE for cumulative flow

CASE
    WHEN
        UPPER([State]) == 'COMPLETE'
    THEN
        'Done'
    WHEN
        UPPER([State]) == 'DEV READY'
    THEN
        'TODO'
    WHEN
        UPPER([State]) == 'LIVE READY'
    THEN
        'Done'
    WHEN
        RIGHT(
            UPPER([State]),
            5
        ) == 'READY'
    THEN
        'QA'
    WHEN
        UPPER([State]) == 'AWAITING TL H/O'
    THEN
        'TODO'
    WHEN
        LEFT(
            UPPER([State]),
            8
        ) == 'AWAITING'
    THEN
        'QA'
ELSE
    'TODO'