This method returns the content of a given field from a given Table if a given value expression is satisfied.

BODY - RAW

{
       "Method": "GetValueSqlExp",
       "Parameters": [
             <cFieldToReturn>,
             <cTableToSearch>,
             <cExpression>
       ]
}

PARAMETERS

Parameter Description
cFieldToReturn Specifies the Field whose content is to be returned.
cTableToSearch Specifies the table in which the value cFieldToReturn is located.
cExpression Specifies the expression criteria. Expression criteria must be enclosed in [brackets].

REMARKS

This method is similar to GetValueSQL. The main difference is that:

GetValueSQL search is based on only one condition. The content of a given field is based on the content of another field.

GetValueSqlExp search is based on an expression that can contain multiple criteria.

EXAMPLE

*/ Return the document number for an invoice created for an address with ID = 1000 on the 01.03.2017. The invoice reference is TEST_REFERENCE

{
       "Method": "GetValueSqlExp",
       "Parameters": [
             "do_nodoc",
             "document",
             "do_type = 20 and do_adr1 = 1000 and do_date1 = {01.03.2017} and do_ref1 = 'TEST_REFERENCE'"
       ]
}
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.