× Discuss on T24 Installation, Setting up the environment, TC Server, jBOSS, Package & Deployment, etc…

Enquiry Joins

Start
Prev
1
Next
End

mrul3s
Topic Author
Visitor

9 years 11 months ago #16660 by mrul3s

Enquiry Joins was created by mrul3s

how we apply Joins functionality between two different enquires fields and make new enquiry.
Example,
i have two enquires
1. Single.order
2.Order.Interface
My Requirement is Single.order ID field = Order.Interface ID WHERE order.interface.status is Equal to Done

Please Log in or Create an account to join the conversation.

jpb
Offline
Moderator
retired

9 years 11 months ago #16661 by jpb

Replied by jpb on topic Enquiry Joins

I'm not sure I fully understand your requirement, but I suppose defining an I-desc for Single.order that inherits the order.interface.status will do the job if used for selection.

e.g.
USR.FIELD.NAME - INTERF.STATUS
USR.TYPE - I
USR.FIELD.NO - @ID;SUBR('ENQ.TRANS','ORDER.INTERFACE',@1,'STATUS')
...
alternatively use a J-desc with e.g.
USR.FIELD.NO - @ID>ORDER.INTERFACE>STATUS

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Time to create page: 0.077 seconds