on 06-18-2008 1:07 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hope this could clear for you
Sagar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.