You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

FlexField Custom SQL / Tender XML

in Transportation Management 3 comments

Summary:

Hi there,

our overall goal is to print an alternate shipment stop / pickup stop in the tender message, in case the Attribute1 in the SHIPMENT Table was set. The flexfield Attribute1 is configured as a location PickList, which is working fine so far, but it returns only the location_gid in the message xml.

We tried to configure Attribute2 based on the value of Attribue1 to get the address details.

So we've created a FlexPickList with a custom sql statement, which pulls the address data from the other tables. The query is working in bipublisher. Unfortunatly the system is no accepting this in the flexfield

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!