Serouche, You could use a table field and set the "Max Rows:" value on the Table Property tab. You could use a direct SQL Set Field action that uses RDBMS specific syntax to get the TOP N records.
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 4/10/07, Serouche Rahimpour <[EMAIL PROTECTED]> wrote:
dear listers, I would like to retrieve the last 20 entries where a user is either the submitter or in the cc list of a ticket. I built a button and an AL to find the entries based on the criterias (user = submitter or user = cc list) But it gives back 100 of rows. Whereas I would like to limit the result. Is it just possible ? serouche
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"

