Skip to main content

Filter RecordQueryResult by field

  • January 24, 2023
  • 1 reply
  • 14 views

Forum|alt.badge.img+1

Is there a way to filter RecordQueryResult by a checkbox field; let's say I want all records where the value is False?

 

 

let query = await table.selectRecordsAsync({ fields: [uniqueIdField, dateDueField, projectField, waiveRushField, comparisonField], });

 

 

That's the query I've been working with. I'd like to filter the resulting records to only pull items where waiveRushField is not marked.

Thanks!

1 reply

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • 6009 replies
  • January 24, 2023

You cannot filter the queryResult in the initial selectRecordsAsync. Instead you filter the records in JavaScript after you have received the query result.