Hi folks
I am running a SQL report to take a dump of collections in CM:
SELECT Collections_G.CollectionID,
Collections_G.SiteID, Collections_G.LimitToCollectionID,
Collections_G.CollectionName,
Collections_G.ResultTableName,
Collections_G.CollectionComment,
Collection_Rules_SQL.SQL, Collections_G.Schedule, Collections_G.LastChangeTime,
Collections_G.SourceLocaleID,
Collections_G.LastRefreshRequest,
Collections_G.CollectionType, Collections_G.ISVData, Collections_G.rowversion,
Collections_G.Flags, Collections_L.BeginDate,
Collections_L.EvaluationStartTime,
Collections_L.LastRefreshTime, Collections_L.LastIncrementalRefreshTime,
Collections_L.LastMemberChangeTime,
Collections_L.CurrentStatus,
Collections_L.CurrentStatusTime, Collections_L.MemberChanges,
Collections_L.EvaluationLength,
Collections_L.IncrementalEvaluationStartTime,
Collections_L.IncrementalMemberChanges,
Collections_L.IncrementalEvaluationLength,
Collections_L.EvaluationGQStatus
FROM Collections_G INNER
JOIN
Collections_L ON Collections_G.CollectionID = Collections_L.CollectionID INNER
JOIN
Collection_Rules_SQL ON Collections_G.CollectionID =
Collection_Rules_SQL.CollectionID
Order by Collections_L.EvaluationLength desc
The output is great but the collection evaluation schedule is encoded. What's
the formula for getting this back into human-readable format please?
Jason
