Loving the challenge ...
The data icon points to WflRequestTypeLog.aspx.
Within that file, the query builder states:
Private Sub OnGetData(ByVal sender As System.Object, ByVal e As System.EventArgs)
Dim ref As New RefDescriptions(env)
Dim qb As New QueryBuilder(conn)
'Build query
With qb
.AppendSelect("edl.Created, edl.Creator, h.fullname, ep.PropName, ep.Caption, ep.CaptionTermID")
.AppendSelect("ep.CaptionSuffix, ep.CaptionSuffixTermID, edl.Action, edl.OldValue, edl.NewValue, 0 As Component")
.AppendSelect("NULL AS Name, NULL AS TermID, NULL AS NameSuffix, NULL AS TermIDSuffix,edl.ID")
.AppendFrom("EbcDataLog edl")
.AppendFrom(JoinType.Inner, "EbcProps ep", "edl.Property=ep.PropID")
.AppendFrom(JoinType.LeftOuter, "Humres h", "edl.Creator=h.res_id")
.AppendWhere("edl.component", "F8065302-922D-4705-B255-26678A7BE4F8")
.AppendWhere("edl.DataKey", RequestTypeID.Value)
End With
Dim qb2 As New QueryBuilder(conn)
With qb2
.AppendSelect("edl.Created, edl.Creator, h.fullname, ep.PropName, ep.Caption, ep.CaptionTermID")
.AppendSelect("ep.CaptionSuffix, ep.CaptionSuffixTermID, edl.Action, edl.OldValue, edl.NewValue, 1 As Component")
.AppendSelect("rf.Name, rf.TermID, rf.NameSuffix, rf.TermIDSuffix,edl.ID")
.AppendFrom("EbcDataLog edl")
.AppendFrom(JoinType.Inner, "EbcProps ep", "edl.Property=ep.PropID")
.AppendFrom(JoinType.LeftOuter, "Humres h", "edl.Creator=h.res_id")
'FC22.682.724
'.AppendFrom(JoinType.Inner, "RequestFields rf", "rf.ID=SUBSTRING(edl.dataKey, " & ((RequestTypeID.Value.length) + 2) & ", LEN(edl.dataKey) - " & (Len(RequestTypeID.Value) + 1) & ")")
' BR 22.682.722
'.AppendFrom(JoinType.Inner, "RequestFields rf", "rf.ID=SUBSTRING(edl.dataKey, " & (Len(RequestTypeID.Value.ToString) + 2) & ", LEN(edl.dataKey) - " & (Len(RequestTypeID.Value.ToString) + 1) & ")")
.AppendFrom(JoinType.Inner, "RequestFields rf", "rf.ID=SUBSTRING(edl.dataKey, " & (Len(CStr(RequestTypeID.Value)) + 2) & ", LEN(edl.dataKey) - " & (Len(CStr(RequestTypeID.Value)) + 1) & ")")
.AppendWhere("edl.component", "63879F57-B4DA-4526-9E25-3FAADBBF585B")
.AppendWhere("edl.DataKey", Operators.StartsWith, RequestTypeID.Value & "-")
End With
There are a set of tables starting with 'ebc'. Those are the tables. Specifically;
EbcProps
EbcDataLog
Humres
The link to the AbsenceTypes seems to be EbcDataLog.DataKey, but I did not set up a query.
Good luck and post your final query so we dont have to go through this again! Or let us know the correct tables if you find them.
Tony