Hello everyone. I am pleased to be a part of this list service. My
name is Brad Terhune and I work at the University of Tennessee as a
Remedy administrator and HelpDesk manager.

I have recently moved our HPD:HelpDesk form to the web and am pleased
with the results. However, when technicians log in, I want them to
either:

1.) Have a button that will show their open cases in the Query table
field at the bottom of the screen or

2.) Have the table and the cases show up automatically.

Really, what I want is to write and active link or something else that
will input an advanced search string into the Search area and then run
it. Ex. Run a Search where: $USER$ = $Assigned to Individual$ AND
"Status" <= "Pending"

I would have thought this would be rather simple to do but it I can't
figure it out. Any thoughts?

Brad

I believe you can just record a macro of the search.

I can't remember if you can record search variables within the advanced
search bar inside the macro though...I don't think you can, but someone
else might chime in on that. If not, you can place a hidden field on the
form and give that field the default value of $USER$, and search against
that and the Status fields in your macro....

If you set it up that way, all you need to do, is type $USER$ in that
hidden field, and $STATUS$ in the status field, then click the record
button and hit F5 to search. The macro will prompt you to enter values
for those fields, but that will only be for the purpose of recording the
macro. The user won't see that prompt, and the values won't be hardcoded
into the macro.

You may need an Active Link to populate the fields when the form is
opened, but as long as those fields are properly populated when the
macro is run by the user clicking on your button, then the search will
be based off those fields and should work just fine.

HTH.

Matt Taylor
Applications Specialist
Birch Telecom
(816) 300-1860 Desk
(816) 215-1715 Mobile

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Brad Terhune
Sent: Wednesday, November 03, 2004 8:57 AM
To: ARSLIST@ARSLIST.ORG
Subject: Remedy HelpDesk Web "Show My Open Cases"

Hello everyone. I am pleased to be a part of this list service. My
name is Brad Terhune and I work at the University of Tennessee as a
Remedy administrator and HelpDesk manager.

I have recently moved our HPD:HelpDesk form to the web and am pleased
with the results. However, when technicians log in, I want them to
either:

1.) Have a button that will show their open cases in the Query table
field at the bottom of the screen or

2.) Have the table and the cases show up automatically.

Really, what I want is to write and active link or something else that
will input an advanced search string into the Search area and then run
it. Ex. Run a Search where: $USER$ = $Assigned to Individual$ AND
"Status" <= "Pending"

I would have thought this would be rather simple to do but it I can't
figure it out. Any thoughts?

Brad



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

Brad,

Do you want them to have the option of which occurs, or are you choosing for
them?

We are using 4.5.2 and do not have HD, so these instructions may need "fine
tuning" however, generally:

1) Button method: Enter your Advanced Search into the Table Qualification in
the Admin tool. Create the button on the form. Create an AL. Execute on will
be your button. If Action will be "Change Fields". Select your Table as the
field, then check 'Refresh Table Field'. All done

2) Automatic method: Enter your Advanced Search into the Table Qualification
in the Admin tool. Create an AL with an Execute On of "window open" or
"display". If Action will be "Change Fields". Select your Table as the
field, then check 'Refresh Table Field'.

I think the Table Field can be set to refresh on new entry, so #2 may be
redundant

Hope this helps and welcome to "the club"!!

Shawn Stonequist
EMNS, Inc.

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Brad Terhune
Sent: Wednesday, November 03, 2004 8:57 AM
To: ARSLIST@ARSLIST.ORG
Subject: Remedy HelpDesk Web "Show My Open Cases"


Hello everyone. I am pleased to be a part of this list service. My
name is Brad Terhune and I work at the University of Tennessee as a
Remedy administrator and HelpDesk manager.

I have recently moved our HPD:HelpDesk form to the web and am pleased
with the results. However, when technicians log in, I want them to
either:

1.) Have a button that will show their open cases in the Query table
field at the bottom of the screen or

2.) Have the table and the cases show up automatically.

