cancel
Showing results for 
Search instead for 
Did you mean: 

Item.column.row ?

Former Member
0 Kudos
1,201

Hi,

I just have a simple question regarding the notation $[$item.column.row] in Formatted Searches

When working with singular data fields such as Business Partner name or number e.g $[$34.3.0] will suffice.

However, when I work with a table/grid the third number which supposedly represents the row number doesn't seem to work. Regardless if I write $[$34.3.3] or $[$34.3.1] or $[$34.3.0] only the very first row of the table is selected. Why is this?

I have seen posts on this forum that suggest that the coordinate is to indicate row, but I can't seem this to work. Am I the one being stupid? or is the third number used for something else aside from the row?

Help would be very much appreciated.

Cheers

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Thank you so much for your feedback. It was a lot of help.

As a final question. Do any of you know, if it is possible to itirate through rows using some SBO specific syntax, or is this not possible without the use of the SDK?

Cheers

former_member583013
Active Contributor
0 Kudos

To iterate through the row you will need to do it through SDK.

Best wishes

Suda

Answers (2)

Answers (2)

former_member583013
Active Contributor
0 Kudos

Shahbaz Ahmed,

I can see that Sagar has given the complete picture. But a quick note on your sentence

third number which supposedly represents the row number doesn't seem to work

The Third number does NOT represent the row. It indicates the column TYPE

$\[$Item.Column.Type]

Example: When you extract the Price field from the Document Rows, it will also contain the Currency Symbol. In order to extract just the number value from the Price column you will use $\[$38.17.Number]

Suda

Former Member
0 Kudos

SAP Business One provides two different syntaxes for this type of query:

u2022 $[Tablename.Fieldname]

Tablename u2013 Indicates the table to which the active window relates.

Fieldname u2013 The field from the active window.

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

This syntax uses the fieldu2019s index instead of the specific document table.

This query syntax includes 3 elements:

Field Index u2013 You can relate to each field in the active window using a unique index.

Field Column - If the required field is a table field (Item Number, Item Description, Unit Price, Quantity in sales and purchasing documents and so on) relate to it by index and column numbers. If the required field is a header field, set this element to 0.

Number / Currency / Date / 0

Use Number if the required field includes a number + a currency symbol (item price, document total), to retrieve the number (without the currency symbol or the unit of measurement). This separation is essential when you wish to use the price for arithmetic expressions.

Use Currency to retrieve the currency symbol or the unit of measurement.

Use Date if the required field is a Date field and you need to use it for computation

Use 0 if the field contains a single value (Quantity, Item Number, Item Description, Business Partner Code or Document Number)

Still u need to clear idea then log on this link

https://websmp108.sap-ag.de/~form/sapnet?_FRAME=CONTAINER&_HIER_KEY=701100035871000437965&_OBJECT=01...;

Hope this could clear for you

Sagar