DataTabSheet: Difference between revisions
Yadasampati (talk | contribs) No edit summary |
Yadasampati (talk | contribs) No edit summary |
||
| Line 3: | Line 3: | ||
|from= tran,trpr | |from= tran,trpr | ||
|where= tran.tran_id=trpr.tran_id and prop_id = {{{1}}} | |where= tran.tran_id=trpr.tran_id and prop_id = {{{1}}} | ||
|data= id=tran.tran_id,text=substr(tran_text,trpr_until+1) | |data= id=tran.tran_id,text=concat(" -- ",substr(tran_text,trpr_until+1)) | ||
}} | }} | ||
{| class="wikitable" style="width:70%" | {| class="wikitable" style="width:70%" | ||
Revision as of 17:03, 13 February 2023
{{#get_db_data:
db= vanisearch
|from= tran,trpr
|where= tran.tran_id=trpr.tran_id and prop_id = {{{1}}}
|data= id=tran.tran_id,text=concat(" -- ",substr(tran_text,trpr_until+1))
}}
| Id | Text {{#for_external_table: |
|---|---|
| {{{id}}} | {{{text}}}
}} |