Forum Discussion

Srishha's avatar
Srishha
Qrew Member
1 year ago

How to use GetRecords()

var text QUERY = "{9.EX.'" & ToText([Person Assigned]) & "'} AND {3.NE." & [Record ID#] & "} AND {11.LE." & [End Date] & "}AND{10.GE." & [Start Date] & "} AND{13.NE.'Completed'}";
  
 

var recordList overlappingTasks = GetRecords($QUERY);

var number conflictCount = Size($overlappingTasks);

If(
  $conflictCount > 0,
  "Not Available",
  "Available"
)

I have used the above query to configure any existing records but the comaprison is not done in the way expected like the number 9 gets compared not the value like that in everything.