Ganga,
Just a thought.that might give you some idea.. 1) Have a Column (may be hidden) in the table with a running serial number (like oracle rownum). ( data source\c++ code need to support it) 2) Using another set action from the same data source find out the row num (say $rownum$) for your where clause (Column5 = XYZ) 3) And then assign the $Tablefield$ = $rownum$ Thanks, VB _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Monday, May 12, 2008 3:51 PM To: [email protected] Subject: Re: Knowing Row number in table based on a value So you get the data from the other system. Are you saving that data into a table (with your c++ code)? If so then you can do your own SQL query against the data you received. If not you could modify your c++ code to allow sending a parameter to search the results inside the c++ code. Personally I would have the c++ code save the data to a table and then run an SQL search against that data. _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ganga Prasad Sent: Monday, May 12, 2008 2:32 PM To: [email protected] Subject: Re: Knowing Row number in table based on a value ** Yes Your idea seems good as long as I have the capability to query the Databse. But here as I said the data to the table is coming from external database. I access the web services published by the database using ARSystem plugin c++ code. I don't have any control as the SQL is implemented in the Dabase itself. I can only see the data returned from the external source. Once it reaches my Table i need to to the whole stuff... Any good Idea for this ?? -- Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) ------------------------------------------------- On Tue, May 13, 2008 at 12:53 AM, Grooms, Frederick W <[EMAIL PROTECTED]> wrote: ** 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___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __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"
