CA Service Management

Expand all | Collapse all

Custom Field showing ID in Xtraction

David Negrey

David NegreyApr 29, 2019 08:23 AM

  • 1.  Custom Field showing ID in Xtraction

    Posted Nov 21, 2018 06:28 AM

    Hi Team

     

    I have a custom field in Request table in spooling the record from xtraction but its spooling ID and not the list.  pls see 3 snapshots below for better understanfing

     

    Pls advise

     

     

     

     

     

     

     



  • 2.  Re: Custom Field showing ID in Xtraction

    Posted Nov 21, 2018 10:30 AM

    Is the Zvendorlist, within SDM referencing a table?

    if the ID is from a table, the zvendorlist table needs to be defined to Xtraction.

    Then a join needs to be setup that maps the zvendorlist to the request table.

    this setup would be similar in Xtraction when looking up priority/analyst/affected end user



  • 3.  Re: Custom Field showing ID in Xtraction

    Posted Nov 21, 2018 10:36 AM

    hi david

     

    pls see atttached 3 snapshots... i have already joined this table on

    request table on xtractiin?.

     

    On Wed, Nov 21, 2018, 8:30 PM davidanegrey <



  • 4.  Re: Custom Field showing ID in Xtraction

    Posted Nov 21, 2018 10:51 AM

    I understand, that is great, but from your shots, something is still missing.

    Within the zvendorlist table, is the list defined?

    can you post how the zvendorlist is defined in Xtraction?

    Is there a field in zvendorlist table for the list field?



  • 5.  Re: Custom Field showing ID in Xtraction

    Posted Nov 21, 2018 11:00 AM

    Yes  the list is defined as i hided it with blue as in screenshot 3

     

    zvendorlist defined in xtraction ...u can see snapshot 2.

     

     

    Pls help to provide more information to you



  • 6.  Re: Custom Field showing ID in Xtraction

    Posted Nov 21, 2018 11:31 AM

    Ok,

    Does the zvendorlist table defined in Xtraction look like this

    The ZvendorList List, should then show up under columns...

    Does this help



  • 7.  Re: Custom Field showing ID in Xtraction

    Posted Nov 21, 2018 11:35 AM

    No David

     

    I havent done this.. How can i define this in xtraction.. pls help.



  • 8.  Re: Custom Field showing ID in Xtraction

    Posted Nov 21, 2018 11:52 AM

    try this link and see if it helps Part 10 Working with Data Sources



  • 9.  Re: Custom Field showing ID in Xtraction

    Posted Apr 11, 2019 03:52 AM

    Hi davidanegrey

     

    Can you work with me on this if raise a support issue for this?  because this is still not done and we have many custom table in sdm and we need this on xtraction for reporting.

     

    can you support for one field through webex? so i can share case number?



  • 10.  Re: Custom Field showing ID in Xtraction

    Posted Apr 11, 2019 08:36 AM

    Ok,

    have a question for you.

    Have you added a join statement, to the table that the z field is in.

    I have to check about the webex.  let me check on this..

    where are you located / time zone...



  • 11.  Re: Custom Field showing ID in Xtraction

    Posted Apr 12, 2019 12:46 AM

    Hi David

     

    yes i did

     

    im located in pakistan. GMT +5

     

    Many thanks..seeking your support.



  • 12.  Re: Custom Field showing ID in Xtraction

    Posted Apr 12, 2019 10:34 AM

    hmmm, a bit of time difference, I in eastern US, on EST.. GMT -5

    I will try to put together a guide and submit to you...

    I have done this many times...  it is just probably something little missing....

    thanks and cheers



  • 13.  Re: Custom Field showing ID in Xtraction

    Posted Apr 12, 2019 11:11 AM

    Hi David 

    many thanks for your co operation . This will help me.

     

    or if not , you can make any convenient time to look on webex , i will manage.

     

    Many Thanks.

     

    However, case already been opened but not resolved yet and the support is advising to post on community.:)



  • 14.  Re: Custom Field showing ID in Xtraction

    Posted Apr 16, 2019 09:36 AM
    From reviewing what you asked, I summarized the following.
    -- ZVENDORLIST is a custom field, which is the key to a Custom table that hold
       the sym/display name for ZVENDORLIST.
    -- From what is displayed I do not see that Table.
    -- The custom table has to be added to the Xtraction datamodel.
    -- That was the question I asked in November, did you define the ZVENDOLIST
       table in Xtraction.
    So here are some questions:
    1) REQUEST.ZVENDORLIST - is a custom field in the Request Table.
    2) Which table is the ZVENDORLIST sym/display in?
    3) Did you create a custom table to hold the values for ZVENDORLIST?
    4) What is the name of the custom table?
    5) can you supply from the ddict.sch, the Request Table (call_req) and the
       ZVENDORLIST table?
    let me known...


  • 15.  Re: Custom Field showing ID in Xtraction

    Posted Apr 22, 2019 07:55 AM

    Hi David

     

    1) REQUEST.ZVENDORLIST - is a custom field in the Request Table.

     

    Yes correct

    2) Which table is the ZVENDORLIST sym/display in?

     

     

     

     

    3) Did you create a custom table to hold the values for ZVENDORLIST?

     

    In xtraction? NO i havent defined this table in xtraction.

     

    Can you please guide on this becoz i can see how to add table but there are more tabs/option under it like FIELDS , JOIN & FILTERS...

     

     

     

     

     

     

     



  • 16.  Re: Custom Field showing ID in Xtraction
    Best Answer

    Posted Apr 24, 2019 08:29 AM
      |   view attached

    Hi,

     

    I have attached a document, that I made some time ago, that should help you in setting up what is needed in Xtraction.

    Please review and let me known.



  • 17.  Re: Custom Field showing ID in Xtraction

    Posted Apr 26, 2019 07:39 AM

    Hi David

     

    Thanks for the document and i followed what you have mentioned in the document but still its getting ID.

     

    I created Table in xtraction and add the fields in it. after that i called that field in Request table and also join the table with xutom table in xtraction. But still same issue. May be there is little might be im missing still.

     

    Can you PLEASE take a webex for this, Case # 01338109

     

    I can be available on your prefer timings. please let me know.

     

    also the i have same issue for another custom table (SREL) for agt (Analyst contact) and Location (SREL) for which im getting invalid value in xtraction record. I will be expecting you webex time.

     

    Many thanks.



  • 18.  Re: Custom Field showing ID in Xtraction

    Posted Apr 29, 2019 02:46 AM

    Hi David. im now able to resolve this issuie

     

    Many thanks



  • 19.  Re: Custom Field showing ID in Xtraction

    Posted Apr 29, 2019 08:23 AM

    Glad to hear, you got this all working....