here's one way we handled that. we created a new field, called 'distinct', and then a filter that searched the same form for the field's value, and set (via sql) the 'distinct' field to 1 only if no others were found, and 0 otherwise. then your table qualification could include 'distinct'=1
there are a number of challenges with that, but it may work for you. something like this: select decode(count(*),0,1,0) from my_table where request_id='$request_id$' On Wed, Jun 18, 2014 at 7: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"
