Template

DataTabSheet: Difference between revisions

Yadasampati (talk | contribs)
No edit summary
Yadasampati (talk | contribs)
No edit summary
Line 2: Line 2:
  db= vanisearch
  db= vanisearch
  |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 prop_id = {{{1}}}
  |data= from=trpr_from,until=trpr_until,id=tran.tran_id,vref=vers_ref,text=tran_text
  |data= from=trpr_from,until=trpr_until,id=tran.tran_id,vref=vers_ref,text=tran_text
}}
}}

Revision as of 19:14, 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=vers_ref,text=tran_text

}}

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

}}