Saravanan, You can create a new integer field (say recent_flag) on your form set a default value as 0. And then make a filter on submit and Modify(if change is possible in emp name) to check if Employee Name already exist in same form then increase the value of existing entries by 1 every time by using push field action with modify all option.
So in this scenario you will always get recent_flag value 0 in your most recent entry. You can always use this recent_flag=0 in your web service qualification. Regards, Tarun Sharma -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Tuesday, March 11, 2008 7:13 PM To: [email protected] Subject: Re: Web service Saravanan, Basically, I think your solution can be found beyond what ARS web Services does. I think the problem that you have is the sort order of the form that your querying. If you can not change the sort order on the form directly (due to breaking existing functionality) then I think you can create a self Join (A join of the form with itself.) and set the sort order on the Join. Then point the Web Service to the Join to get the answer your after. Another option would be to "keep a high water mark" in one row in a special table that you would then query instead of the "source data" form. ( Like the way the arschema table is used for 'Request ID' values.) HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Tue, Mar 11, 2008 at 2:11 AM, Saravanan Palaniappan <[EMAIL PROTECTED]> wrote: > ** > > > > Hi all, > > I am trying to publish a web service using a get operation and my intention > is to get the most recent record of my search. > > I have been trying a lot with the qualification field in the web service > example: 'EMP ID' = XPATH(/ROOT/EMP_ID), but couldn't succeed in it. > > This particular qualification results in showing the first matching request > rather than the recent request... > > > > Could some one please help me on this? > > > > One more question: > > How could we use this qualification in the webservie for any operation? > Could you explain with some example? ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
