Template:VerseRow: Difference between revisions
No edit summary |
No edit summary |
||
| Line 15: | Line 15: | ||
| verse_type = String | | verse_type = String | ||
| verse_text = Text | | verse_text = Text | ||
| verse_lines = List ( | | verse_lines = List (¦) of String | ||
| commentaries = List (,) of String | | commentaries = List (,) of String | ||
}} | }} | ||
'''All verses in a chapter:''' | '''All verses in a chapter:''' | ||
<pre> | <pre> | ||
| Line 29: | Line 28: | ||
}} | }} | ||
</pre> | </pre> | ||
'''All verses that have a specific commentary:''' | '''All verses that have a specific commentary:''' | ||
<pre> | <pre> | ||
| Line 40: | Line 38: | ||
}} | }} | ||
</pre> | </pre> | ||
'''Count commentaries per document:''' | '''Count commentaries per document:''' | ||
<pre> | <pre> | ||
| Line 51: | Line 48: | ||
}} | }} | ||
</pre> | </pre> | ||
[[Category:Cargo store templates]] | [[Category:Cargo store templates]] | ||
</noinclude> | </noinclude> | ||
Latest revision as of 18:24, 15 June 2026
This template defines the table "Verses". View table. A replacement table has been generated for this table; View replacement table.
All verses in a chapter:
{{#cargo_query:
tables = Verses
| fields = verse_id, verse_type, verse_text
| where = chapter_id = "NNS_C01"
| order by = verse_id ASC
| format = table
}}
All verses that have a specific commentary:
{{#cargo_query:
tables = Verses
| fields = verse_id, commentaries
| where = document_id = "NNS"
AND commentaries HOLDS "balabodhini"
| format = table
}}
Count commentaries per document:
{{#cargo_query:
tables = Verses
| fields = document_id, COUNT(*) = total_verses
| where = commentaries HOLDS "shankarabhashya"
| group by = document_id
| format = table
}}