Internal documentation only

This page has been marked as draft.

How do I make headlines in gatewaySQL?

Note: A gateway-sql plugin can’t process headlines, but you can create a headline in the dataview generated by gateway-sql and populate them with a rule.

A rule with target path with the new headline you created and a path alias to the cell you want to pass to the new headline. Below is an example:

value path "pathaliasname" value

Or if more than one cell you could do a sum

value total(wpath "pathaliasename" value)

Or you could delete one cell from another

value path "pahtaliasname1" value - path "pathaliasname2" value

If you are doing a count of a column where the dataview may be empty, you can use +0 in the value setting in case the path evaluates to no cells, you can do a count. Below is the syntax for the value count function.

value count(wpath "myPathAlias" value) + 0