Really, what I want is to write and active link or something else that
will input an advanced search string into the Search area and then run
it. Ex. Run a Search where: $USER$ = $Assigned to Individual$ AND
"Status" <= "Pending"

I would have thought this would be rather simple to do but it I can't
figure it out. Any thoughts?

Brad



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com

This will not work on the web.

Kind Regards,
Axton Grams
New York Life
Remedy Solutions
Provider

Mobile: 404.861.7273
Work: 770.406.4415
Email: AxtonWGrams@NewYorkLife.com






|---------+---------------------------->
| | "Taylor, Matthew |
| | S." |
| | | | M> |
| | Sent by: "Action |
| | Request System |
| | discussion |
| | list(ARSList)" |
| | | | ORG> |
| | |
| | |
| | 11/03/2004 10:24 |
| | AM |
| | Please respond to|
| | arslist |
| | |
|---------+---------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
| |
| To: ARSLIST@ARSLIST.ORG |
| cc: |
| Subject: Re: Remedy HelpDesk Web "Show My Open Cases" |
>------------------------------------------------------------------------------------------------------------------------------|




I believe you can just record a macro of the search.

I can't remember if you can record search variables within the advanced
search bar inside the macro though...I don't think you can, but someone
else might chime in on that. If not, you can place a hidden field on the
form and give that field the default value of $USER$, and search against
that and the Status fields in your macro....

If you set it up that way, all you need to do, is type $USER$ in that
hidden field, and $STATUS$ in the status field, then click the record
button and hit F5 to search. The macro will prompt you to enter values
for those fields, but that will only be for the purpose of recording the
macro. The user won't see that prompt, and the values won't be hardcoded
into the macro.

You may need an Active Link to populate the fields when the form is
opened, but as long as those fields are properly populated when the
macro is run by the user clicking on your button, then the search will
be based off those fields and should work just fine.

HTH.

Matt Taylor
Applications Specialist
Birch Telecom
(816) 300-1860 Desk
(816) 215-1715 Mobile

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Brad Terhune
Sent: Wednesday, November 03, 2004 8:57 AM
To: ARSLIST@ARSLIST.ORG
Subject: Remedy HelpDesk Web "Show My Open Cases"

Hello everyone. I am pleased to be a part of this list service. My
name is Brad Terhune and I work at the University of Tennessee as a
Remedy administrator and HelpDesk manager.

I have recently moved our HPD:HelpDesk form to the web and am pleased
with the results. However, when technicians log in, I want them to
either:

1.) Have a button that will show their open cases in the Query table
field at the bottom of the screen or

2.) Have the table and the cases show up automatically.

Really, what I want is to write and active link or something else that
will input an advanced search string into the Search area and then run
it. Ex. Run a Search where: $USER$ = $Assigned to Individual$ AND
"Status" <= "Pending"

I would have thought this would be rather simple to do but it I can't
figure it out. Any thoughts?

Brad



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com

Matthew,

Variables can be used in the Advanced Search, just need to ensure they are
surrounded in double quotes for Character fields, e.g. 'Character Fld' =
"$Variable$".

If an Active Link is used to run a Macro with Variables, I know that it will
request Fields in the form to populate the Variables with, but I've never
done one leaving a Variable "unlinked" to a field, so I don't know the
consequences. I had set ours to open a Dialogue of a hidden view to act as
the Prompt for Variable inputs- display only fields so nothing is saved to
the Database and "mess up" future searches.

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Taylor, Matthew S.
Sent: Wednesday, November 03, 2004 9:24 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Remedy HelpDesk Web "Show My Open Cases"


I believe you can just record a macro of the search.

I can't remember if you can record search variables within the advanced
search bar inside the macro though...I don't think you can, but someone
else might chime in on that. If not, you can place a hidden field on the
form and give that field the default value of $USER$, and search against
that and the Status fields in your macro....

