Formatted Search Syntax

[Former Member]

Hi all,

Can anyone explain the syntax of a formatted search to me? For example, sometimes I need to use the syntax $[$Item.0.0], other times I need to use the syntax $[$table.attribute]

TIA

[former_member204969 · Accepted solution]

The reference to the current data is through these type of syntax.

$[Tablename.Fieldname]

Tablename – indicates the table, which the active window relates to.

Fieldname – the field from the active window.

$[$Field Index. Field Column. Number/Currency/Date.0]

This syntax uses the field’s index instead of the specific document table.

This query syntax includes 3 elements:

1.Field index - each field in the active window can be related by a unique index.

2.Field column - In case the required field is a Table field (item code, item name,

price, quantity in marketing documents etc.), it has to be related by index and column

numbers. In case the required field is a Title field, this element should be set to 0.

3.Number / Currency / Date / 0 -

In case the required field includes a number + a currency symbol (item price,

document total), type Number to retrieve the number (without the currency symbol or

the measurement unit). This separation is essential in case the user wish to use the

price for arithmetic expressions.

Type Currency to retrieve the currency symbol or the weight unit.

In case the required field is a Date field, and it has to be used for computation,

type Date.

[Former Member · Accepted solution]

Thank you very much! That is exactly what I was looking for!

[former_member376683]

the answer is:

EXAMPLE:

$[$46.1] for SAP Fields

$[$U_Causale.0.0] for User Define Fields (UDF)

in case of UDF the UDF Must be positioned in the FORM not in the user defined field box otherwise will not work. so you must move it with the UI Editor in the main Form first.