Howdy Listers --

I'm stumped. I have a Character field (it's #4, the Assigned To
field), and it has a default, "Support." If I log a ticket and
delete the entry for this field, and submit the ticket, "Support"
gets back into that field. I have checked my workflow log (for
the Active Links) and Filter log on the server. There are several
ALs and Filters, but I have looked carefully and can't see any
place where the value of Support is getting put in there.

I do have workflow that can change this value, depending on other
options, but I should see that in the logs, I'd think.

The field is not required.

This only happens on Submit. Is it possible that with a default
on a system field that if I submit a $NULL$ value it puts the
default in place?

Any thoughts of what else I can check?

Thanks,

Dan


AR Server: 5.00.01, Patch 1156, on Solaris 5.8
Mid-Tier: 5.01.00, on Windows 2000
DB: Sybase 12.0.0.4/P
User Tool: 5.00.01
Admin Tool: 5.00.01, Patch 1159
My Desktop: Windows 2000
Solaris User: 4.05.01


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

That's what default value means. If there's no value, then it's set
to the default value by the server. The user tool shows you the
default values in a submit window to allow you to modify them.
If you truly want to force the field to be empty on submit, try
$NULL$ in it. If that doesn't work, create a special value like
"." and a filter that set the field to $NULL$ when it's "."


-----Original Message-----
From: Celotta, Daniel [mailto:daniel.celotta@NAVITAIRE.COM]
Sent: Friday, January 03, 2003 15:34
To: ARSLIST@ARSLIST.ORG
Subject: Default on Character Field?

Howdy Listers --

I'm stumped. I have a Character field (it's #4, the Assigned To
field), and it has a default, "Support." If I log a ticket and
delete the entry for this field, and submit the ticket, "Support"
gets back into that field. I have checked my workflow log (for
the Active Links) and Filter log on the server. There are several
ALs and Filters, but I have looked carefully and can't see any
place where the value of Support is getting put in there.

I do have workflow that can change this value, depending on other
options, but I should see that in the logs, I'd think.

The field is not required.

This only happens on Submit. Is it possible that with a default
on a system field that if I submit a $NULL$ value it puts the
default in place?

Any thoughts of what else I can check?

Thanks,

Dan


AR Server: 5.00.01, Patch 1156, on Solaris 5.8
Mid-Tier: 5.01.00, on Windows 2000
DB: Sybase 12.0.0.4/P
User Tool: 5.00.01
Admin Tool: 5.00.01, Patch 1159
My Desktop: Windows 2000
Solaris User: 4.05.01



You may control your subscription options, including UNSUBSCRIBE,and ACCESS
THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

Dan,

I believe that's what is suppose to happen- if a field with a default value
is left NULL on Submit, it is set to its default value. To prevent this,
remove the default value, or enter any value on submit.

HTH
Shawn

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Celotta, Daniel
Sent: Friday, January 03, 2003 14:34
To: ARSLIST@ARSLIST.ORG
Subject: Default on Character Field?


Howdy Listers --

I'm stumped. I have a Character field (it's #4, the Assigned To
field), and it has a default, "Support." If I log a ticket and
delete the entry for this field, and submit the ticket, "Support"
gets back into that field. I have checked my workflow log (for
the Active Links) and Filter log on the server. There are several
ALs and Filters, but I have looked carefully and can't see any
place where the value of Support is getting put in there.

I do have workflow that can change this value, depending on other
options, but I should see that in the logs, I'd think.

The field is not required.

This only happens on Submit. Is it possible that with a default
on a system field that if I submit a $NULL$ value it puts the
default in place?

Any thoughts of what else I can check?

Thanks,

Dan


AR Server: 5.00.01, Patch 1156, on Solaris 5.8
Mid-Tier: 5.01.00, on Windows 2000
DB: Sybase 12.0.0.4/P
User Tool: 5.00.01
Admin Tool: 5.00.01, Patch 1159
My Desktop: Windows 2000
Solaris User: 4.05.01



You may control your subscription options, including UNSUBSCRIBE,and ACCESS
THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

Dan,