If you set it up that way, all you need to do, is type $USER$ in that
hidden field, and $STATUS$ in the status field, then click the record
button and hit F5 to search. The macro will prompt you to enter values
for those fields, but that will only be for the purpose of recording the
macro. The user won't see that prompt, and the values won't be hardcoded
into the macro.

You may need an Active Link to populate the fields when the form is
opened, but as long as those fields are properly populated when the
macro is run by the user clicking on your button, then the search will
be based off those fields and should work just fine.

HTH.

Matt Taylor
Applications Specialist
Birch Telecom
(816) 300-1860 Desk
(816) 215-1715 Mobile

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Brad Terhune
Sent: Wednesday, November 03, 2004 8:57 AM
To: ARSLIST@ARSLIST.ORG
Subject: Remedy HelpDesk Web "Show My Open Cases"

Hello everyone. I am pleased to be a part of this list service. My
name is Brad Terhune and I work at the University of Tennessee as a
Remedy administrator and HelpDesk manager.

I have recently moved our HPD:HelpDesk form to the web and am pleased
with the results. However, when technicians log in, I want them to
either:

1.) Have a button that will show their open cases in the Query table
field at the bottom of the screen or

2.) Have the table and the cases show up automatically.

Really, what I want is to write and active link or something else that
will input an advanced search string into the Search area and then run
it. Ex. Run a Search where: $USER$ = $Assigned to Individual$ AND
"Status" <= "Pending"

I would have thought this would be rather simple to do but it I can't
figure it out. Any thoughts?

Brad



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com

Brad,
Use the EXTERNAL function in the table Qualification.
1. Create a char. field i.e. TableExQual
2. In the Table Property tab for the table enter EXTERNAL($TableExQual$)
3. To have the table and cases come up automatically Create an active link that will Execute On Window Loaded, and the 1 Actions will be to set TableEXQual """$USER$"" = 'Assigned to Individual' AND 'Status' <= ""Pending""" 2 Action will be to Change Field to Refresh Table Field.
4. For the button you can do the same same active link just change the Execute On the a button.

Have fun

Tom Hamill
NGIT




-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Brad Terhune
Sent: Wednesday, November 03, 2004 9:57 AM
To: ARSLIST@ARSLIST.ORG
Subject: Remedy HelpDesk Web "Show My Open Cases"


Hello everyone. I am pleased to be a part of this list service. My
name is Brad Terhune and I work at the University of Tennessee as a
Remedy administrator and HelpDesk manager.

I have recently moved our HPD:HelpDesk form to the web and am pleased
with the results. However, when technicians log in, I want them to
either:

1.) Have a button that will show their open cases in the Query table
field at the bottom of the screen or

2.) Have the table and the cases show up automatically.

Really, what I want is to write and active link or something else that
will input an advanced search string into the Search area and then run
it. Ex. Run a Search where: $USER$ = $Assigned to Individual$ AND
"Status" <= "Pending"

I would have thought this would be rather simple to do but it I can't
figure it out. Any thoughts?

Brad

Careful, though, EXTERNAL() doesn't work on Mid-Tier until version 6.

Thanks,
Ron Legters
Tools Administrator
Production Systems Services
Univar USA




-----Original Message-----
From: Hamill, Thomas P [mailto:HamillTP@STATE.GOV]
Sent: Wednesday, November 03, 2004 8:34 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Remedy HelpDesk Web "Show My Open Cases"

Brad,
Use the EXTERNAL function in the table Qualification.
1. Create a char. field i.e. TableExQual
2. In the Table Property tab for the table enter
EXTERNAL($TableExQual$)
3. To have the table and cases come up automatically Create an
active link that will Execute On Window Loaded, and the 1 Actions will
be to set TableEXQual """$USER$"" = 'Assigned to Individual' AND
'Status' <= ""Pending""" 2 Action will be to Change Field to Refresh
Table Field.
4. For the button you can do the same same active link just
change the Execute On the a button.

Have fun

Tom Hamill
NGIT




