PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/18/2016 2:48 PM by  Lawson_Kid
Data Field Selection
 9 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Lawson_Kid
Application Analyst
Private
Basic Member
(31 points)
Basic Member
Posts:13


Send Message:

--
01/27/2016 9:05 AM

    I am having issues trying to link data from the same table that is not offered as an available field for a certain form. How do I add additional available fields? The fields I want to add to the form are not listed.

     

    David Williams
    Private
    Private
    Veteran Member
    (3076 points)
    Veteran Member
    Posts:1036


    Send Message:

    --
    01/27/2016 9:16 AM
    You want to add the data field to the form? If so, add a textbox and then within Properties select the data source you want.
    David Williams
    Lawson_Kid
    Application Analyst
    Private
    Basic Member
    (31 points)
    Basic Member
    Posts:13


    Send Message:

    --
    01/27/2016 9:32 AM

    Thank you for the reply, the fields I want to add are not in the data source. Ex. BNB-PEND-EVIDENCE for bs31.1 is not in the data source.

    Tim Cochrane
    Private
    Private
    Veteran Member
    (450 points)
    Veteran Member
    Posts:154


    Send Message:

    --
    01/28/2016 7:54 AM
    Kid...i'll email you shortly
    Tim Cochrane - Principal LM/IPA Consultant
    Lawson_Kid
    Application Analyst
    Private
    Basic Member
    (31 points)
    Basic Member
    Posts:13


    Send Message:

    --
    01/28/2016 10:25 AM

    Thank you Tim!!!!!!!!

    mrzomp
    Programmer/Analyst
    Private
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    02/15/2016 2:27 PM

    Hello Tim,

    I had the same question.  I want to get PO20.2 and PO21.4 information to be on the Main tab of AP20.1, but don't see the fields that I want.

    Is it possible to do this? 

    Thanks in advance.

    Tim Cochrane
    Private
    Private
    Veteran Member
    (450 points)
    Veteran Member
    Posts:154


    Send Message:

    --
    02/16/2016 7:53 AM
    Yes...it would take a bit of js coding in the script tab, as you'ld need to build DMEs for the tables behind PO20.2/21.4. Parse the fields you want from the DME results and assign them to new fields you added to AP20.1 (in DS).

    Tim Cochrane - Principal LM/IPA Consultant
    David Williams
    Private
    Private
    Veteran Member
    (3076 points)
    Veteran Member
    Posts:1036


    Send Message:

    --
    02/16/2016 8:00 AM
    If there are AP forms that show the same information then you should be able to add them to your form and update the Source scripting to reference the correct key mapping. You can't present fields from a different system code on your form.
    David Williams
    mrzomp
    Programmer/Analyst
    Private
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    02/16/2016 10:58 AM

    Thank you both Tim and David.   My suspicion was that I would need to make a DME call because the system codes were different.  Being new to Design Studio, I was trying to figure out how to imbed this in the xml, but was unsure how to do it.  Would I use the API Builder to get the query I need, then copy and paste to the xml? 

    For instance, when I do a quick paint for AP20.1 it gives the DME info. for a keyselect with the index and table information in it on the source tab.

    Would I figure out the query and embed like this?   Not sure, I'm trying to find some good instruction on Design Studio, but not having much luck. 

    Thanks again.

    Lawson_Kid
    Application Analyst
    Private
    Basic Member
    (31 points)
    Basic Member
    Posts:13


    Send Message:

    --
    02/18/2016 2:48 PM

    Zomp I was in the same boat as yourself, I have very little java script experience. Your best bet is to look through the forms for someone else java script they used to make a DME call and try to tailor it to your needs. If you want any examples let me know.

    You are not authorized to post a reply.