Business Process Automation
View SQL Query
This page is accessed via Business Process Automation > Agents and Milestones > Milestone Templates. Click Add Milestone. Click Add From-Where Clause. Click View Query.
The SQL select statement built from the default or appended From and Where Clauses, appears at the top of the page.
These are the default From and Where Clauses:
Replication For |
Default From Clause |
Default Where Clause |
---|---|---|
Stops |
select ss.stop_num from shipment s, shipment_stop ss |
where s.shipment_gid = ss.shipment_gid |
Equipment |
select se.s_equipment_gid from shipment s, shipment_s_equipment_join se |
where s.shipment_gid = se.shipment_gid |
Order Base Line |
select obl.ob_line_gid from ob_order_base ob, ob_line obl |
where ob.order_base_gid = obl.order_base_gid |
Order Release Line |
select orl.order_release_line_gid from order_release ord, order_release_line orl |
where ord.order_release_gid = orl.order_release_gid |
- Enter an ID, if requested.
- Click Test Query to test the query.