Passing a parameter from parent query in a report

I have two datasources in a report:

1. OPEN ORDER: select uid_personwantsorg from PersonWantsOrg where OrderState = 'OrderProduct'

2. POSSIBLE CONFIRMATORS: select r.UID_PersonHead from dbo.QER_FTPwoNextDecisionMaker( @OrderState.uid_personwantsorg ) r

How to force the second view (POSSIBLE CONFIRMATORS) to produce the detail for every OPEN ORDER (...like a detail pane).

@OrderState.uid_personwantsorg is not working in this form (tried it with setting OPEN ORDER as parent query)

I can not use relation as I call a function.

Top Replies

Markus Weiss-Ehlers over 2 years ago +2

Just use the following SQL in your second Query as the combination of both queries.

select PersonWantsOrg.UID_PersonWantsOrg, r.UID_PersonHead
from PersonWantsOrg 
Cross Apply dbo.QER_FTPwoNextDecisionMaker…

Markus Weiss-Ehlers over 2 years ago in reply to mekindad +1 verified
In your query, you should just need to add the following condition (If I understood the question correctly.)
```
PersonWantsOrg.DecisionLevel = r.LevelNumber
```

Parents

0 Markus Weiss-Ehlers over 2 years ago

Just use the following SQL in your second Query as the combination of both queries.

select PersonWantsOrg.UID_PersonWantsOrg, r.UID_PersonHead
from PersonWantsOrg 
Cross Apply dbo.QER_FTPwoNextDecisionMaker( PersonWantsOrg.uid_personwantsorg ) r
where OrderState  = 'OrderProduct'

Reply

0 Markus Weiss-Ehlers over 2 years ago

Just use the following SQL in your second Query as the combination of both queries.

select PersonWantsOrg.UID_PersonWantsOrg, r.UID_PersonHead
from PersonWantsOrg 
Cross Apply dbo.QER_FTPwoNextDecisionMaker( PersonWantsOrg.uid_personwantsorg ) r
where OrderState  = 'OrderProduct'

Children

0 mekindad over 2 years ago in reply to Markus Weiss-Ehlers

How to distinguish between all possible approvers and the ones that need to approve in the current step?
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
+1 Markus Weiss-Ehlers over 2 years ago in reply to mekindad
In your query, you should just need to add the following condition (If I understood the question correctly.)

PersonWantsOrg.DecisionLevel = r.LevelNumber
Cancel
Up +1 Down

Reply

Verify Answer

Reject Answer

Cancel
0 mekindad over 2 years ago in reply to Markus Weiss-Ehlers

Yes... or adding condition r.RulerLevel = 0 also does the job. Thank You!
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Markus Weiss-Ehlers over 2 years ago in reply to mekindad

Depending on your exact question is RulerLevel=0 not the same. RulerLevel = Type of approver (0=Normal approver, 1=Fallback approver, 2=Chief approval team)
Cancel
Up 0 Down

Reply

Verify Answer

Cancel