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___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
