topic Re: JavaScript Viewer - how to define the fields the wmJobTask brings back in ArcGIS Workflow Manager Questions https://community.esri.com/t5/arcgis-workflow-manager-questions/javascript-viewer-how-to-define-the-fields-the/m-p/104530#M200 <HTML><HEAD></HEAD><BODY><P>We found that the All Open Jobs general query was returning the Job ID twice. So in order to fix this I went into Workflow Manager Administrator and modified the SQL Query behind the All open jobs query. What I did was remove the WMX.JTX_JOBS.JOB_ID from the select query. Now the correct fields seem to be populating the correct locations in the table.&nbsp; See below for my final syntax. </P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/82666_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Alison</P></BODY></HTML> Tue, 07 Apr 2015 18:59:41 GMT AlisonGaiser1 2015-04-07T18:59:41Z JavaScript Viewer - how to define the fields the wmJobTask brings back https://community.esri.com/t5/arcgis-workflow-manager-questions/javascript-viewer-how-to-define-the-fields-the/m-p/104529#M199 <HTML><HEAD></HEAD><BODY><P>We are using the lastest version of the Workflow Manager JavaScript viewer with our recently migrated 10.2.2 WMX database. </P><P></P><P>Unfortunately, we have noticed that the order of the fields presented in the table at the bottom are not lining up with the with the results set. </P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/81317_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>As you can see in this picture, the Assigned To field is showing the Job Name field. </P><P></P><P>I then noticed that the Job_Name field was toggled off in the viewer. </P><P><IMG class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/81318_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P>When I toggle this on, nothing happens. If I proceed to toggle off the Assigned To field, I see the field disappear from the viewer. </P><P></P><P>We think that the root of the problem is caused by the fact that when our app performs its wmJobTask.searchJobs task (WorkflowManager.js, line 938), the server returns 6 Field Names, the first two of which are the same “<SPAN style="font-size: 9.0pt; font-family: Consolas; color: #222222; background: white;">"WMX.JTX_JOBS.JOB_ID"</SPAN>“ field, for some reason. I can see the same thing if I query the end point of the service.</P><P><IMG class="image-3 jive-image" src="https://community.esri.com/legacyfs/online/81319_pastedImage_4.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>The duplication is what throws off the whole grid, it seems.</P><P></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">My question is how we define the fields that the wmJobTask brings back from the server; It seems like these are set server-side. Or could there be something wrong with our database after our upgrade?</SPAN></P><P></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">Thanks,</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">&nbsp;&nbsp;&nbsp;&nbsp; Alison</SPAN></P></BODY></HTML> Thu, 02 Apr 2015 18:16:55 GMT https://community.esri.com/t5/arcgis-workflow-manager-questions/javascript-viewer-how-to-define-the-fields-the/m-p/104529#M199 AlisonGaiser1 2015-04-02T18:16:55Z Re: JavaScript Viewer - how to define the fields the wmJobTask brings back https://community.esri.com/t5/arcgis-workflow-manager-questions/javascript-viewer-how-to-define-the-fields-the/m-p/104530#M200 <HTML><HEAD></HEAD><BODY><P>We found that the All Open Jobs general query was returning the Job ID twice. So in order to fix this I went into Workflow Manager Administrator and modified the SQL Query behind the All open jobs query. What I did was remove the WMX.JTX_JOBS.JOB_ID from the select query. Now the correct fields seem to be populating the correct locations in the table.&nbsp; See below for my final syntax. </P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/82666_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Alison</P></BODY></HTML> Tue, 07 Apr 2015 18:59:41 GMT https://community.esri.com/t5/arcgis-workflow-manager-questions/javascript-viewer-how-to-define-the-fields-the/m-p/104530#M200 AlisonGaiser1 2015-04-07T18:59:41Z