-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Brad Terhune
Sent: Wednesday, November 03, 2004 9:57 AM
To: ARSLIST@ARSLIST.ORG
Subject: Remedy HelpDesk Web "Show My Open Cases"


Hello everyone. I am pleased to be a part of this list service. My
name is Brad Terhune and I work at the University of Tennessee as a
Remedy administrator and HelpDesk manager.

I have recently moved our HPD:HelpDesk form to the web and am pleased
with the results. However, when technicians log in, I want them to
either:

1.) Have a button that will show their open cases in the Query table
field at the bottom of the screen or

2.) Have the table and the cases show up automatically.

Really, what I want is to write and active link or something else that
will input an advanced search string into the Search area and then run
it. Ex. Run a Search where: $USER$ = $Assigned to Individual$ AND
"Status" <= "Pending"

I would have thought this would be rather simple to do but it I can't
figure it out. Any thoughts?

Brad



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

FYI...We are on 5.1.2 patch 1303 and EXTERNAL() works just fine through
Mid-Tier.



James Scott
IST
Mary Kay Inc.
972-687-5204


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Ron Legters
Sent: Wednesday, November 03, 2004 10:47 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Remedy HelpDesk Web "Show My Open Cases"


Careful, though, EXTERNAL() doesn't work on Mid-Tier until version 6.

Thanks,
Ron Legters
Tools Administrator
Production Systems Services
Univar USA




-----Original Message-----
From: Hamill, Thomas P [mailto:HamillTP@STATE.GOV]
Sent: Wednesday, November 03, 2004 8:34 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Remedy HelpDesk Web "Show My Open Cases"

Brad,
Use the EXTERNAL function in the table Qualification.
1. Create a char. field i.e. TableExQual
2. In the Table Property tab for the table enter
EXTERNAL($TableExQual$)
3. To have the table and cases come up automatically Create an
active link that will Execute On Window Loaded, and the 1 Actions will
be to set TableEXQual """$USER$"" = 'Assigned to Individual' AND
'Status' <= ""Pending""" 2 Action will be to Change Field to Refresh
Table Field.
4. For the button you can do the same same active link just
change the Execute On the a button.

Have fun

Tom Hamill
NGIT




-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Brad Terhune
Sent: Wednesday, November 03, 2004 9:57 AM
To: ARSLIST@ARSLIST.ORG
Subject: Remedy HelpDesk Web "Show My Open Cases"


Hello everyone. I am pleased to be a part of this list service. My
name is Brad Terhune and I work at the University of Tennessee as a
Remedy administrator and HelpDesk manager.

I have recently moved our HPD:HelpDesk form to the web and am pleased
with the results. However, when technicians log in, I want them to
either:

1.) Have a button that will show their open cases in the Query table
field at the bottom of the screen or

2.) Have the table and the cases show up automatically.

Really, what I want is to write and active link or something else that
will input an advanced search string into the Search area and then run
it. Ex. Run a Search where: $USER$ = $Assigned to Individual$ AND
"Status" <= "Pending"

I would have thought this would be rather simple to do but it I can't
figure it out. Any thoughts?

Brad



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

I'm on 5.01.02 patch 1303 and EXTERNAL ()works fine in Mid-Tier.

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Ron Legters
Sent: Wednesday, November 03, 2004 11:47 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Remedy HelpDesk Web "Show My Open Cases"


Careful, though, EXTERNAL() doesn't work on Mid-Tier until version 6.

Thanks,
Ron Legters
Tools Administrator
Production Systems Services
Univar USA




-----Original Message-----
From: Hamill, Thomas P [mailto:HamillTP@STATE.GOV]
Sent: Wednesday, November 03, 2004 8:34 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Remedy HelpDesk Web "Show My Open Cases"