Once there is a default value on a field, if a record is being created and
the field is null, the default value will be entered. This is not done
through an active link or a filter. It also does not matter whether or not
the field is required. What determines whether the default value is used is
whether the person submitting the request chooses to put a value in the
field.

Ozzie

----- Original Message -----
From: "Celotta, Daniel"
To:
Sent: Friday, January 03, 2003 3:34 PM
Subject: Default on Character Field?


> Howdy Listers --
>
> I'm stumped. I have a Character field (it's #4, the Assigned To
> field), and it has a default, "Support." If I log a ticket and
> delete the entry for this field, and submit the ticket, "Support"
> gets back into that field. I have checked my workflow log (for
> the Active Links) and Filter log on the server. There are several
> ALs and Filters, but I have looked carefully and can't see any
> place where the value of Support is getting put in there.
>
> I do have workflow that can change this value, depending on other
> options, but I should see that in the logs, I'd think.
>
> The field is not required.
>
> This only happens on Submit. Is it possible that with a default
> on a system field that if I submit a $NULL$ value it puts the
> default in place?
>
> Any thoughts of what else I can check?
>
> Thanks,
>
> Dan
>
>
> AR Server: 5.00.01, Patch 1156, on Solaris 5.8
> Mid-Tier: 5.01.00, on Windows 2000
> DB: Sybase 12.0.0.4/P
> User Tool: 5.00.01
> Admin Tool: 5.00.01, Patch 1159
> My Desktop: Windows 2000
> Solaris User: 4.05.01
>
>


> You may control your subscription options, including UNSUBSCRIBE,and
ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please
send eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

Daniel:

That is what the purpose of assigning a "Default Value" to a field is.

In order for the field to remain 'blank' you will have to unset the default
value for the field in the adminstrator tool for the field.

James Mckenzie

-----Original Message-----
From: Celotta, Daniel [mailto:daniel.celotta@NAVITAIRE.COM]
Sent: Friday, January 03, 2003 1:34 PM
To: ARSLIST@ARSLIST.ORG
Subject: Default on Character Field?


Howdy Listers --

I'm stumped. I have a Character field (it's #4, the Assigned To
field), and it has a default, "Support." If I log a ticket and
delete the entry for this field, and submit the ticket, "Support"
gets back into that field. I have checked my workflow log (for
the Active Links) and Filter log on the server. There are several
ALs and Filters, but I have looked carefully and can't see any
place where the value of Support is getting put in there.

I do have workflow that can change this value, depending on other
options, but I should see that in the logs, I'd think.

The field is not required.

This only happens on Submit. Is it possible that with a default
on a system field that if I submit a $NULL$ value it puts the
default in place?

Any thoughts of what else I can check?

Thanks,

Dan


AR Server: 5.00.01, Patch 1156, on Solaris 5.8
Mid-Tier: 5.01.00, on Windows 2000
DB: Sybase 12.0.0.4/P
User Tool: 5.00.01
Admin Tool: 5.00.01, Patch 1159
My Desktop: Windows 2000
Solaris User: 4.05.01



You may control your subscription options, including UNSUBSCRIBE,and ACCESS
THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

Daniel,
Your assumption is correct. If you have a default value set on a field,
and manually clear it prior to submission, if no other workflow fires
against that field the default value will still be set. I tested this on a
demo form and that is exactly the behavior I observed.

Christian Smerz

At 02:34 PM 1/3/2003 -0600, you wrote:
>Howdy Listers --
>
>I'm stumped. I have a Character field (it's #4, the Assigned To
>field), and it has a default, "Support." If I log a ticket and
>delete the entry for this field, and submit the ticket, "Support"
>gets back into that field. I have checked my workflow log (for
>the Active Links) and Filter log on the server. There are several
>ALs and Filters, but I have looked carefully and can't see any
>place where the value of Support is getting put in there.
>
>I do have workflow that can change this value, depending on other
>options, but I should see that in the logs, I'd think.
>
>The field is not required.
>
>This only happens on Submit. Is it possible that with a default
>on a system field that if I submit a $NULL$ value it puts the
>default in place?
>
>Any thoughts of what else I can check?
>
>Thanks,
>
>Dan
>
>
>AR Server: 5.00.01, Patch 1156, on Solaris 5.8
>Mid-Tier: 5.01.00, on Windows 2000
>DB: Sybase 12.0.0.4/P
>User Tool: 5.00.01
>Admin Tool: 5.00.01, Patch 1159
>My Desktop: Windows 2000
>Solaris User: 4.05.01
>
>
>You may control your subscription options, including UNSUBSCRIBE,and
>ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please
>send eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

