jwilleke Trusted Contributor.
Trusted Contributor.
117 views

Re: Peoplesoft DIRXML_FIELDKEY, DIRXML_FIELNAME, DIRXML_VALUE

On 2012-06-07 16:26:01 +0000, kclubok said:

> I know this is an old thread, but I am interested in the same question.
> I have a bit of additional information to share, but still face some
> unknowns.
>
> Reading the PeopleSoft driver documentation, it appears that these
> fields correspond to documented parameters in the DirXMLTrans PeopleCode
> call that is used to populate the transaction table. The first two
> appear to be relevant only if the event is Row Delete. It looks like
> they help identify which row in the PeopleSoft scroll was deleted:
>
> DIRXML_FIELDKEY = Collection Row Delete Field Key: The key field value
> of the deleted data row
>
> DIRXML_FIELDNAME = Collection Row Delete Field Name: The field name of
> the scroll level attribute in the application record.
>
> The last one looks more interesting:
>
> DIRXML_VALUE = Transaction Miscellaneous Info: The parameter contains
> 1...n values that the developer wants to pass to the driver during
> processing. This value might not be available via the Schema object when
> a transaction is processed by the driver. (Example: ASSOC_ID | "|” |
> LAST_NAME)
>
> This could have a lot of benefit. It would provide a convenient way to
> include event-specific information, as opposed to CIs, which are better
> for state-based information. Unfortunately, this is where the
> documentation stops being useful. There is no explanation of how to
> access the information that is passed to the driver. I suppose it might
> be stored in an operation attribute, but that's just a guess. Does
> anybody know the answer to this?
>
>
> crisdiaz;2002153 Wrote:
>> Hello,
>>
>> Can anyone help me understand the purpose and use of the fields:
>> DIRXML_FIELDKEY, DIRXML_FIELDNAME, and DIRXML_VALUE in the PS
>> transaction table. I dont see any sort of description listed about
>> these fields in the documentation.
>>
>> Im trying to figure out if these fields, in combination with the
>> DIRXML_CURRDTTM, can be used to create a future dated transaction and
>> somehow tell the PS driver exactly which field was modified in the
>> SCHEMA CI (So it doesn't process the entire SCHEMA row).
>>
>> Thanks,
>> Cristian


Where are these documented? I have been unable to find them in the
documentation of the driver.

Why we are at it, where can we find useful the definitions for all of
the DIRXML_TRANSXX Properties:
DIRXML_ASSOC_ID
DIRXML_CURRDTTM
DIRXML_DESCR
DIRXML_DRIVER
DIRXML_DTTM
DIRXML_EVENT
DIRXML_FIELDKEY
DIRXML_FIELDNAME
DIRXML_INST
DIRXML_PROCESSED
DIRXML_SCHEMA
DIRXML_STATUS
DIRXML_VALUE

--

Thank You for your help!

-jim
Jim Willeke

Labels (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.