Register new Function

BeasScript can be defined to be executed if you call the function.

Use this as small "Rest Service calls"

 

Call this with

get [entityname]/[functionname](parameter)

 

First define the function in the Object

[register collections]
CompanyWorkOrderActivity=primary=ClgCode/n<tab>description=Activity for Work order
[/register collections]
 

 

In the Object definition create the new function with "Function".

The following Properties are available:

Property

Description

name

Function name

description

Function description

parameter

Defines the parameter

 

 

Example

// Define all Columns, Functions, Table and other properties
[register CompanyWorkOrderActivity]
table=OCLG
post=true
column=name=ActivityCode<tab>sql="OCLG"."ClgCode"<tab>fieldtype=i
column=name=Details<tab>sql="OCLG"."Details"<tab>maxlength=20

// Define function without Parameter
function=name=CountOfEntries<tab>description=Return count of existing activities
// Define function with parameter
function=name=AddValues<tab>description=Add 2 values<tab>parameter=value1/i,value2/i
function=name=ItemInfo<tab>description=Return Item Info<tab>parameter=e_itemcode/c
[/register CompanyWorkOrderActivity]

 

In the Area [object/FunctionName] you can define the function

BeasScript: All Parameters are defined as String Variables. All return values are string variables.

 

The following variables can be defined for the return:

Variable

Description

result

sql (only BeasScript)

sqljson

code

Return the code (the default is 200 = ok. . If this is modified, it results in an error.

messagecode / message

Define the error code and error message if the code is not 200.

Note: The system displays messages only if you end the function with return failure