[SOLVED] Join to a hold file twice

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/99010965

March 24, 2009, 11:30 AM

ColdWhiteMilk

[SOLVED] Join to a hold file twice

JOIN CLEAR *

JOIN
WORKLOAD.DEVELOPER
IN WORKLOAD TO ASSIGNEE.NTID
IN ASSIGNEE
AS J1
END

JOIN
WORKLOAD.PEERREVIEWER
IN WORKLOAD TO ASSIGNEE.NTID
IN ASSIGNEE
AS J2
END

How do I tell my print statement to use the data from ASSIGNEE hold file the "J2" join instead of the "J1" join for a field?

This message has been edited. Last edited by: Kerry,

Production - 7.6.4
Sandbox - 7.6.4

March 24, 2009, 11:43 AM

Tony A

cwm,

That's what the TAG syntax is for -

JOIN CLEAR *
JOIN DEVELOPER    IN WORKLOAD TAG T1 TO NTID IN ASSIGNEE TAG T2 AS J1
JOIN PEERREVIEWER IN WORKLOAD        TO NTID IN ASSIGNEE TAG T3 AS J2

You can then refer to field as T1.fieldname etc.

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

March 24, 2009, 11:53 AM

ColdWhiteMilk

Perfect! You guys ROCK!

Production - 7.6.4
Sandbox - 7.6.4

March 24, 2009, 01:03 PM

Danny-SRL

CWM,

I hope your ASSIGNEE file has an index on NTID...

In your specific case, you don't need the TAG. You can use the JOIN name as a prefix.

  
JOIN CLEAR *
JOIN DEVELOPER    IN WORKLOAD TO NTID IN ASSIGNEE TAG T2 AS D_
JOIN PEERREVIEWER IN WORKLOAD TO NTID IN ASSIGNEE TAG T3 AS P_

In your TABLE request you MUST write the fieldnames of ASSIGNEE with the the JOIN name as a prefix: D_fieldname; P_fieldname

Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF