You are going down the right path with a view and view form. Try this in your db view:
Select Batch_No, Submitter, max(request_id) >From VOD_SEET_Invoices where Batch_No <>'NA' group by Batch_No, Submitter With grouping, you won't get every request ID, the same way you won't using distinct, but this will give you A request ID to work with. Axton Grams On Wed, Jun 18, 2014 at 6:49 AM, Mona Fathy <[email protected]> wrote: > Hi All, > > I'm working on Remedy version 7.6.4, I have a table that reads from a > regular form "VOD_SEET_Invoices", I need to select distinct values from > this form through the qualification of the table. Is there a way or a > function to do that? I need the qualification of the table to be equivalent > to the following query: > > Select DISTINCT Batch_No, Submitter > From VOD_SEET_Invoices > where Batch_No <>'NA' > > > I tried to do that by creating a view in DB(reads from VOD_SEET_Invoices > form) that has the above statement and creating a view form on it and then > make the table reads from the view form instead of reading directly from > "VOD_SEET_Invoices", but it didn't give me the result that I need because I > faced the issue of selecting the Request ID of the view form. > > So I need a way to select the distinct values from "VOD_SEET_Invoices" > through the table that reads from it, can I? > > Thanks in advance, > Regards > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
