Fields in Act_Log tables

[Anon Anon]

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.

[JEROME MAYER]

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

[Anon Anon]

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.

[JEROME MAYER]

hum just to clarify

against what object are your trying to do??

can you send the xml that you are posting?

/J

[Anon Anon]

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>

[Anon Anon]

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

[JEROME MAYER]

glad to have help

[JEROME MAYER]

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