http://in.compucrete.com/index.php?action=history&feed=atom&title=Dispatch_IssuesDispatch Issues - Revision history2026-05-15T16:10:37ZRevision history for this page on the wikiMediaWiki 1.40.0http://in.compucrete.com/index.php?title=Dispatch_Issues&diff=166&oldid=prevWikiAdmin: 1 revision imported2023-07-14T12:58:49Z<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:58, 14 July 2023</td>
</tr>
<!-- diff cache key my_wiki:diff::1.12:old-165:rev-166 -->
</table>WikiAdminhttp://in.compucrete.com/index.php?title=Dispatch_Issues&diff=165&oldid=prevIntra>User: 1 revision imported2017-01-10T00:01:37Z<p>1 revision imported</p>
<p><b>New page</b></p><div>==Trucks Disappear from Schedule Screen==<br />
<br />
If Dispatch End of Day is run without date selection, trucks that are currently out on loads will disappear from the Schedule screen. Additionally, the trucks will not appear in the Available Trucks grid.<br />
<br />
To remedy this situation, run the following query, substituting today's date where you see 6/29/07:<br />
<br />
<PRE><br />
UPDATE DITPRJLD<br />
SET STATUS_COL = 8, RETURN_DT = CURRENT_TIMESTAMP<br />
WHERE<br />
(SCHED_DATETIME BETWEEN '6/29/07 00:00' AND '6/29/07 23:59') AND<br />
(STATUS_COL <> 8) AND<br />
(RETURN_DT IS NULL) AND<br />
(NOT EXISTS<br />
(SELECT SESSION_NO FROM ARTPTKHD TK<br />
WHERE (TK.ORDER_SESSION_NO = DITPRJLD.ORDER_SESSION_NO) AND<br />
(TK.ORDER_TRANS_NO = DITPRJLD.ORDER_TRANS_NO) AND<br />
(TK.ORDER_LOAD_NO = DITPRJLD.LOAD_NO)))<br />
</PRE></div>Intra>User