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

Received Response
32
Views
1
Comments

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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