319
edits
Changes
→Step 4 – Define Report Query for Subreport
{| class="wikitable"
| align="center" style="background:#f0f0f0;"|'''Main Report'''
| align="center" style="background:#f0f0f0;"|'''Subreport can be'''
| align="center" style="background:#f0f0f0;"|'''Value to Pass to Subreport'''
| align="center" style="background:#f0f0f0;"|'''Report Query'''
|-
|-
| Location Any linked item|| Any linked Item with a Location|| location Item guid (e.g. Land guid )|| locationlinks.guid toGuid= "$P{ItemGUID}" || Example
|-
| Land, Activity||Impact survey, Accident, Victim, Assistance, Education, QMInterviewee, Location or Vegetation removal|| Any linked Item Activity guid|| Item ''guid'' (e.ghazreduc. Land guid) || links.toGuid="$P{ItemGUID}" || Example
|-
|Activity Interviewee|| Impact survey, Interviewee, or Vegetation removal Question|| Activity ''interviewee guid'' || hazreducinterviewee.guid = "“$P{ItemGUID}" || Relationship is defined as “New” to an activity during the reconciliation.”
|-
| Interviewee Task|| Question Work Item|| interviewee ''Task guid'' || intervieweetask.guid = “"$P{ItemGUID}” || Relationship persisted automatically when Questions are entered for each Interviewee at Data Entry Form."
|-
| Task Any Item with Geospatial information|| Work Item GeospatialInfo|| Task ''guid'' geoSpatialInfos|| task.guid = "IN $P{ItemGUIDGeospatialInfoList}" || Relationship is defined when adding a new Work Item to a Task at the Task Editor Window.
|-
| Example Geospatial Info|| Example GeoPoint|| Example GeospatialInfo guid|| Example geospatialInfoGuid = "$P{ItemGUID}"|-| Any item with devices||Item Device (e.g. AccidentDevice)||Item guid (e.g. Accident guid)||accident.guid = "$P{ItemGUID}" hazard.guid = "$P{ItemGUID}"|-| MRE||MREDetail||MRE guid||mre.guid = "$P{ItemGUID}"|-| Victim||Victim Needs Assessment||victim guid||victim.guid="$P{ItemGUID}"|-| Victim||Victim Cause||victim guid||victim.guid="$P{ItemGUID}"|-| Victim Assistance||Victim Assistance Assistance||victimAssistance.guid||victimAssistance.guid="$P{ItemGUID}"|-| Task||Objective||SQL Field list of Objectives||guid IN ($P{SQLList})|-| Work Item||Linked Items (Activity, Education, QM, Victim Assistance)||SQL Field list of Items||guid IN ($P{SQLList})|-| Example
|}
