Skip to main content

Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

    •  
      request #10199 Date comparison does not work using TQL
    Actions
    Infos
    #10199
    Patricia Carrasco (pcar)
    2017-05-05 21:49
    2017-05-05 20:34
    10468
    Details
    Date comparison does not work using TQL

    According to the User Guide it should be possible to do date comparisons.

    Comparison operators:

    • For string and text fields: =, !=
    • For date, integer and float fields: =, !=, <, <=, =>, >, BETWEEN()

    However a parsing error is generated when comparing two date field (without time).

    Trackers
    9.6
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Emilio Palmiero (empa), Stephan Bill (stephanbill)
    Stage
    Empty
    Closed
    2017-05-05
    Attachments
    Artifact links
    Empty
    Empty
    References
    References list is empty
    Display settings

    Follow-ups

    User avatar
    Nicolas Terray (nterray)2017-05-05 20:47
    Hi Patricia,

    In the user guide, it is mentioned that supported comparison values for date fields are: string convertible to date or NOW()

    Therefore comparing a field to another one is not supported for now.