Makes sense. Thank you all. I figured that default gave me an initial
value for the field, and that since I could override it with any other
value, I thought it should also be true for an empty value. After
re-reading the WF guide, I see it does say this, but I didn't get
it the first time around.

Thanks,

Dan

-----Original Message-----
From: Shawn Stonequist [mailto:shawn.stonequist@EMNS.COM]
Sent: Friday, January 03, 2003 2:53 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Default on Character Field?


Dan,

I believe that's what is suppose to happen- if a field with a default value
is left NULL on Submit, it is set to its default value. To prevent this,
remove the default value, or enter any value on submit.

HTH
Shawn

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Celotta, Daniel
Sent: Friday, January 03, 2003 14:34
To: ARSLIST@ARSLIST.ORG
Subject: Default on Character Field?


Howdy Listers --

I'm stumped. I have a Character field (it's #4, the Assigned To
field), and it has a default, "Support." If I log a ticket and
delete the entry for this field, and submit the ticket, "Support"
gets back into that field. I have checked my workflow log (for
the Active Links) and Filter log on the server. There are several
ALs and Filters, but I have looked carefully and can't see any
place where the value of Support is getting put in there.

I do have workflow that can change this value, depending on other
options, but I should see that in the logs, I'd think.

The field is not required.

This only happens on Submit. Is it possible that with a default
on a system field that if I submit a $NULL$ value it puts the
default in place?

Any thoughts of what else I can check?

Thanks,

Dan


AR Server: 5.00.01, Patch 1156, on Solaris 5.8
Mid-Tier: 5.01.00, on Windows 2000
DB: Sybase 12.0.0.4/P
User Tool: 5.00.01
Admin Tool: 5.00.01, Patch 1159
My Desktop: Windows 2000
Solaris User: 4.05.01



You may control your subscription options, including UNSUBSCRIBE,and ACCESS
THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
eMail to support@arslist.org



You may control your subscription options, including UNSUBSCRIBE,and ACCESS
THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

Hi Daniel,

When using a default value as a field attribute, that value is always
filled in when that field is left blank at submit. So clearing the
contents of the field on submit is not the solution. If you really want
no value stored in that field, clearing the field is not enough, but you
have to fill in $NULL$ as a value.

Met vriendelijke groet,

Patrick Simon, The Service Company
Tel: +31 (0) 6 41 767 743
Mail: psimon@thesco.nl
Web: http://www.thesco.nl


-----Oorspronkelijk bericht-----
Van: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] Namens Celotta, Daniel
Verzonden: vrijdag 3 januari 2003 21:34
Aan: ARSLIST@ARSLIST.ORG
Onderwerp: Default on Character Field?


Howdy Listers --

I'm stumped. I have a Character field (it's #4, the Assigned To field),
and it has a default, "Support." If I log a ticket and delete the entry
for this field, and submit the ticket, "Support" gets back into that
field. I have checked my workflow log (for the Active Links) and Filter
log on the server. There are several ALs and Filters, but I have looked
carefully and can't see any place where the value of Support is getting
put in there.

I do have workflow that can change this value, depending on other
options, but I should see that in the logs, I'd think.

The field is not required.

This only happens on Submit. Is it possible that with a default on a
system field that if I submit a $NULL$ value it puts the default in
place?

Any thoughts of what else I can check?

Thanks,

Dan


AR Server: 5.00.01, Patch 1156, on Solaris 5.8
Mid-Tier: 5.01.00, on Windows 2000
DB: Sybase 12.0.0.4/P
User Tool: 5.00.01
Admin Tool: 5.00.01, Patch 1159
My Desktop: Windows 2000
Solaris User: 4.05.01



You may control your subscription options, including UNSUBSCRIBE,and
ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support,
please send eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org