Template

DataTabSheet: Difference between revisions

Yadasampati (talk | contribs)
No edit summary
Yadasampati (talk | contribs)
No edit summary
Line 9: Line 9:
! until
! until
! style="padding:5px; font-weight:bold"| Id
! style="padding:5px; font-weight:bold"| Id
! style="padding:5px; font-weight:bold"| Vers
! style="padding:5px; font-weight:bold"| Verse
! style="padding:5px; font-weight:bold"| Text {{#for_external_table:<nowiki />
! style="padding:5px; font-weight:bold"| Text {{#for_external_table:<nowiki />
{{!}}-
{{!}}-

Revision as of 20:28, 13 February 2023

{{#get_db_data:

db= vanisearch
|from= tran,trpr,vers
|where= tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and prop_id = {{{1}}}
|data= from=trpr_from,until=trpr_until,id=tran.tran_id,vref_s=vers_ref,vref_u=replace(vers_ref," ","_"),text=tran_text

}}

from until Id Verse Text {{#for_external_table:
{{{from}}} {{{until}}} {{{id}}} {{{vref_s}}} {{{text}}}

}}