Brad,
Use the EXTERNAL function in the table Qualification.
1. Create a char. field i.e. TableExQual
2. In the Table Property tab for the table enter
EXTERNAL($TableExQual$)
3. To have the table and cases come up automatically Create an
active link that will Execute On Window Loaded, and the 1 Actions will
be to set TableEXQual """$USER$"" = 'Assigned to Individual' AND
'Status' <= ""Pending""" 2 Action will be to Change Field to Refresh
Table Field.
4. For the button you can do the same same active link just
change the Execute On the a button.

Have fun

Tom Hamill
NGIT




-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Brad Terhune
Sent: Wednesday, November 03, 2004 9:57 AM
To: ARSLIST@ARSLIST.ORG
Subject: Remedy HelpDesk Web "Show My Open Cases"


Hello everyone. I am pleased to be a part of this list service. My
name is Brad Terhune and I work at the University of Tennessee as a
Remedy administrator and HelpDesk manager.

I have recently moved our HPD:HelpDesk form to the web and am pleased
with the results. However, when technicians log in, I want them to
either:

1.) Have a button that will show their open cases in the Query table
field at the bottom of the screen or

2.) Have the table and the cases show up automatically.

Really, what I want is to write and active link or something else that
will input an advanced search string into the Search area and then run
it. Ex. Run a Search where: $USER$ = $Assigned to Individual$ AND
"Status" <= "Pending"

I would have thought this would be rather simple to do but it I can't
figure it out. Any thoughts?

Brad



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

I stand corrected. I haven't patched my Mid-Tier in production, and I'm
moving to 6.0.1 in a couple of weeks, so I'm not planning to.


Thanks,
Ron
Tools Admin


-----Original Message-----
From: Scott, James [mailto:James.Scott@MKCORP.COM]
Sent: Wednesday, November 03, 2004 8:53 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Remedy HelpDesk Web "Show My Open Cases"

FYI...We are on 5.1.2 patch 1303 and EXTERNAL() works just fine through
Mid-Tier.



James Scott
IST
Mary Kay Inc.
972-687-5204


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Ron Legters
Sent: Wednesday, November 03, 2004 10:47 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Remedy HelpDesk Web "Show My Open Cases"


Careful, though, EXTERNAL() doesn't work on Mid-Tier until version 6.

Thanks,
Ron Legters
Tools Administrator
Production Systems Services
Univar USA




-----Original Message-----
From: Hamill, Thomas P [mailto:HamillTP@STATE.GOV]
Sent: Wednesday, November 03, 2004 8:34 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Remedy HelpDesk Web "Show My Open Cases"

Brad,
Use the EXTERNAL function in the table Qualification.
1. Create a char. field i.e. TableExQual
2. In the Table Property tab for the table enter
EXTERNAL($TableExQual$)
3. To have the table and cases come up automatically Create an
active link that will Execute On Window Loaded, and the 1 Actions will
be to set TableEXQual """$USER$"" = 'Assigned to Individual' AND
'Status' <= ""Pending""" 2 Action will be to Change Field to Refresh
Table Field.
4. For the button you can do the same same active link just
change the Execute On the a button.

Have fun

Tom Hamill
NGIT




-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Brad Terhune
Sent: Wednesday, November 03, 2004 9:57 AM
To: ARSLIST@ARSLIST.ORG
Subject: Remedy HelpDesk Web "Show My Open Cases"


Hello everyone. I am pleased to be a part of this list service. My
name is Brad Terhune and I work at the University of Tennessee as a
Remedy administrator and HelpDesk manager.

I have recently moved our HPD:HelpDesk form to the web and am pleased
with the results. However, when technicians log in, I want them to
either:

1.) Have a button that will show their open cases in the Query table
field at the bottom of the screen or

2.) Have the table and the cases show up automatically.

Really, what I want is to write and active link or something else that
will input an advanced search string into the Search area and then run
it. Ex. Run a Search where: $USER$ = $Assigned to Individual$ AND
"Status" <= "Pending"

I would have thought this would be rather simple to do but it I can't
figure it out. Any thoughts?

Brad



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com