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 | |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}}}
}} |