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

Multiple pass-through values in a saved query

in Global Trade Management 1 comment

Summary:

I have a saved query defined that utilizes the '?' in 3 different places in the query. The saved query is being used in an 'associated detail' table in a workbench relative to a shipment. The workbench currently returns no results, however when you plug in a given shipment to each of the '?' and run the SQL manually in the SQL tool, results are returned. Are multiple pass-through values allowed?

The intent of the SQL is to return planned shipments that have a starting source location zip2 of the selected shipments' destination zip2 (where the destination is the last stop of the shipment that's not an NFR stop)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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