LISA SQL

Welcome to the LISA SQL documentation site.

Using template strings

String templates allow you to mix text as well as data and computed values. String templates like look regular string literals except that they contain { and } characters to begin and end expressions. You can also use Markdown tags to add styling. Let's have a look at an example.

CREATE PROCEDURE screen @custid LIKE customer.custid AS BEGIN OPEN c FOR SELECT * FROM customer WHERE custid = @custid BEGIN PRINT c.name END END

Copy

The above sample demonstrates how to create a screen procedure.

Creating donut charts

You can display values using a DONUT-CHART as shown below.

73%

Orders shipped

PRINT 'Orders shipped' AS DONUT-CHART
    DISPLAY 45
    DIVIDED-BY 62Copy

Working with cards

You can also arrange data columns into a data card like the example below.

Contact details

Phone

800-555-1212

Mobile

800-442-4244

chris@mymail.net

OPEN c FOR
    SELECT * FROM customer
    WHERE custid = @custid
BEGIN
    PRINT 'Contact details' AS DATA-CARD
    BEGIN
        PRINT c.phone LABEL 'Phone'
        PRINT c.mobile LABEL 'Mobile'
        PRINT c.email LABEL 'Email'
    END
ENDCopy

-goes-here>