Skip to Content
author's profile photo Former Member
Former Member

Item.column.row ?

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 06:14 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 12:27 PM

    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=011000358700003625432006E&_SCENARIO=01100035870000000183&

    Hope this could clear for you

    Sagar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 02:58 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.