Difference between revisions of "XL3Filter"
(→See Also) |
|||
| Line 3: | Line 3: | ||
==Syntax== | ==Syntax== | ||
| − | {{Code| | + | {{Code|XL3Jsonify( Input, Filter )}} |
==Parameters== | ==Parameters== | ||
| Line 16: | Line 16: | ||
| The range (column) that contains TRUE values to corresponding changed rows. | | The range (column) that contains TRUE values to corresponding changed rows. | ||
|} | |} | ||
| − | + | ||
==Examples== | ==Examples== | ||
| − | {{Code| | + | {{Code|=XL3Jsonify($D$7:$K$12,$L$8:$L$12)}} |
| − | ''Rows of the $ | + | ''Rows of the $D$7:$K$12 range for which the cell value is equal to TRUE for the same row in the $L$8:$L$12 range are returned as a JSON string.'' |
==See Also== | ==See Also== | ||
| Line 27: | Line 27: | ||
* [[XL3Link]] | * [[XL3Link]] | ||
* [[XL3TrackChanges]] | * [[XL3TrackChanges]] | ||
| + | * [[XL3Filter]] | ||
[[Category:Formulae]] | [[Category:Formulae]] | ||
[[Category:Report Management Formulae]] | [[Category:Report Management Formulae]] | ||
[[Category:Report Management]] | [[Category:Report Management]] | ||
Revision as of 15:47, 8 April 2024
Filters a range by returning an array of only the changed rows, on the basis of a column tracking changed values (used in conjunction with XL3TrackChanges to track the changed rows and as an argument for XL3RunSQLProc2 to pass a table of rows to be updated by an SQL Stroed Procedure.
Contents
Syntax
XL3Jsonify( Input, Filter )
Parameters
| Parameter | Description |
|---|---|
| Input | The range to watch for changes. |
| Filter | The range (column) that contains TRUE values to corresponding changed rows. |
Examples
Rows of the $D$7:$K$12 range for which the cell value is equal to TRUE for the same row in the $L$8:$L$12 range are returned as a JSON string.
