public void processReport()
{
QueryBuildDataSource qbds,qbds1;
QueryRun qr;
Query query = new query();
try
{
ttsBegin;
qbds = query.addDataSource(tableNum(smmActivityParentLinkTable));
qbds1 = qbds.addDataSource(tablenum(smmActivities));
qbds1.addRange(fieldNum(smmActivities, Purpose)).value(strFmt('(Purpose !=0)'));
qbds1.addRange(fieldNum(smmActivities, Closed)).value(queryValue(enum2str(NoYes::Yes)));
qbds1.addRange(fieldNum(smmActivities, ActualEndDateTime)).value(queryRange('(ActualEndDateTime)'), dateMax());
qbds1.addSelectionField(fieldNum(smmActivities, ActualEndDateTime), SelectionField::Max);
qbds1.relations(true);
qr = new queryrun(query);
while (qr.next())
{
_smmActivityParentLinkTable = qr.get(tableNum(smmActivityParentLinkTable));
select _smmActivities where _smmActivities.ActivityNumber == _smmActivityParentLinkTable.ActivityNumber;
select _ProjTable where _ProjTable.RecId == _smmActivityParentLinkTable.RefRecId;
{
_PII_AllProjectReportTmp.clear();
_PII_AllProjectReportTmp.PII_ProjectName = _ProjTable.Name;
_PII_AllProjectReportTmp.PII_Time = _smmActivities.ActualEndDateTime;
_PII_AllProjectReportTmp.PII_LastActivity = _smmActivities.Purpose;
_PII_AllProjectReportTmp.PII_Issues = _smmActivities.memo_issues;
_PII_AllProjectReportTmp.PII_Summary = _smmActivities.memo_summary;
_PII_AllProjectReportTmp.PII_FollowUp = _smmActivities.memo_followup;
_PII_AllProjectReportTmp.insert();
}
Example :
|
Activity
|
Issues
|
Summary
|
FollowUp
|
ActualEndDateTime
|
|
Test1
|
Test1
|
Test1
|
Test1
|
6/10/2014
|
|
Test2
|
Test2
|
Test2
|
Test2
|
6/11/2014
|
|
Test3
|
Test3
|
Test3
|
Test3
|
6/12/2014
|
In report Now, for Field ActualEndDateTime, all data show in report.
I want just maximum date from field ActualEndDateTime in my report.
So, i just want show Test3 with maximum value from ActualEndDateTime = 6/12/2014.
Any body help me.
Please..
