Expression to get list of rows within date/time range

Hi,

Please could someone advise of the expression to get a list of just the green rows?

Something like:

[select_asset_type] are all the same as each other i.e. “CAT6A”
[room_sid] are all the same as each other i.e. “2-624”
[survey_status] are are same as each other?
[last_changed_on] rows are within 2 minutes of each other?

UseCase:

  1. In the green rows I just surveyed 5 [asset_name_text] EnumList in one survey form and split them into 5 new rows in same table OnSave.
  2. In the last row I surveyed a different thing (LPR006).
  3. I now need to start new survey form with the green rows in the [asset_name_text] EnumList?

Thanks in advance…

Solved Solved
0 10 399
1 ACCEPTED SOLUTION

@Rich,

I’ve included two new helper columns:

[number] - the number of the survey or grouped/related survey rows.
[previous] - the EnumList items from the form before it was saved and split into many.

That might make it easier for the expression to identify the group…?

In adding the helper columns I realise I’ve just answered my own question cause they make it easy to identify the most recent group of surveys… It amazing how the act of presenting a question on this forum brings clarity and perspective to the issue…

Thanks @Rich

View solution in original post

10 REPLIES 10
Top Labels in this Space