Tech > GSheets > Query vs Filter
Query and Filter are functions used to retrieve one or multiple rows of data with one or multiple columns of data given specific criteria. Comparable to SQL Select calls. Query uses SQL syntax and it is a "newer" function. Prior to it, spreadsheet programmers only had the Filter function for this type of work and it has significant limitations/complications as compared to the query function.
Example: Filter a Patients Visits Table. Select all rows belonging to the name that has been selected in C17
Example: Filter a Patients Visits Table. Select all rows belonging to the name that has been selected in C17
- =query(PatientVisits!A:L, "SELECT * WHERE B = C17 ,False)
- =filter(PatientVisits!A:L, PatientVisits!B:B=C17)