Info from Method Of Manufacturing

Even without change logging set up (which is lost if the table record the log entry stems from is deleted), you can look at method changes over time by querying the ECO* tables (ECOmtl).

These are the same tables you'd be writing to with DMT and they record every final state of records changed using Engineering Workbench.

Rob Brown
Versa Products 


On Tue, Jul 12, 2016 at 3:10 PM, Kimberley White faepigrl@... [vantage]
<vantage@yahoogroups.com> wrote:
 
<div id="ygrps-yiv-22598623ygrp-text">
  
  
  <p></p><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div><span>Thanks I didn&#39;t think about that. &nbsp;Will that work even if no Job set up?</span></div> <div class="ygrps-yiv-22598623qtdSeparateBR"><br clear="none"><br clear="none"></div><div class="ygrps-yiv-22598623yQTDBase ygrps-yiv-22598623yqt1082662721" id="ygrps-yiv-22598623yqt84538"><div class="ygrps-yiv-22598623yahoo_quoted"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"><font size="2" face="Arial"> On Tuesday, July 12, 2016 2:16 PM, &quot;Jose Gomez jose@... [vantage]&quot; &lt;vantage@yahoogroups.com&gt; wrote:<br clear="none"></font></div>  <br clear="none"><br clear="none"> <div class="ygrps-yiv-22598623y_msg_container"><div id="ygrps-yiv-22598623yiv8772425163"><div>

 

<div id="ygrps-yiv-22598623yiv8772425163ygrp-text">
  
  
  <div></div><div dir="ltr"><div class="ygrps-yiv-22598623yiv8772425163gmail_default" style="font-family:verdana, sans-serif;font-size:small;">If you have ChangeTracking on the JobMtl table... it will be in the change log (maybe)</div></div><div class="ygrps-yiv-22598623yiv8772425163gmail_extra"><br clear="all"><div><div class="ygrps-yiv-22598623yiv8772425163gmail_signature"><div dir="ltr"><div><font face="verdana, sans-serif"><br clear="none"><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br clear="none"><br clear="none"></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br clear="none"></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice">904.469.1524</span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" shape="rect">jose@...</a></font><font size="1" face="verdana, sans-serif"><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/"><font color="#FF6600">http://www.josecgomez.com</font></a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img></a>&nbsp;</font><a rel="nofollow" shape="rect" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.twitter.com/joc85"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img></a>&nbsp;<span style="font-family:verdana, sans-serif;"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/feed/"><img></a>&nbsp;</span></div><div><span lang="LA" style="color:black;"><br clear="none"><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?



