Clarity Service Management

Expand all | Collapse all

zflied in usp_contact

Jump to Best Answer
  • 1.  zflied in usp_contact

    Posted 10-16-2017 12:01 PM

    Hi community 

     

     

    It is to my knowledge that in the cnt object there are two tables usp_contact and ca_contact

    I have created a z flied  in cnt object field but it does not appear in the usp_contact table

    I would like to know how to create the z field in usp_contact to start using it.

     

     

    If anyone knows how to help me with this I would be grateful



  • 2.  Re: zflied in usp_contact

    Posted 10-16-2017 12:16 PM

    Hi Chris,

     

    Are you using WSP to update the contact table? If so, It should automatically update the usp_contact table in the application.

     

    YOu may want to identify the difference between ca_contact and usp_contact as the usp_contact table is defined as per below definition in the base folder. i.e.

     

    OBJECT cnt {

        ATTRIBUTES usp_contact SECONDARY {

    zFields...

    .

    .

    };

    };

     

    Let me know if this helps?



  • 3.  Re: zflied in usp_contact

    Posted 10-16-2017 12:30 PM


    I am using pdm_load to update this field

     

    When i extract using pdm_extract the usp_contact table the flied z doest not appear in the .txt but this field appers in wsp



  • 4.  Re: zflied in usp_contact

    Posted 10-16-2017 12:45 PM

    if you run this command

    bop_sinfo -d cnt|findstr "zflied"

    do you see it? if yes, you can start using it.



  • 5.  Re: zflied in usp_contact

    Posted 10-16-2017 12:57 PM

    These are the screens of SQL studio , Web Screen Painter and the extract of the table usp_contact

     

    Only does not appear in SDM but i dont know why

     

    Wsp

    SQL studio

     

     

    utility pdm_extract 



  • 6.  Re: zflied in usp_contact

    Posted 10-18-2017 02:23 PM

    Can you show us a screen shot of the Schema Designer with the zKey Column Info tab exposed?



  • 7.  Re: zflied in usp_contact

    Posted 10-16-2017 01:00 PM

    i used this command but doest not work  , thaks for your help



  • 8.  Re: zflied in usp_contact

    Posted 10-16-2017 02:14 PM

    did you run this command using "zflied" or "zKey"?



  • 9.  Re: zflied in usp_contact

    Posted 10-16-2017 02:24 PM

    Using "zkey"  but still without appear in the table

     



  • 10.  Re: zflied in usp_contact

    Posted 10-18-2017 02:25 PM

    Hi Christian,

    Any time that you create a custom field on the CNT object, its going to create it on the CA_Contact Table and not the USP_Contact_Table as far as I have seen.  Is there a specific reason you want it in the usp_contact table?

    Jon I.



  • 11.  Re: zflied in usp_contact

    Posted 10-18-2017 02:44 PM

    Not necessarily, I saw that the variable was created but it was not published correctly

     

    The pdm_publish command showed the following and corrected it

     



  • 12.  Re: zflied in usp_contact

    Posted 10-18-2017 02:51 PM

    Ah ok yes - you are correct, i was thinking wrong there - its the opposite of what i said.  Any custom columns that are added to the cnt object are added to the usp_contact table and NOT the ca_contact table.  My mistake!!!

    Let us know if you are good to go on this one.

    Jon I.



  • 13.  Re: zflied in usp_contact
    Best Answer

    Posted 10-18-2017 05:19 PM

    Hi Christian, if this is still a problem for you, please open a Support case to see what happened. It should be straight with a Support webex and I simply don't like to write too much here.Thanks _Chi



  • 14.  Re: zflied in usp_contact

    Posted 10-18-2017 07:58 PM

    Christian........

     

    Please confirm that you are working with CA Support for this issue via ticket #00868473