Difference between revisions of "Table testing"

From SmartWiki
Jump to: navigation, search
 
(4 intermediate revisions by one other user not shown)
Line 1: Line 1:
 
This function will update a single [[transaction]] record.
 
This function will update a single [[transaction]] record.
  
−
trans_update(flag,callbackfunc,rset,linkobjectid,linktype)
+
===Level 1===
 +
Application Name>
  
 
{| class="wikitable"
 
{| class="wikitable"
−
!Level 1
 
−
!Variable
 
 
|-
 
|-
−
|'''level 1 name field'''|| @name@
+
!|Level 1
 +
!|Variable
 
|-
 
|-
−
|'''level 1 type field''' || @type@
+
||'''level 1 name field'''
 +
||@name@
 
|-
 
|-
−
|'''level 1 status field'''|| @status@
+
||'''level 1 type field'''
 +
||@type@
 
|-
 
|-
−
|'''level 1 start date'''|| @startdate@
+
||'''level 1 status field'''
 +
||@status@
 
|-
 
|-
−
|'''level 1 end date'''|| @enddate@
+
||'''level 1 start date'''
 +
||@startdate@
 
|-
 
|-
−
|'''level 1 contact'''|| @contact@
+
||'''level 1 end date'''
 +
||@enddate@
 
|-
 
|-
−
|'''level 1 custom field'''|| @customfieldname@
+
||'''level 1 contact'''
 +
||@contact@
 
|-
 
|-
−
|'''Accounts'''|| No variables
+
||'''level 1 custom field'''
 +
||@customfieldname@
 
|-
 
|-
−
|'''Activity List'''|| No variables
+
||'''Accounts'''
 +
||No variables
 
|-
 
|-
−
|'''Application Name'''|| @name@
+
||'''Activity List'''
 +
||No variables
 
|-
 
|-
−
|'''Application Template Type'''|| @type@
+
||'''Application Name'''
 +
||@name@
 
|-
 
|-
−
|'''Application Template Type [[Caption]]'''|| @typecaption@
+
||'''Application Template Type'''
 +
||@type@
 
|-
 
|-
−
|'''Application Template Type Language'''|| @type_lang@
+
||'''Application Template Type [[Caption]]'''
 +
||@typecaption@
 
|-
 
|-
−
|'''Archived''' || @archived@
+
||'''Application Template Type Language'''
 +
||@type_lang@
 
|-
 
|-
−
|'''Branch'''|| @branch@
+
||'''Archived'''
 +
||@archived@
 
|-
 
|-
−
|'''Branch ID'''|| @branchid@
+
||'''Branch'''
 +
||@branch@
 
|-
 
|-
−
|'''Close Date'''|| @closedate@
+
||'''Branch ID'''
 +
||@branchid@
 
|-
 
|-
−
|'''Contacts'''|| No variables
+
||'''Close Date'''
−
|-|'''Application Name'''|| @name@
+
||@closedate@
−
 
+
|-
 +
||'''Contacts'''
 +
||No variables
 +
|-
 +
||@name@
 +
|-
 +
||'''Application Template Type'''
 +
||@type@
 +
|-
 +
||'''Application Template Type Caption'''
 +
||@typecaption@
 +
|-
 +
||'''Application Template Type Language'''
 +
||@type_lang@
 +
|-
 +
||'''Archived'''
 +
||@archived@
 +
|-
 +
||'''Branch'''
 +
||@branch@
 
|-
 
|-
−
|'''Application Template Type'''|| @type@
+
||'''Branch ID'''
 +
||@branchid@
 
|-
 
|-
−
|'''Application Template Type Caption'''|| @typecaption@
+
||'''Close Date'''
 +
||@closedate@
 
|-
 
|-
−
|'''Application Template Type Language'''|| @type_lang@
+
||'''Contacts'''
 +
||No variables
 
|-
 
|-
−
|'''Archived'''|| @archived@
+
||'''Currency Name'''
 +
||@currencyname@
 
|-
 
|-
−
|'''Branch'''|| @branch@
+
||'''Currency Code'''
 +
||@currencycode@
 
|-
 
|-
−
|'''Branch ID'''|| @branchid@
+
||'''Exchange Currency Name'''
 +
||@excurrencyname@
 
|-
 
|-
−
|'''Close Date'''|| @closedate@
+
||'''Exchange Currency Code'''
 +
||@excurrencycode@
 
|-
 
|-
−
|'''Contacts'''|| No variables
+
||'''Currency Exchange Rate'''
 +
||@exrate@
 
|-
 
|-
−
|'''Currency'''|| @currency@
+
||'''Customer'''
 +
||@client@
 
|-
 
|-
−
|'''Exchange Currency'''|| @excurrency@
+
||'''Description'''
 +
||@description@
 
|-
 
|-
−
|'''Currency Exchange Rate'''|| @exrate@
+
||'''End Date'''
 +
||@enddate@
 
|-
 
|-
−
|'''Customer'''|| @client@
+
||'''End Time'''
 +
||@hour(fullenddate)@:@minute(fullenddate)@
 
|-
 
|-
−
|'''Description'''|| @description@
+
||'''Folders'''
 +
||No variables
 
|-
 
|-
−
|'''End Date'''|| @enddate@
+
||'''Modified By'''
 +
||@modifiedby@ (username); @modifiedbyid@ (userid)
 
|-
 
|-
−
|'''End Time'''|| @hour(fullenddate)@:@minute(fullenddate)@
+
||'''Modified Date'''
 +
||@modifieddate@
 
|-
 
|-
−
|'''Folders'''|| No variables
+
||'''Owner (full name)'''
 +
||@owner@
 
|-
 
|-
−
|'''Modified By'''|| @modifiedby@ (username); @modifiedbyid@ (userid)
+
||'''Owner ([[userid]])'''
 +
||@ownerid@
 
|-
 
|-
−
|'''Modified Date'''|| @modifieddate@
+
||'''Person (full name)'''
 +
||@person@
 
|-
 
|-
−
|'''Owner (full name)'''|| @owner@
+
||'''Person ([[userid]])'''
 +
||@person.userid@
 
|-
 
|-
−
 
+
||'''Probability'''
−
|'''Owner (userid)'''|| @ownerid@
+
||@probability@
 
|-
 
|-
−
|'''Person (full name)'''|| @person@
+
||'''Requirement'''
 +
||@requirements@
 
|-
 
|-
−
|'''Person (userid)'''|| @person.userid@
+
||'''Revenue'''
 +
||@revenue@ (to return unformatted number without comma separators, use @revenue.value@)
 
|-
 
|-
−
|'''Probability'''|| @probability@
+
||'''Start Date'''
 +
||@startdate@
 
|-
 
|-
−
|'''Requirement'''|| @requirements@
+
||'''Start Time'''
 +
||@hour(fullstartdate)@:@minute(fullstartdate)@
 
|-
 
|-
−
|'''Revenue'''|| @revenue@ (to return unformatted number without comma separators, use @revenue.value@)
+
||'''Status'''
 +
||@status@
 
|-
 
|-
−
|'''Start Date'''|| @startdate@
+
||'''Status [[Caption]]'''
 +
||@statuscaption@
 
|-
 
|-
−
|'''Start Time'''|| @hour(fullstartdate)@:@minute(fullstartdate)@
+
||'''Status Language'''
 +
||@status_lang@
 +
|}
 +
 
 +
 
 +
 
 +
 
 +
===Level 2===
 +
{| class="wikitable"
 
|-
 
|-
−
|'''Status'''|| @status@
+
!|Level 2
 +
!|Variable
 
|-
 
|-
−
|'''Status Caption'''|| @statuscaption@
+
||'''level 1 name field'''
 +
||@name@
 +
|}
 +
 
 +
 
 +
===Level 3===
 +
{| class="wikitable"
 
|-
 
|-
−
|'''Status Language'''|| @status_lang@
+
||
 +
[#(?object=contact;criteria=(roleid='10991' or roleid='10992');orderby=tbl_1359726.valuestr)<br />
 +
<nowiki><!--signature ~email~;~firstname~;~lastname~;1--></nowiki><br />
 +
_____________________________________<nowiki><br /></nowiki>
 +
 
 +
Name : ~firstname~ ~lastname~<nowiki><br /></nowiki>
 +
 
 +
Title : ~title~<nowiki><br /></nowiki><br />#]<br />[#(?object=contact;criteria=roleid='10993';orderby=tbl_1359726.valuestr)<br /><nowiki><!--signature ~email~;~firstname~;~lastname~;2--></nowiki><br />
 +
_____________________________________<nowiki><br /></nowiki><br />Name : ~firstname~ ~lastname~<nowiki><br /></nowiki><br />Title : ~title~<nowiki><br /></nowiki><br />
 +
<nowiki>#]</nowiki><br />
 +
}
 +
 
 
|}
 
|}

