0

Create a Filter given a condition

Hi, I want to be able to create the following process:

 

Find the last date given a condition. We have indicents in Status (selection field).

I want to pick the last date of a Closed Incident (Status=2)

 

I am trying with select and where but I receive a weird error: expression does not return a complex

1 reply

null
    • John_Halls
    • 3 yrs ago
    • Reported - view

    Hi Kieta

     

    If this is in an unrelated table use something like

     

    LastDate := last(select table where Status=2 order by date).date

     

    If it is a child table use something like this

     

    LastDate := last(table [Status=2] order by date).date

     

    Regards John

Login to reply

Content aside

  • 3 yrs agoLast active
  • 1Replies
  • 218Views