CODEWITHSUNDEEP
oracle-ucmstellentidocscript
vk239
vk239

Reputation: 1044

How to find length of ResultSet using IdocScript in Oracle UCM?

I am trying to find number of rows in a ResultSet using idocscript. Is there an optimal way of doing other than looping through the ResultSet as below?

<$sampleRSLength=0$>
<$if rsExists("sampleResultSet")$>
  <$loop sampleResultSet$>
    <$sampleRSLength=sampleRSLength+1$>
  <$endloop$>
<$endif$>

Upvotes: 0

Views: 228

Answers (2)

William Phelps
William Phelps

Reputation: 21

<$sampleResultSet.#numRows$>

will also work.

Upvotes: 1

vk239
vk239

Reputation: 1044

I was able to find the answer myself after reading through the IdocScript reference guide in detail.

Idocscript has a method rsNumRows() which can be used for getting number of rows in a result set. 

<$if rsExists("sampleResultSet")$>
 <$sampleRSLength=rsNumRows("sampleResultSet")$>
<$endif$>

Upvotes: 1

Related Questions