Prev
Next
Forums S3 Customization/Development

How to join in DME calls

Sort:
You are not authorized to post a reply.
Author
Messages
kwisser
Basic Member
Posts: 12
Basic Member
7/30/2012 7:08 PM
    I'm trying to find out how I can do a call like:

    http://x.x.x.x/servlet/Ro...amp;FIELD=PO-NUMBER;PURCHORDER.POPCRUF.PCR-USR-FLD-01&select=PO-NUMBER=6000303&out=csv&DELIM=|&MAX=100

    I'm running into an issue with that part that says "PURCHORDER.POPCRUF.PCR-USR-FLD-01".  I figure since I can select POPCRUF from PURCHORDER, and since I can select PURCHORDER from POLINE, there must be a way for me to select POPCRUF from POLINE.  My call above doesn't generate an error, but it's always pulling in "0" for PCR-USR-FLD-01, which is incorrect.  Any help would be appreciated.

    Thanks,
    Kevin
    David Arago
    Basic Member
    Posts: 4
    Basic Member
    7/30/2012 7:36 PM
      I am on vacation until August 6th. If you need help please e-mail the helpdesk.

      Karen Sheridan
      Veteran Member
      Posts: 141
      Veteran Member
      7/30/2012 8:09 PM
        Kevin,
        DME calls use the relationships in DBDEF. I'm going to use a different example of the Employee table. If your primary table is EMPLOYEE and you would like the department name. You add to your call: Department.Name. Department is the name of the relation between the employee and deptcode tables in dbdef and Name is the field name in the deptcode table.

        Here is part of the DME call from the Employee profile ESS page:
        dmeObj.field = "process-level.name;hm-acct-unit;department.name;"
        +"location.description;supervisor.description;supervisor.full-name;employee;"

        THe fields with a name and then dot before them come from a related table. The name before the dot is not the table name but the relation name.

        If the table you are trying to access is not related to the base table in dbdef, you can't get to the data in that table without make system changes.

        The alternative is to add a 2nd DME call.

        HTH,
        Karen
        kwisser
        Basic Member
        Posts: 12
        Basic Member
        7/31/2012 1:01 PM
          I was afraid of that response, but thank you for confirming I will need another DME call.
          You are not authorized to post a reply.