I'm trying to display the list of borings (list of PointID) that is shown in a fence diagram. This is same as the borings selected by the user while viewing the fence diagram. Any SQL or regular commands to this?
Thank you
-Ratna
Maybe create a site map zone encompassing the borings on your fence diagram, and using a text table output with the zone filter for your fence area?
Hi,
What commands do I type in the text table then?
Thanks,
Ratna
There is a data item. it is usually used as an part of SQL but can be used by itself in just a text entity. In the Data tool pick data items instead of functions. Or just manually type it in.
For example
Applicability:
Fences only
Description:
Returns the list of PointIDs in the fence output in the form "PointID1", "PointID2", etc.
Examples of usage:
The FencePointIDList Data Item can be used in a Text Entity.For example:
<<FencePointIDList>>
This returns the list of PointIDs in the fence output in the form "PointID1", "PointID2", etc. For example, "B-1", "B-2", "B-3".
The FencePointIDList Data Item can be used as the argument in an SQL function for an "In" clause.For example:
<<Sql(Select Max([OVA]) _ From [SAMPLE] _ Where [PointID] In (<<FencePointIDList>>)_)>>
This would return the maximum value of the SAMPLE.OVA field within PointIDs that were output on the fence.
Or Just
Answer Verified By: Ratna Yesuraj
This is what I was looking for. Thank you.
The following form worked for me;
<<Sql( _ Select Max ([SAMPLE].[OVA]) _ From [SAMPLE] _ Where [SAMPLE].[PointID] In (<<FencePointIDList>>) _)>>