•  
      request #42961 Adjust XTS queries of templates
    Infos
    #42961
    Manuel Vacelet (vaceletm)
    2025-05-06 12:27
    2025-04-30 13:37
    44643
    Details
    Adjust XTS queries of templates

    All queries should be updated to remove @tracker.name from SELECT as the information is already visible in @pretty_title.

    Queries in "SAFe Agile Release Train" should be updated to include @project.name:

    SELECT @pretty_title, @project.name, @status, @last_update_date, @submitted_by
      FROM @project IN ('self', 'aggregated')
      WHERE @status = OPEN()
      ORDER BY @last_update_date DESC
    

    And

    SELECT @pretty_title, @project.name, @status, @last_update_date, @submitted_by
    FROM @project IN ('self', 'aggregated')
    WHERE @status = OPEN() AND @assigned_to = MYSELF()
    ORDER BY @last_update_date DESC
    
    Cross tracker search
    Empty
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Empty
    Closed
    2025-05-06
    Attachments
    Empty
    References

    Follow-ups

    User avatar
    • Original Submission
      Something went wrong, the follow up content couldn't be loaded
      Only formatting have been changed, you should switch to markup to see the changes