I have to place premilinary validations that also include based on the records that my select query has returned. I like to avoid using loop or converting this to a document list and then using pub.list.sizeoflist().
how can I do this in simplest way. Appreciate your help!
I did look at the user guide but did not find any information pertaining to my question. User guide talks about ‘maximum row’ field. User guide also talks about output field such as number of rows affected for insert and delete sql but not for select sql.
I tried this and it worked. I used pub.list.sizeofList flow service on my selectOutput.results list and it works fine. This was suggested by one the forum gurus for any type of documentList. I was just not sure whether it will work for results of selectSQL or not. But it works. Thanks!