demmings / gsSQL / 23415384980

95%

Build Type

push

github

Committed by demmings

Commit Message

Load all sheets that match a wildcard as ONE table.

This allows multiple matching sheets (based on a sheet with wildcard character) to be loaded as one table.

For example, you have a transaction sheet which is divided up onto their own sheet for each calendar year.  If the table data input is specified as a string and a wildcard character is added so it matches all of the transaction sheets.  e.g.:

=gsSQL("Select sum(amount), year(transaction_date) from transactions where expense_category = ?1 and amount < 0 group by year(transaction_date)", "transactions", "Master Transactions*", true, "Utilities - Electricity")

So "Master Transactions*" will match my 'Master Transactions' and 'Master Transactions2019' and 'Master Transactions2020', and so on.  So when a new sheet is created for 2026, it will automatically be included in the results (as long as it matches the wildcard).

Coverage Stats

1597 of 1691 branches covered (94.44%)

Branch coverage included in aggregate %.

19 of 61 new or added lines in 2 files covered. (31.15%)

1 existing line in 1 file now uncovered.

13227 of 13876 relevant lines covered (95.32%)

280.77 hits per line