Page 1 of 4. Showing 38 results (0.01 seconds)
Functions
By Definition, a Function is a group of statements that, together, performs a task. In DBSync, Functions are categorized as: Standard Functions User Defined Functions Standard Functions Standard Functions, or built in Functions, refer to specific Function by name. Functions are available to all users of a projectStandard Functions
, or builtin functions, refer to specific functions by name. Functions are available to all users of a project. If a project is imported, the same files and functions, from the original project, is available to the cloned project. 1) Functions are code sensitive. 2) When you use functions, the string objects mustCreating A User Defined Function
In the walk through, let's see how a user can append First Name and Last Name. For this, the user has to follow the following steps: All User Defined Functions have to be followed with the header "//@UserDefined" for DBSync to recognize it as User Defined Function. When done so, it is populated in the UserDefined listUsing Date Function in DBSync Integration
Using Date function in DBSync Date has always been one of the most complex functions to be used in integration. DBSync has inbuilt date function that can be used in the mappings to convert date from source to target format. Along with the inbuilt date function, you can also utilize the date functions of variousTesting your Function
Testing Your Function To test a User Defined Function, it has to be accompanied by a method generally started with header "//@Test". The user must save the created Function before testing it. The following code snippet shows the Test method required to test the previously created Append Function. //@Test functionObtaining Id’s of salesforce through Error() function in DataBase
with the function Save and Close. Save the workflow. image201846287.png Fig 4: Updated mapping 5. Run the sync. image2018462853.png Fig 5: Logs of success NowMore Example
Example 2 The following Example helps a user to define the color priority. Below is the code snippet of a User Defined Function and, Test method to execute it . //@UserDefined function chooseColor(priority) { var color = ""; if(priority == "High") else if(priority == "Medium") else if(priority == "Low") return colorRelease 4.2.2
Effective Release Date: December 16, 2016 Release Notes: LOOKUP Added To Standard Functions In this release we have added a new function to the list of existing standard function i.e. LOOKUP . LOOKUP function is used to query in the given connector instance and the query is only executed when the connector nameRelease 4.2.5
Effective Release Date: January 10, 2017 Release Notes: FASTTLOOKUP Added To Standard Functions In this release we have added a new function to the list of existing standard function i.e. FASTTLOOKUP . The Syntax for the function is as follows . Syntax : FASTTLOOKUP("SELECT field1 FROM table1 WHERE field2 = ( fNameRelease 4.3.2.5
validation rules before deleting connector instance. 4. Deprecated Function Soft Delete: The functions which are not implemented in DBSync will not show up in the UI level of standard function list in mapping page. 5. Additional Logs For Lookup Function : we have added additional logs for lookup functions which can be used