2 Replies Latest reply on Jun 30, 2010 11:27 AM by Ashwanth Padmanabhan

    How can i get the Table Row Count ?

      Share This:

      How can i get the Table Row Count ?

        • 1. Re: How can i get the Table Row Count ?

          I use $LASTCOUNT$

          keyword.

          Sequence as follows

          1) Refresh table using Change Field action

          2) use Set fields to get $LASTCOUNT$

           

          you must use the $LASTCOUNT$ keyword right after the refresh.

           

          --OR--

          You can use the COLCOUNT function, just make sure to use it on a table column where no nulls are listed to get an accurate count.

          Use COLCOUNT after the the table is refreshed of course.

          2 of 2 people found this helpful
          • 2. Re: How can i get the Table Row Count ?
            Ashwanth Padmanabhan

            Yes ,

             

            As mentioned, you can go with the Not Null Field value-(Go with the Request ID column(you can make it hidden if you don want to show it to the users) of the Backend Form)

             

            or you can jus specify the Table Name in the Function argument.

             

            Function:

             

            COLCOUNT

            (column) or (table)

            int

            For a list view, tree view, or results list table field, returns the total number of rows.
            For a column field, returns the total number of non-NULL rows in a given column.

             

            Object Type-Active Link

            Event-Menu/Row/Level Choice,Submit

            If Action:

            SetField

            CURRENT TRANSACTION

            ztmpRowCount=COLCOUNT($Table Field$)

             

            Or

             

            Object Type-Active Link

            Event-Menu/Row/Level Choice,Submit

            If Action:

            SetField

            CURRENT TRANSACTION

            ztmpRowCount=COLCOUNT($Column1$)

             

            Where Column1 is the Request ID.

             

            Ashwanth,

            3 of 3 people found this helpful