Ars 6.3, HD 6, patch 13, newbie question

I have a pretty basic "reporting" form that runs searches on tickets based
on some little information you enter. One "report" that I am trying to
setup is giving me a hard time with a Table Field Qualification. The
purpose of the table is simple, you type the name of server in a character
field, refresh the table fields and it shows all existing changes for that
server in table field 1, and the asset record for that server in table field
2. The asset one is pretty simple because I don't need the wildcard
feature, those names are pretty standard, the qualification is ( $Server
Name$ != $NULL$ ) AND (( $Server Name$ LIKE 'Name') OR ( $Server Name$ LIKE
'Asset ID+')).
Obviously $Server Name$ is the field on the reporting form that the person
would enter the server name in. 'Name' and 'Asset ID+' are the fields in
the asset form that might have the corresponding name.

The qualification for the Change ticket is throwing me. The change tickets
don't have a spot for the exact server name, they most likely will be in the
summary or description fields. This is where the wildcard comes into play.
The qualification for this is ( $Server Name$ != $NULL$ ) AND ( $Server
Name$ LIKE 'Summary'). Of course if they only enter XXXapp050 in the
Summary field I'm all set, but that will never happen. If I enter $Server
Name$ LIKE %'Summary'% or even $Server Name$ LIKE '%Summary%' I receive a
Qualification Line error at position...

I realize I'm overlooking something that has to be pretty easy but I can't
figure out what. I've looked into the Admin guides, and searched past
messages from the ARSLIST but wasn't able to find anything helpful. Can
anyone tell me what I'm doing wrong?

Thanks for help, and for the very insightful information I have learned
lurking around reading messages from responders.
Chris


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Try 'Summary' LIKE "%" + $Server Name$ + "%"

Thanks
Peter Lammey
ESPN MIT Technical Services & Applications Management
860-766-4761

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of VanAartsen, Christopher C
Sent: Wednesday, November 09, 2005 3:07 PM
To: arslist@ARSLIST.ORG
Subject: Wildcard function in Table

Ars 6.3, HD 6, patch 13, newbie question

I have a pretty basic "reporting" form that runs searches on tickets
based on some little information you enter. One "report" that I am
trying to setup is giving me a hard time with a Table Field
Qualification. The purpose of the table is simple, you type the name of
server in a character field, refresh the table fields and it shows all
existing changes for that server in table field 1, and the asset record
for that server in table field 2. The asset one is pretty simple
because I don't need the wildcard feature, those names are pretty
standard, the qualification is ( $Server Name$ != $NULL$ ) AND ((
$Server Name$ LIKE 'Name') OR ( $Server Name$ LIKE 'Asset ID+')).
Obviously $Server Name$ is the field on the reporting form that the
person would enter the server name in. 'Name' and 'Asset ID+' are the
fields in the asset form that might have the corresponding name.

The qualification for the Change ticket is throwing me. The change
tickets don't have a spot for the exact server name, they most likely
will be in the summary or description fields. This is where the wildcard
comes into play.
The qualification for this is ( $Server Name$ != $NULL$ ) AND ( $Server
Name$ LIKE 'Summary'). Of course if they only enter XXXapp050 in the
Summary field I'm all set, but that will never happen. If I enter
$Server Name$ LIKE %'Summary'% or even $Server Name$ LIKE '%Summary%' I
receive a Qualification Line error at position...

I realize I'm overlooking something that has to be pretty easy but I
can't figure out what. I've looked into the Admin guides, and searched
past messages from the ARSLIST but wasn't able to find anything helpful.
Can anyone tell me what I'm doing wrong?

Thanks for help, and for the very insightful information I have learned
lurking around reading messages from responders.
Chris



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Hi Christopher,
OK, it's late, so please excuse me if I'm not 100% on form with this one,
but try something like...

'Summary' LIKE "%" + $Server Name$ + "%"

This should return all results where the value in the "Server Name" field
on the current screen is all or part of the value in the "Summary" field
of the source form.

HTH
Chris


> Ars 6.3, HD 6, patch 13, newbie question
>
> I have a pretty basic "reporting" form that runs searches on tickets based
> on some little information you enter. One "report" that I am trying to
> setup is giving me a hard time with a Table Field Qualification. The
> purpose of the table is simple, you type the name of server in a character
> field, refresh the table fields and it shows all existing changes for that
> server in table field 1, and the asset record for that server in table
> field
> 2. The asset one is pretty simple because I don't need the wildcard
> feature, those names are pretty standard, the qualification is ( $Server
> Name$ != $NULL$ ) AND (( $Server Name$ LIKE 'Name') OR ( $Server Name$
> LIKE
> 'Asset ID+')).
> Obviously $Server Name$ is the field on the reporting form that the person
> would enter the server name in. 'Name' and 'Asset ID+' are the fields in
> the asset form that might have the corresponding name.
>
> The qualification for the Change ticket is throwing me. The change
> tickets
> don't have a spot for the exact server name, they most likely will be in
> the
> summary or description fields. This is where the wildcard comes into play.
> The qualification for this is ( $Server Name$ != $NULL$ ) AND ( $Server
> Name$ LIKE 'Summary'). Of course if they only enter XXXapp050 in the
> Summary field I'm all set, but that will never happen. If I enter $Server
> Name$ LIKE %'Summary'% or even $Server Name$ LIKE '%Summary%' I receive a
> Qualification Line error at position...
>
> I realize I'm overlooking something that has to be pretty easy but I can't
> figure out what. I've looked into the Admin guides, and searched past
> messages from the ARSLIST but wasn't able to find anything helpful. Can
> anyone tell me what I'm doing wrong?
>
> Thanks for help, and for the very insightful information I have learned
> lurking around reading messages from responders.
> Chris
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>


--

Chris Williams

Tel:+44 (0) 7769 657855
Mailto:chris@cjwsystems.com

This message is for the designated recipient only and may contain privileged,
proprietary, or otherwise private information. If you have received it in
error, please notify the sender immediately and delete the original. Any
other
use of the email by you is prohibited.


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)