I want to be able to add a next button on the query screen that will bring
up the next list of tickets that meets the same qualifications. Example: If
the query is set to bring back 10 and it found a total of 100 I want to be
able to click "Next" to bring up the next ten, then the next ten, and so
forth.


Laren Bailey
Remedy Administrator
Robert Bosch Corporation

Laren,

I don't think this is possible. There's no way to return more than the
specified number of tickets, so there is no way to know what the next x
tickets are - you'll get the same 10 every time.

Unless you are experiencing performance issues with your server or DB, or
are using slow connections to your clients, I'd consider increasing your
query limits to a value that will allow you to return the number of records
you're likely to need. Our server is set to unlimited, and I typically
configure our clients for 1000, unless the user does things like Help Desk
metrics, in which case I set it higher or eliminate it altogether.

On the other hand, your idea is not unreasonable. I'd suggest submitting an
enhancement request to Remedy.

--On Tuesday, February 06, 2001 11:38 AM -0500 "Bailey Laren (AN/CIT1.2)"
wrote:

> **
>
> I want to be able to add a next button on the query screen that will bring
> up the next list of tickets that meets the same qualifications. Example:
> If the query is set to bring back 10 and it found a total of 100 I want
> to be able to click "Next" to bring up the next ten, then the next ten,
> and so forth.
>
>
> Laren Bailey
> Remedy Administrator
> Robert Bosch Corporation
>
>
>
>



------------------------------------------------------------------------
Adam Wilkinson awilkins@umich.edu 734/936-8368
------------------------------------------------------------------------
University of Michigan
Information Technology Central Services
UMCE User Services

Remedy Helpdesk Project Leader, Consulting Tools Project Leader,
Expert Consultant and Virus Buster
------------------------------------------------------------------------

I think this can done with this idea:

Result set from databases gives you a filed called ROWNUM. The ROWNUM is really
a pseudo-column that Oracle generates each time the query is run for the RESULTS
of the query only, not the data in the table. Using this concept you can browse
your results

See EX:
SELECT rownum, COL1 FROM Table1

ROWNUM COL1
--------- ----------
1 F
2 B
3 G
4 H
5 I
6 J
7 D
8 E
9 Z
10 A
11 T

11 rows selected.

However, this doesn't work:

SELECT rownum, col1 FROM Table1
WHERE rownum BETWEEN 5 AND 7

no rows selected

Now, use Nested SQL to get around:

SELECT t1.rn, t1.col1
FROM (SELECT rownum rn, col1
FROM Table1 ) t1
WHERE t1.rn BETWEEN 5 AND 7

RN COL1
--------- ----------
5 I
6 J
7 D

3 rows selected.


Hope this helps..

ravi






Adam Wilkinson on 02/07/2001 12:41:09 PM

Please respond to "Action Request System discussion list(ARSList)"


To: ARSLIST@LISTSERV.VISTAIT.COM
cc: (bcc: Ravi Bommareddy/Det/J Walter Thompson)
Subject: Re: "Next" button on a query screen



**

Laren,

I don't think this is possible. There's no way to return more than the
specified number of tickets, so there is no way to know what the next x
tickets are - you'll get the same 10 every time.

Unless you are experiencing performance issues with your server or DB, or
are using slow connections to your clients, I'd consider increasing your
query limits to a value that will allow you to return the number of records
you're likely to need. Our server is set to unlimited, and I typically
configure our clients for 1000, unless the user does things like Help Desk
metrics, in which case I set it higher or eliminate it altogether.

On the other hand, your idea is not unreasonable. I'd suggest submitting an
enhancement request to Remedy.

--On Tuesday, February 06, 2001 11:38 AM -0500 "Bailey Laren (AN/CIT1.2)"
wrote:

> **
>
> I want to be able to add a next button on the query screen that will bring
> up the next list of tickets that meets the same qualifications. Example:
> If the query is set to bring back 10 and it found a total of 100 I want
> to be able to click "Next" to bring up the next ten, then the next ten,
> and so forth.
>
>
> Laren Bailey
> Remedy Administrator
> Robert Bosch Corporation
>
>
>
>



------------------------------------------------------------------------
Adam Wilkinson awilkins@umich.edu 734/936-8368
------------------------------------------------------------------------
University of Michigan
Information Technology Central Services
UMCE User Services

Remedy Helpdesk Project Leader, Consulting Tools Project Leader,
Expert Consultant and Virus Buster
------------------------------------------------------------------------

Just out of curiousity. Could you not set up a macro to get the next 10 results. I am still quite new to this.

Thank you

Emmanuel

Remedy Consultant