On Tue, Jul 12, 2016 at 2:02 PM, Kimberley White faepigrl@… [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <div></div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div dir="ltr">Is there a way to see who added material to a Method of Manufacturing?&nbsp; Is it stored in a table somewhere?</div><div dir="ltr"><br clear="none"></div><div dir="ltr">Thanks Kim</div></div><div></div>

</div>
 


<div style="color:#fff;min-height:0;"></div>

</div>
 


<div class="ygrps-yiv-22598623yiv8772425163yqt6803351773" id="ygrps-yiv-22598623yiv8772425163yqt56381"><div style="color:#fff;min-height:0;"></div></div>


</div>
 


<div class="ygrps-yiv-22598623yQTDBase ygrps-yiv-22598623yqt1082662721" id="ygrps-yiv-22598623yqt75768"><div style="color:#fff;min-height:0;"></div></div>
Is there a way to see who added material to a Method of Manufacturing?  Is it stored in a table somewhere?

Thanks Kim
If you have ChangeTracking on the JobMtl table... it will be in the change log (maybe)


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Tue, Jul 12, 2016 at 2:02 PM, Kimberley White faepigrl@... [vantage] <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p></p><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div dir="ltr">Is there a way to see who added material to a Method of Manufacturing?  Is it stored in a table somewhere?</div><div dir="ltr"><br></div><div dir="ltr">Thanks Kim</div></div><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

Thanks I didn't think about that.  Will that work even if no Job set up?


On Tuesday, July 12, 2016 2:16 PM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:


 
<div id="ygrps-yiv-989242457yiv8772425163ygrp-text">
  
  
  <div></div><div dir="ltr"><div class="ygrps-yiv-989242457yiv8772425163gmail_default" style="font-family:verdana, sans-serif;font-size:small;">If you have ChangeTracking on the JobMtl table... it will be in the change log (maybe)</div></div><div class="ygrps-yiv-989242457yiv8772425163gmail_extra"><br clear="all"><div><div class="ygrps-yiv-989242457yiv8772425163gmail_signature"><div dir="ltr"><div><font face="verdana, sans-serif"><br clear="none"><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br clear="none"><br clear="none"></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br clear="none"></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice">904.469.1524</span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a></font><font size="1" face="verdana, sans-serif"><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/"><font color="#FF6600">http://www.josecgomez.com</font></a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img></a>&nbsp;</font><a rel="nofollow" shape="rect" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.twitter.com/joc85"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img></a>&nbsp;<span style="font-family:verdana, sans-serif;"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/feed/"><img></a>&nbsp;</span></div><div><span lang="LA" style="color:black;"><br clear="none"><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?


On Tue, Jul 12, 2016 at 2:02 PM, Kimberley White faepigrl@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <div></div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div dir="ltr">Is there a way to see who added material to a Method of Manufacturing?&nbsp; Is it stored in a table somewhere?</div><div dir="ltr"><br clear="none"></div><div dir="ltr">Thanks Kim</div></div><div></div>

</div>
 


<div style="color:#fff;min-height:0;"></div>

</div>
 


<div class="ygrps-yiv-989242457yiv8772425163yqt6803351773" id="ygrps-yiv-989242457yiv8772425163yqt56381"><div style="color:#fff;min-height:0;"></div></div>
#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163 -- #ygrps-yiv-989242457yiv8772425163ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-mkp #ygrps-yiv-989242457yiv8772425163hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-mkp #ygrps-yiv-989242457yiv8772425163ads {
margin-bottom:10px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-mkp .ygrps-yiv-989242457yiv8772425163ad {
padding:0 0;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-mkp .ygrps-yiv-989242457yiv8772425163ad p {
margin:0;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-mkp .ygrps-yiv-989242457yiv8772425163ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-sponsor #ygrps-yiv-989242457yiv8772425163ygrp-lc {
font-family:Arial;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-sponsor #ygrps-yiv-989242457yiv8772425163ygrp-lc #ygrps-yiv-989242457yiv8772425163hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-sponsor #ygrps-yiv-989242457yiv8772425163ygrp-lc .ygrps-yiv-989242457yiv8772425163ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163activity span {
font-weight:700;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163activity span span {
color:#ff7900;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163activity span .ygrps-yiv-989242457yiv8772425163underline {
text-decoration:underline;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 .ygrps-yiv-989242457yiv8772425163attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 .ygrps-yiv-989242457yiv8772425163attach div a {
text-decoration:none;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 .ygrps-yiv-989242457yiv8772425163attach img {
border:none;padding-right:5px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 .ygrps-yiv-989242457yiv8772425163attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 .ygrps-yiv-989242457yiv8772425163attach label a {
text-decoration:none;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 .ygrps-yiv-989242457yiv8772425163bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 .ygrps-yiv-989242457yiv8772425163bold a {
text-decoration:none;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 dd.ygrps-yiv-989242457yiv8772425163last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 dd.ygrps-yiv-989242457yiv8772425163last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 dd.ygrps-yiv-989242457yiv8772425163last p span.ygrps-yiv-989242457yiv8772425163yshortcuts {
margin-right:0;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 div.ygrps-yiv-989242457yiv8772425163attach-table div div a {
text-decoration:none;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 div.ygrps-yiv-989242457yiv8772425163attach-table {
width:400px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 div.ygrps-yiv-989242457yiv8772425163file-title a, #ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 div.ygrps-yiv-989242457yiv8772425163file-title a:active, #ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 div.ygrps-yiv-989242457yiv8772425163file-title a:hover, #ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 div.ygrps-yiv-989242457yiv8772425163file-title a:visited {
text-decoration:none;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 div.ygrps-yiv-989242457yiv8772425163photo-title a, #ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 div.ygrps-yiv-989242457yiv8772425163photo-title a:active, #ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 div.ygrps-yiv-989242457yiv8772425163photo-title a:hover, #ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 div.ygrps-yiv-989242457yiv8772425163photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 div#ygrps-yiv-989242457yiv8772425163ygrp-mlmsg #ygrps-yiv-989242457yiv8772425163ygrp-msg p a span.ygrps-yiv-989242457yiv8772425163yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 .ygrps-yiv-989242457yiv8772425163green {
color:#628c2a;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 .ygrps-yiv-989242457yiv8772425163MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 o {
font-size:0;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163photos div {
float:left;width:72px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163photos div div {
border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163reco-category {
font-size:77%;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163reco-desc {
font-size:77%;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 .ygrps-yiv-989242457yiv8772425163replbq {
margin:4px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-mlmsg select, #ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 input, #ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-mlmsg pre, #ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 code {
font:115% monospace;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-mlmsg #ygrps-yiv-989242457yiv8772425163logo {
padding-bottom:10px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-msg p#ygrps-yiv-989242457yiv8772425163attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-reco #ygrps-yiv-989242457yiv8772425163reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-sponsor #ygrps-yiv-989242457yiv8772425163ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-sponsor #ygrps-yiv-989242457yiv8772425163ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-sponsor #ygrps-yiv-989242457yiv8772425163ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-text {
font-family:Georgia;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-text tt {
font-size:120%;}

#ygrps-yiv-989242457 #ygrps-yiv-989242457yiv8772425163 #ygrps-yiv-989242457yiv8772425163ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-989242457