Latest revision as of 11:40, 12 June 2018

This function will update a single transaction record.

Level 1

Application Name>

Level 1 Variable
level 1 name field @name@
level 1 type field @type@
level 1 status field @status@
level 1 start date @startdate@
level 1 end date @enddate@
level 1 contact @contact@
level 1 custom field @customfieldname@
Accounts No variables
Activity List No variables
Application Name @name@
Application Template Type @type@
Application Template Type Caption @typecaption@
Application Template Type Language @type_lang@
Archived @archived@
Branch @branch@
Branch ID @branchid@
Close Date @closedate@
Contacts No variables
@name@
Application Template Type @type@
Application Template Type Caption @typecaption@
Application Template Type Language @type_lang@
Archived @archived@
Branch @branch@
Branch ID @branchid@
Close Date @closedate@
Contacts No variables
Currency Name @currencyname@
Currency Code @currencycode@
Exchange Currency Name @excurrencyname@
Exchange Currency Code @excurrencycode@
Currency Exchange Rate @exrate@
Customer @client@
Description @description@
End Date @enddate@
End Time @hour(fullenddate)@:@minute(fullenddate)@
Folders No variables
Modified By @modifiedby@ (username); @modifiedbyid@ (userid)
Modified Date @modifieddate@
Owner (full name) @owner@
Owner (userid) @ownerid@
Person (full name) @person@
Person (userid) @person.userid@
Probability @probability@
Requirement @requirements@
Revenue @revenue@ (to return unformatted number without comma separators, use @revenue.value@)
Start Date @startdate@
Start Time @hour(fullstartdate)@:@minute(fullstartdate)@
Status @status@
Status Caption @statuscaption@
Status Language @status_lang@



Level 2

Level 2 Variable
level 1 name field @name@


Level 3

[#(?object=contact;criteria=(roleid='10991' or roleid='10992');orderby=tbl_1359726.valuestr)
<!--signature ~email~;~firstname~;~lastname~;1-->
_____________________________________<br />

Name : ~firstname~ ~lastname~<br />

Title : ~title~<br />
#]
[#(?object=contact;criteria=roleid='10993';orderby=tbl_1359726.valuestr)
<!--signature ~email~;~firstname~;~lastname~;2-->
_____________________________________<br />
Name : ~firstname~ ~lastname~<br />
Title : ~title~<br />
#]
}

Retrieved from ‘https://wiki.smartsimple.com/index.php?title=Table_testing&oldid=32133’