Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

Trying to create DME query that returns blank and/or constants

 1 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages


David Britton











Veteran Member



Posts: 53




Veteran Member



3/16/2012 7:27 PM
    I am trying to build a DME query that will return a variety of fields from the EMPLOYEE and PAEMPLOYEE tables, but I need to include a number of either Constant fields (such as "P") or blank fields. For the blank fields I could try to find a table field that is always blank that that seems kind of tacky and dangerous. Any suggestions. I tried just including constants in both single quotes and double quotes in the DME string but always got an error.

    The record format is:

    'P'
    ,' '
    , 'City of High Point'
    ,EMPLOYEE.FIRST_NAME
    ,EMPLOYEE.LAST_NAME
    ,EMPLOYEE.MIDDLE_INIT
    ,PAEMPLOYEE.SEX GENDER
    ,PAEMPLOYEE.BIRTHDATE
    ,EMPLOYEE.DATE_HIRED
    ,EMPLOYEE.ADDR1
    ,EMPLOYEE.ADDR2
    ,EMPLOYEE.ADDR3
    ,EMPLOYEE.CITY
    ,EMPLOYEE.STATE
    ,EMPLOYEE.ZIP
    , PAEMPLOYEE.HM_PHONE_NBR
    ,PAEMPLOYEE.WK_PHONE_NBR
    ,EMPLOYEE.EMAIL_ADDRESS EMAIL
    ,EMPLOYEE.EMP_STATUS
    ,' '
    ,EMPLOYEE.DEPARTMENT
    , ' '
    , ' '
    ,' ' 
    ,' ' 
    ,' ' 
    ,' ' 
    , ' ' 
    , EMPLOYEE.EMPLOYEE
    ,' '
    ,' '
    ,' '
    ,' '
    ,'E'


    Robert Spurr











    Veteran Member



    Posts: 130




    Veteran Member



    3/19/2012 7:20 PM
      I will assume that this is a design studio project if not this approach could also work, however the example wouldn't be on point. The best approach is to account for all the fields you want and replace them after the return. I've attached an example where I'm replacing the work unit status with an actual name. You can also re-title the columns.

      function workunit1_OnLoadComplete()
      {


      var objDme = page.objects["workunit1"];
      var fieldName = "WORK-TITLE";
      var fieldName2 = "KEY-STRING";
      var fieldName3 = "WFVARIABLE.VARIABLE-VALUE";
      var fieldName4 = "WF-STATUS";

      //objDme.fields[1].heading = "test";
      for (var i=0;i<5;i++)
      {
      if(null != objDme.getValue(fieldName,i))
      {

      objDme.setValue(fieldName, i, objDme.getValue(fieldName2,i).substring(0,4) + " - " + objDme.getValue(fieldName2,i).substring(4) + " - " + objDme.getValue(fieldName3,i));
      }

      if(null != objDme.getValue(fieldName4,i))
      {
      if (objDme.getValue(fieldName4,i) == 4 || objDme.getValue(fieldName4,i) == 8)
      {
      objDme.setValue(fieldName4, i, "Completed");
      }
      else if (objDme.getValue(fieldName4, i) == 1)
      {
      objDme.setValue(fieldName4, i, "Pending");
      }
      else if (objDme.getValue(fieldName4, i) == 2)
      {
      objDme.setValue(fieldName4, i, "Open");
      }
      else
      {
      objDme.setValue(fieldName4, i, "Error");
      }
      }

      }
      }