Template:VerseRow: Difference between revisions

Latest revision as of 18:12, 20 March 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
}}

@@ Line 1: / Line 1: @@
-{{#cargo_store: _table=NakhaStotra
+{{#cargo_store: _table=Verses
-| document_id    = {{{document_id|}}}
+| document_id  = {{{document_id|}}}
-| chapter_id     = {{{chapter_id|}}}
+| chapter_id   = {{{chapter_id|}}}
-| verse_id       = {{{verse_id|}}}
+| verse_id     = {{{verse_id|}}}
-| verse_type     = {{{verse_type|}}}
+| verse_type   = {{{verse_type|}}}
-| verse_text     = {{{verse_text|}}}
+| verse_text   = {{{verse_text|}}}
-| has_balabodhini  = {{{has_balabodhini|no}}}
+| commentaries = {{#if:{{{commentary1|}}}|{{{commentary1}}}}}{{#if:{{{commentary2|}}}|,{{{commentary2}}}}}{{#if:{{{commentary3|}}}|,{{{commentary3}}}}}{{#if:{{{commentary4|}}}|,{{{commentary4}}}}}{{#if:{{{commentary5|}}}|,{{{commentary5}}}}}
-| has_mandabodhini = {{{has_mandabodhini|no}}}
 }}<!--store only-->
+<noinclude>
+{{#cargo_declare: _table=Verses
+| document_id  = String
+| chapter_id   = String
+| verse_id     = String
+| verse_type   = String
+| verse_text   = Text
+| commentaries = List (,) of String
+}}
+'''All verses in a chapter:'''
+<pre>
+{{#cargo_query:
+  tables   = Verses
+| fields   = verse_id, verse_type, verse_text
+| where    = chapter_id = "NNS_C01"
+| order by = verse_id ASC
+| format   = table
+}}
+</pre>
+'''All verses that have a specific commentary:'''
+<pre>
+{{#cargo_query:
+  tables   = Verses
+| fields   = verse_id, commentaries
+| where    = document_id = "NNS"
+  AND commentaries HOLDS "balabodhini"
+| format   = table
+}}
+</pre>
+'''Count commentaries per document:'''
+<pre>
+{{#cargo_query:
+  tables   = Verses
+| fields   = document_id, COUNT(*) = total_verses
+| where    = commentaries HOLDS "shankarabhashya"
+| group by = document_id
+| format   = table
+}}
+</pre>
+[[Category:Cargo store templates]]
+</noinclude>