Clarity Service Management

Expand all | Collapse all

Fields in Act_Log tables

Jump to Best Answer
  • 1.  Fields in Act_Log tables

    Posted 05-19-2016 07:13 AM

    Hello everybody.

    I have a webservice connected to USD R11 that queries data.

    It works brilliant but I have 2 small problems while retrieving logs:

     

    This what I get in XML formatted:

    <regist>
    <Type>ST</Type>
    <Analyst>3B8656FD8E8A784FA73EA099CA3FD95D</Analyst>
    <TimeS>00:00:50</TimeS>
    <DateL>2016-05-11 12:36:15</DateL>
    ...
    </regist>

     

    Problems: The tag type is abbreviated and the Analyst tag just contains an ID number instead of the analyst name.

    dI know there is a certain nomenclature for calling fields, such as assignee.combo_name; status.sym; requestor.combo_name, etc...

    What would be this sort of prefix for the Act_Log and Change_Act_Log tables for the fields Type and Analyst?

     

    Thanks in advance.



  • 2.  Re: Fields in Act_Log tables

    Posted 05-19-2016 07:38 AM

    Hi,

    why do use as method to retrieve those?

    not in front of an instance to verify but if I recall properly you can simply use the dotted convention in most method to retrieve those.

    Web service use the object layer and therefore have the same nomenclature that the UI

    ie for analyst you can just do analyst.userid in your ws call

    /J



  • 3.  Re: Fields in Act_Log tables

    Posted 05-19-2016 09:11 AM

    Hello jmayer and thank you for your replies. Using the dotted convention you did post didn't work out (type.sym and analyst.userid). When I saw your example and thought "this is it!". I do not understand because the dotted convention it works well for the chgalg and alg (affected_contact.combo_name; requested_by.combo_name, etc...). Gotta see the code better I guess. Thanks anyway.



  • 4.  Re: Fields in Act_Log tables

    Posted 05-19-2016 09:16 AM

    hum just to clarify

    against what object are your trying to do??

    can you send the xml that you are posting?

    /J



  • 5.  Re: Fields in Act_Log tables

    Posted 05-19-2016 09:29 AM

    Here it is, however some text is in portuguese.

    <?xml version="1.0" encoding="utf-8" ?>

     

    -<CA xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://tempuri.org/">
    -<Pedido>
    <CriadoPor>Gonçalves, João Paulo Cerdeira</CriadoPor>
    <PedidoPor>D’aires, Isaque Gabriel Mendes Alves</PedidoPor>
    <Categoria>Software-Ciclo de Vida Aplicacional.Qualidade.WEB e Internet Banking</Categoria>
    <Estado>Resolved</Estado>

    </Pedido>

    -<Detalhe>
    <Prioridade>4 - Medium</Prioridade>
    <Atribuido>Neto, Renato Pedrosa rpn</Atribuido>
    <Grupo>SSI-Plan Sist Distrib</Grupo>
    <Sumario>CGA Backoffice - cgaLogin_ajuda</Sumario>
    <CriadoEm>2012-09-05 13:49:53</CriadoEm>
    <Resolvido>2012-09-05 14:02:39</Resolvido>
    <Descricao>CGA Backoffice</Descricao>

    </Detalhe>

    -<Log>
    -<registo>
    <Tipo>FLD</Tipo>
    <Analista>3B8656FD8E8A784FA73EA099CA3FD95D</Analista>
    <Tempo>00:00:29</Tempo>
    <Data>2015-11-23 17:13:10</Data>
    <Descricao>FIELD='description' OLD='CGA Backoffice' NEW='CGA Backoffice paragrafo '</Descricao>

    </registo>

    -<registo>
    <Tipo>FLD</Tipo>
    <Analista>3B8656FD8E8A784FA73EA099CA3FD95D</Analista>
    <Tempo>00:00:22</Tempo>
    <Data>2016-02-26 16:11:56</Data>
    <Descricao>FIELD='description' OLD='CGA Backoffice paragrafo ' NEW='CGA Backoffice'</Descricao>

    </registo>

    </Log>

    </CA>



  • 6.  Re: Fields in Act_Log tables

    Posted 05-19-2016 11:43 AM

    Forget all! The dotted convention is correct. I had my C# code wrong in dealing with the logs. Thank you very much jmayer!!!



  • 7.  Re: Fields in Act_Log tables

    Posted 05-19-2016 02:41 PM

    glad to have help



  • 8.  Re: Fields in Act_Log tables
    Best Answer

    Posted 05-19-2016 07:45 AM

    just have made a try using soapui

    the below:

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://www.ca.com/UnicenterServicePlus/ServiceDesk">

      <soapenv:Header/>

      <soapenv:Body>

          <ser:doSelect>

            <sid>************</sid>

            <objectType>alg</objectType>

            <whereClause></whereClause>

            <maxRows>1</maxRows>

            <attributes>

                <string>call_req_id.ref_num</string>

                <string>type.sym</string>

      <string>analyst.userid</string>string>

                    

            </attributes>

          </ser:doSelect>

      </soapenv:Body>

    </soapenv:Envelope>

     

     

    return:

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

      <soapenv:Body>

          <doSelectResponse xmlns="http://www.ca.com/UnicenterServicePlus/ServiceDesk">

            <doSelectReturn xmlns=""><![CDATA[<?xml version="1.0" encoding="UTF-8"?><UDSObjectList>

    <UDSObject>

    <Handle>alg:2981</Handle>

    <Attributes>

    <Attribute DataType="2002">

    <AttrName>call_req_id.ref_num</AttrName>

    <AttrValue>AM:11</AttrValue>

    </Attribute>

    <Attribute DataType="2002">

    <AttrName>type.sym</AttrName>

    <AttrValue>Initial</AttrValue>

    </Attribute>

    <Attribute DataType="2002">

    <AttrName>analyst.userid</AttrName>

    <AttrValue>System_MA_User</AttrValue>

    </Attribute>

    </Attributes>

    </UDSObject>

    </UDSObjectList>]]></doSelectReturn>

          </doSelectResponse>

      </soapenv:Body>

    </soapenv:Envelope>

     

    Hope this help

    /J