PROBLEM:
We are using scheduling.
The reports that come with Visual worked ok, but I wanted more.
I wanted a report that would show the WO schedule in chronological order.
I had to build a view so that Synoptix would report this.
When I built the view I found Synoptix was changing the date time of the schedule to either a date or a time.
Since I wanted to sort on a "date time" inside Synoptix this gave me a problem to solve.
SOLUTION:
The solution was to convert the date IN the view, then use that as the sort in Synoptix.
Using the SYSADM account, I edited the view I had created and added the convert.
I used the new field as the sort.
SELECT a.WORKORDER_BASE_ID AS WO, a.SCHED_START_DATE AS SCHED_START, CONVERT(char(19), a.SCHED_START_DATE, 100) AS SCHED_START_DTTM,
a.RESOURCE_ID AS RESOURCE, c.BITS AS DESCR, a.WORKORDER_LOT_ID AS WO_LOT_ID, a.WORKORDER_SPLIT_ID AS WO_SPLIT_ID,
a.WORKORDER_SUB_ID AS WO_SUB_ID, a.SEQUENCE_NO AS SEQ_NO, a.RUN AS RUN_HOURS
FROM dbo.OPERATION AS a INNER JOIN
dbo.OPERATION_SCHED AS b ON a.WORKORDER_BASE_ID = b.WORKORDER_BASE_ID AND a.WORKORDER_LOT_ID = b.WORKORDER_LOT_ID AND
a.WORKORDER_SPLIT_ID = b.WORKORDER_SPLIT_ID AND a.WORKORDER_SUB_ID = b.WORKORDER_SUB_ID AND
a.SEQUENCE_NO = b.SEQUENCE_NO INNER JOIN
dbo.OPERATION_BINARY AS c ON a.WORKORDER_BASE_ID = c.WORKORDER_BASE_ID AND a.WORKORDER_LOT_ID = c.WORKORDER_LOT_ID AND
a.WORKORDER_SPLIT_ID = c.WORKORDER_SPLIT_ID AND a.WORKORDER_SUB_ID = c.WORKORDER_SUB_ID AND a.SEQUENCE_NO = c.SEQUENCE_NO AND
b.SCHEDULE_ID = 'STANDARD'
