DataTabSheet: Difference between revisions
Yadasampati (talk | contribs) No edit summary |
Yadasampati (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
{{#get_db_data: | {{#get_db_data: | ||
db= vanisearch | db= vanisearch | ||
|from= tran,trpr | |from= tran,trpr,vers | ||
|where= tran.tran_id=trpr.tran_id 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,from=trpr_from,until=trpr_until | |data= id=tran.tran_id,text=tran_text,vref=vers_ref,from=trpr_from,until=trpr_until | ||
}} | }} | ||
{| class="wikitable" style="width:70%" | {| class="wikitable" style="width:70%" | ||
| Line 14: | Line 14: | ||
{{!}} class="cw_0" {{!}} {{{until}}} | {{!}} class="cw_0" {{!}} {{{until}}} | ||
{{!}} class="cw_50" style="text-align:right; vertical-align:top; padding:0" {{!}} {{{id}}} | {{!}} class="cw_50" style="text-align:right; vertical-align:top; padding:0" {{!}} {{{id}}} | ||
{{!}} class="cw_500" style="padding:0 | {{!}} class="cw_100" style="padding:0" {{!}} {{{vref}}} | ||
{{!}} class="cw_500" style="padding:0" {{!}} {{{text}}} | |||
}} | }} | ||
|} | |} | ||
Revision as of 19:09, 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= id=tran.tran_id,text=tran_text,vref=vers_ref,from=trpr_from,until=trpr_until
}}
| from | until | Id | Text {{#for_external_table: | |
|---|---|---|---|---|
| {{{from}}} | {{{until}}} | {{{id}}} | {{{vref}}} | {{{text}}}
}} |