Ok ... Since you are not doing this to have users see and scroll thru the table field values, You can just use standard Set Field actions to get the data you want. If you are getting the rows in a SQL Set fields action just add a Where clause to the SQL
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ganga Prasad Sent: Monday, May 12, 2008 1:22 PM To: [email protected] Subject: Re: Knowing Row number in table based on a value ** You are almost there..As I mentioned I need to go to the particular row where coumn5 value = "XYZ" My pupose is once I am selection that particular row I will set field the other colum values also to my regular fields -- Thanks and Regards, Ganga Prasad Pattnaik, ------------------------------------------------- On Mon, May 12, 2008 at 11:40 PM, Grooms, Frederick W <[EMAIL PROTECTED]> wrote: ** Are you wanting to do this for moving to a specific row in a Table field? Some more info on what you are trying to do would be helpful. Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ganga Prasad Sent: Monday, May 12, 2008 1:00 PM To: [email protected] Subject: Knowing Row number in table based on a value Hi List I am in mid of a requirement where I need to walk through every row to get my particular row. Here the data to the table is coming from external Data Base(not of much concern about the source). This external Data Base returns 700-800 rows at once. And walking through 800 rows is really time consuming it takes minutes to find my particular data. Thats why I thought of implementing Binary search in Remedy. It will considerably reduce the time to some seconds. Can eny one give some starting idea for the same.. ?? Syntactically my requirement is : I will be returned with 800 rows. I need to go to the particular row where coumn5 value = "XYZ" More ever if anyone can suggest how to come to know the row number of row that contain "PQR" in its column8. ARS 7.0.0 No ITSM (Customized appl) Oracle 10g Unix -- Thanks and Regards, Ganga Prasad Pattnaik, ------------------------------------------------- __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
