Template

DataTabSheet: Difference between revisions

Yadasampati (talk | contribs)
No edit summary
Yadasampati (talk | contribs)
No edit summary
Line 3: Line 3:
  |from= tran,trpr,vers
  |from= tran,trpr,vers
  |where= tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and and prop_id = {{{1}}}
  |where= tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and and prop_id = {{{1}}}
  |data= id=tran.tran_id,text=tran_text,vref=vers_ref,from=trpr_from,until=trpr_until
  |data= from=trpr_from,until=trpr_until,id=tran.tran_id,vref=vers_ref,text=tran_text
}}
}}
{| class="wikitable" style="width:70%"
{| class="wikitable" style="width:70%"

Revision as of 19:12, 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 and prop_id = {{{1}}}
|data= from=trpr_from,until=trpr_until,id=tran.tran_id,vref=vers_ref,text=tran_text

}}

from until Id Vers Text {{#for_external_table:
{{{from}}} {{{until}}} {{{id}}} {{{vref}}} {{{text}}}

}}