>From: Adam Wilkinson
>Reply-To: "Action Request System discussion list(ARSList)"
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Re: "Next" button on a query screen
>Date: Wed, 7 Feb 2001 12:41:09 -0500
>
>**
>
>Laren,
>
>I don't think this is possible. There's no way to return more than
>the
>specified number of tickets, so there is no way to know what the
>next x
>tickets are - you'll get the same 10 every time.
>
>Unless you are experiencing performance issues with your server or
>DB, or
>are using slow connections to your clients, I'd consider increasing
>your
>query limits to a value that will allow you to return the number of
>records
>you're likely to need. Our server is set to unlimited, and I
>typically
>configure our clients for 1000, unless the user does things like
>Help Desk
>metrics, in which case I set it higher or eliminate it altogether.
>
>On the other hand, your idea is not unreasonable. I'd suggest
>submitting an
>enhancement request to Remedy.
>
>--On Tuesday, February 06, 2001 11:38 AM -0500 "Bailey Laren
>(AN/CIT1.2)"
> wrote:
>
>>**
>>
>>I want to be able to add a next button on the query screen that
>>will bring
>>up the next list of tickets that meets the same qualifications.
>>Example:
>>If the query is set to bring back 10 and it found a total of 100 I
>>want
>>to be able to click "Next" to bring up the next ten, then the next
>>ten,
>>and so forth.
>>
>>
>>Laren Bailey
>>Remedy Administrator
>>Robert Bosch Corporation
>>
>>
>>
>>
>
>
>
>------------------------------------------------------------------------
>Adam Wilkinson awilkins@umich.edu
>734/936-8368
>------------------------------------------------------------------------
> University of Michigan
> Information Technology Central Services
> UMCE User Services
>
> Remedy Helpdesk Project Leader, Consulting Tools Project Leader,
> Expert Consultant and Virus Buster
>------------------------------------------------------------------------
>
>
>
>

_____

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

and add another part to it regarding the Request ID for example. It it is a plain search without
any qualifications it could be done by some Direct SQL Set Fields operation where you
query the table/form for the 10th Request ID and stores the result in a display only field
$TempLastIDOnPage$. After that is done an Active Link could be used to perform a search on
the form with a qualification like 'Request ID' > $TempLastIDOnPage$.
This approach depends on the capabilities of the DB engine and if it supports the SELECT TOP X syntax.
Have not tried this but it could work...

Wouldn't it be wonderful if there was a keyword like $QUALIFICATION$ that contained the last search
qualification string used? Maybe some nice move operations available in active links too...
What do you think about move next, previous, first and last options regarding the currect result list...

/Per Salmi

-----Ursprungligt meddelande-----
Från: Action Request System discussion list(ARSList) [mailto:ARSLIST@LISTSERV.VISTAIT.COM]För xanatos baptiste
Skickat: den 8 februari 2001 13:49
Till: ARSLIST@LISTSERV.VISTAIT.COM
Ämne: Re: "Next" button on a query screen


**

Just out of curiousity. Could you not set up a macro to get the next 10 results. I am still quite new to this.

Thank you

Emmanuel

Remedy Consultant



>From: Adam Wilkinson
>Reply-To: "Action Request System discussion list(ARSList)"
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Re: "Next" button on a query screen
>Date: Wed, 7 Feb 2001 12:41:09 -0500
>
>**
>
>Laren,
>
>I don't think this is possible. There's no way to return more than
>the
>specified number of tickets, so there is no way to know what the
>next x
>tickets are - you'll get the same 10 every time.
>
>Unless you are experiencing performance issues with your server or
>DB, or
>are using slow connections to your clients, I'd consider increasing
>your
>query limits to a value that will allow you to return the number of
>records
>you're likely to need. Our server is set to unlimited, and I
>typically
>configure our clients for 1000, unless the user does things like
>Help Desk
>metrics, in which case I set it higher or eliminate it altogether.
>
>On the other hand, your idea is not unreasonable. I'd suggest
>submitting an
>enhancement request to Remedy.
>
>--On Tuesday, February 06, 2001 11:38 AM -0500 "Bailey Laren
>(AN/CIT1.2)"
> wrote:
>
>>**
>>
>>I want to be able to add a next button on the query screen that
>>will bring
>>up the next list of tickets that meets the same qualifications.
>>Example:
>>If the query is set to bring back 10 and it found a total of 100 I
>>want
>>to be able to click "Next" to bring up the next ten, then the next
>>ten,
>>and so forth.
>>
>>
>>Laren Bailey
>>Remedy Administrator
>>Robert Bosch Corporation
>>
>>
>>
>>
>
>
>
>------------------------------------------------------------------------
>Adam Wilkinson awilkins@umich.edu
>734/936-8368
>------------------------------------------------------------------------
> University of Michigan
> Information Technology Central Services
> UMCE User Services
>
> Remedy Helpdesk Project Leader, Consulting Tools Project Leader,
> Expert Consultant and Virus Buster
>------------------------------------------------------------------------
>
>
>
>

_____

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.