•  
      request #44858 List field comparison in `where` part can result to an error when displaying linked artifact
    Infos
    #44858
    Clarck Robinson (robinsoc)
    2025-09-29 09:56
    2025-09-22 10:10
    46577
    Details
    List field comparison in `where` part can result to an error when displaying linked artifact

    Linked to request #44437

    When the comparison is done, we only take in account the case when the field does not exist in the linked artifact.

    We should not return an error if the field value searched in theWHERE part does not exist in the linked artifact. For example:

    Example with the following query:SELECT @pretty_title FROM @project = 'self' WHERE status = "New" where status is a list field.

    If you have a linked artifact which also contains the field status BUT, the status field in the linked artifact does not have the New value then, an error will occur if you expand the parent row of the result

    Cross tracker search
    development
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Clarck Robinson (robinsoc)
    Closed
    2025-09-25
    Attachments
    Empty
    References

    Follow-ups

    User avatar
    • Summary
      - Duck type field comparison in `where` part can result to an error when displaying linked artifact 
      +List field comparison in `where` part can result to an error when displaying linked artifact 
    User avatar
    • Summary
      - Duck type field invalid comparison in `where` part can result to an error when displaying linked artifact 
      + Duck type field comparison in `where` part can result to an error when displaying linked artifact