Blog_AcuAudit

gistfile1.txt

public static List<AuditHistory> FindScreenRecordsTriggeredbyDateFrom(PXGraph graph)
{
    var distinctScreenID = "AR303000";
           
    // change date as needed - here for debugging only
    DateTime? lastDateTimeFromParameter = Convert.ToDateTime("05/15/2022 17:00:00");

    var historyRecords = SelectFrom<AuditHistory>
        .Where<AuditHistory.changeDate.IsGreater<@P.AsDateTime>
        .And<AuditHistory.screenID.IsEqual<@P.AsString>>>
        .OrderBy<AuditHistory.changeDate.Desc>
        .View.Select(graph, lastDateTimeFromParameter, distinctScreenID).RowCast<AuditHistory>().ToList();

    return historyRecords;
}

init for blog