Report.rst

10.sql = SELECT firstName, lastName FROM Person
JohnDoeJaneMillerFrankStar
10.sql = SELECT firstName, ", ", lastName, "<br>" FROM Person
Doe, John<br>
Miller, Jane<br>
Star, Frank<br>
10.sql = SELECT firstName, lastName FROM Person
10.fsep = ', '
10.rend = <br>
Doe, John<br>
Miller, Jane<br>
Star, Frank<br>
10.sql = SELECT firstName, lastName FROM Person
10.twig = {% for row in result %}
    {{ row.lastName }}, {{ row.firstName }<br />
{% endfor %}
Doe, John<br>
Miller, Jane<br>
Star, Frank<br>
10.twig = {% for row in result %}
    {{ row.lastName }}, {{ row.firstName }<br />
{% endfor %}
10.twig = file:table_sortable.html.twig
{{ "u:http://www.example.com" | qfqlink }}
{% set decoded = '["this is one", "this is two"]' | json_decode%}
{{ decoded[0] }}
{{ store.typo3.feUser }}
10.sql = SELECT assigned_to AS _user FROM FileTracker
            WHERE assigned_to IS NOT NULL
            GROUP BY _user
            ORDER BY _user

10.10.sql = SELECT id, path_scan FROM FileTracker
WHERE assigned_to = '{{user:R}}'
10.10.twig = <h2>{{ store.record.user }}</h2>
<table class="table table-hover tablesorter" id="{{pageSlug:T}}-twig">
  <thead><tr><th>ID</th><th>File</th></tr></thead>
  <tbody>
  {% for row in result %}
    <tr>
      <td>{{ row.id }}</td>
      <td>{{ ("d:|M:pdf|s|t:"~ row.path_scan ~"|F:" ~ row.path_scan ) | qfqlink }}</td>
    </tr>
  {% endfor %}
  </tbody>
</table>
debugShowBodyText = 1
10.sql = SELECT id AS _pId, CONCAT(firstName, " ", lastName, " ") AS name FROM Person
10.rsep = <br>

10.10.sql = SELECT CONCAT(postal_code, " ", city) FROM Address WHERE pId = {{10.pId}}
10.10.rbeg = (
10.10.rend = )
John Doe (3004 Bern)
Jane Miller (8008 Zürich)
Frank Star (3012 Bern)
10.sql = SELECT 'hello world'
           FROM Mastertable
10.tail = End

20.sql = SELECT 'a warm welcome'
           'some additional', 'columns'
           FROM AnotherTable
           WHERE id>100

20.head = <h3>
20.tail = </h3>
10.sql = SELECT 'hello world'
           FROM Mastertable
10.sql = SELECT 'hello world', 'd:final.pdf \
                                |p:/export  \
                                |t:Download' AS _pdf \
10.sql = SELECT 'hello world', CONCAT('d:final.pdf'
                                '|p:/export',
                                '|t:Download') AS _pdf
10 {
  sql = SELECT ...
  5 {
      sql = SELECT ...
      head = ...
  }
}
10.sql = SELECT ...
10.5.sql = SELECT ...
10.5.head = ...
10.sql = SELECT name FROM Person
10.rsep = ' '
10.head = "Names: "
# Specific code. >
10 <
  sql = SELECT
  head = <script>
         data = [
           {
             10, 20
           }
         ]
         </script>
>
10.sql = SELECT 'Yearly Report'

20 {
      sql = SELECT companyName FROM Company LIMIT 1
      head = <h1>
      tail = </h1>
}

30 {
      sql = SELECT depName FROM Department
      head = <p>
      tail = </p>
      5 {
            sql = SELECT 'detailed information for department'
            1.sql = SELECT name FROM Person LIMIT 7
            1.head = Employees:
      }
}

30.5.tail = More will follow

50

{
       sql = SELECT 'A query with braces on their own'
}
10.sql = SELECT 'p:/home?form=Person|s|b:success|t:Edit' AS _link
10.20.sql = SELECT '{{link:R}}', '{{&link:R}}'
10.sql= SELECT p.id AS _pId, p.name FROM Person AS p
10.5.sql = SELECT adr.city, 'dummy' AS _pId FROM Address AS adr WHERE adr.pId={{pId:R}}
10.5.20.sql = SELECT '{{pId:R}}'
10.10.sql = SELECT '{{pId:R}}'
10.sql= SELECT p.id AS _pId, p.name FROM Person AS p
10.5.sql = SELECT adr.city, 'dummy' AS _pId FROM Address AS adr WHERE adr.pId={{10.pId}}
10.5.20.sql = SELECT '{{10.pId}}'
10.10.sql = SELECT '{{10.pId}}'
# Displays current date
10.sql = SELECT CURDATE()

# Show all students from the person table
20.sql = SELECT p.id AS pId, p.firstName, " - ", p.lastName FROM Person AS p WHERE p.typ LIKE "student"

# Show all the marks from the current student ordered chronological
20.25.sql = SELECT e.mark FROM Exam AS e WHERE e.pId={{20.pId}} ORDER BY e.date

# This query will never be fired, cause there is no direct parent called 20.30.
20.30.10.sql = SELECT 'never fired'
level.sublevel1.subsublevel2. ...
10.sql = SELECT 'All', 'cats' AS red, 'are' AS _green, 'grey in the night' AS _link
10.sql = SELECT '..1..' AS '_page|column1', '..2..' AS '_page|column2'
10.sql = SELECT 'world' AS 'title|_noWrap'
10.sql = SELECT CONCAT('u:', p.homepage, IF(p.showHomepage='yes', '|r:0', '|r:5') ) AS _link FROM Person AS p