Sorry, I meant "Show Relationships". You right-click a field in
Developer Studio and choose this from the menu. This feature is only
available on newer AR System versions-- and you have to enable it in the
server configuration: "record object relationships". It makes it much
easier to track down things that maybe be setting or pushing to that
field (assuming it is something within AR System!).
That said, the AL and Filter logging should be good enough to catch this
thing; I'd dig into the SQL logs as a last resort.
Brien
On 10/11/2010 12:12 PM, Christine wrote:
Brien,
Thank you for your reply and for taking the time to test this. Can you
explain the 'get relationship'? I cannot find a reference to this in
either the Form/Apps manual or the Workflow manual.
I'm doing another log, including a SQL log. I use SQL Navigator to
look at the table more directly. If you know of a better tool I'm open
to suggestions.
Thanks,
Christine
On Oct 7, 6:18 pm, Brien Dieterle
<[email protected]> wrote:
I don't think that is it. In fact I just made a test form exactly as
you described and it works fine. I am betting you have some other
workflow manipulating that field. Can you do a "get relationships" on
those fields and check for any set fields and push fields operations
from other workflow, particularly on the TempReqSummary field? You
could also just try adding the "`!" to the end of the filter name just
for giggles to see if that works, and/or cranking up the execution order.
Brien
On 10/7/2010 4:12 PM, Christine wrote:
Brien,
The default value of the field TempReqSummary is #First Name# as
defined on the form, in the Field Attributes Default Value.
When entering the information on the form, I enter the name Denise in
the field First Name. Upon submission the Replace function is changing
the TempReqSummary value to the value in the First Name field (in this
case, Denise). This is as I want it. I see this happen in the log.
When the record is saved, the saved value is back to #First Name#. Is
the Default Value overwriting the Set Fields Replace() function?
Thank you for your help,
Christine
On Oct 7, 3:23 pm, Brien Dieterle
<[email protected]> wrote:
Is there a Set Fields operation that is setting $TempReqSummary$ to
"#First Name#", or is "#First Name#" the default value or the value you
are entering into the field manually?
Brien
On 10/7/2010 1:25 PM, Christine wrote:
I’m using the Replace() function in a filter Set Fields action. I can
see in the logs where the Replace() is successful during filter phase
I processing. However, when the record is saved the original value of
the field (not the Set Fields value) is still present.
Original Field Value: #First Name#;
Filter Set Fields action: REPLACE($TempReqSummary$, "#First Name#",
$First Name$)
The result in the log is the first name in the field TempReqSummary.
Entry from the log is: “TempReqSummary (536871236) = Denise;”
When the record is finally written to the db the TempReqSummary has
the value of #First Name#, not ‘Denise’ as I am trying to achieve. I
see nothing else in the log where this value is getting overwritten.
I’m logging both ACTL and Filters. In the log when this filter is
complete there is the message “End of filter processing (phase 1) –
Operation Create on (form name) -<NULL> “
I’ve been looking at the filter processing for the email message
creation which uses this type of Replace() action. I’ve logged that
process but I can’t see what actually ‘seeds’ the value in the target
field. There is no ‘commit changes’ in filter processing as in ACTL.
I’ve read and re-read the Workflow manual about filter phasing but I
am obviously missing the fix for this.
Can anyone direct me to what I should read/understand next in order to
get this working?
This may be a very simple replace function, but it is a test of
something larger that will aggregate values of multiple fields into
one text field with other wording and formatting.
Thanks,
Christine
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug10www.wwrug.comARSlist:"Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug10www.wwrug.comARSlist:"Where the Answers Are"- Hide quoted text -
- Show quoted text -
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"- Hide quoted text -
- Show quoted text -
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
