Appendix 1 - Dynamic Syntax

Previous  Next |  Direct link to this topic

Throughout B1 Usability Package you will encounter the use of the dynamic syntax. This is inspired by the SAP formatted search syntax and allows you to do SQL and other arguments with syntax code that upon execution will replace the dynamic syntax with the data from the current SAP Business One window.

There are basically 2 syntaxes

The item syntax

 $[$<ItemUID>.<ColumnUID>.<DataType>]

and

The table syntax

 $[<TableName>.<FieldId>.<DataType>]

 

Inside this section you can read more and see samples on how to use the syntax.

 

Beyond the two syntax types there are also various Special Keywords

 

NB: Dynamic Syntax does not support the use of white space