2 Replies Latest reply on May 6, 2010 12:09 PM by stellq

    How to get all the record of the field

    stellq

      Title

      How to get all the record of the field

      Post

      Hello,

       

      Using which fonction, I can get all the values of special field ?

       

      :smileyhappy:

        • 1. Re: How to get all the record of the field
          mrvodka

          REpeating values only shown once or twice? If only shown once then you can create a value list based off that field and then use ValueListItems to retrieve the values.

           

          For the other you can either create a self join using a cartesian join ( 'X' operator ) and then use List ( ) on the self join to get all the values ), or you can write a looping script to capture the data into a variable and then output it to something like a global text field.

           

          For example:

           

          Freeze Window

          Go to Layout [ YourLayout ]

          Go to Record [ First ]

          Loop

          Set Variable [ $values; List ( $values; YourField ) ]

          Go to Record [ Next; Exit After Last ]

          End Loop

          Set Field [ gTemp; $values ]

           

          • 2. Re: How to get all the record of the field
            stellq

            That's what I want, thank you very much!!!! :smileywink: