Querying Chat History


Note: Replace dbsecret in the examples below with the appropriate database secret.

Query complete chat history (warning: this might be slow if you have more than 1000 chats):

<queryDatabase secret="dbsecret">

Query with limited time range (using XML Schema dateTime):

<queryDatabase secret="dbsecret">
<islProntoChat fromCreatedDateTime="2008-01-01T00:00:00Z" toCreatedDateTime="2008-12-01T00:00:00Z"/>

Query with limited time range (using UNIX epoch time):

<queryDatabase secret="dbsecret">
<islProntoChat fromCreatedTime="1206303063" toCreatedTime="2000000000"/>

Query with limited time range and specific domain:

<queryDatabase secret="dbsecret">
<islProntoChat domain="default" fromCreatedDateTime="2008-01-01T00:00:00Z" toCreatedDateTime="2008-12-01T00:00:00Z"/>

Query with specific httpSid (unique id):

<queryDatabase secret="dbsecret">
<islProntoChat httpSid="1a310bb2dec83657edd173a9fda07ed58f2c1b4ae9df9ea0e98412f9ff4a58e520010181"/>

Chat information

<browser> <!-- client's web browser -->

<chat> <!-- chat messages -->
<line id="unique line id" timestamp="UNIX epoch" dateTime="XML schema datetime" nick="..." email="..." supporter="1 if supporter" action="1 if action message">text</line>

<messages> <!-- custom messages -->
<message id="unique message id" timestamp="UNIX epoch" dateTime="XML schema datetime" type="origin of message">
<data name="key name">key data</data>

<city> <!-- geo location: city -->
<country> <!-- geo location: country -->
<countryCode> <!-- geo location: country code -->
<createdTime> <!-- created time in UNIX epoch format -->
<createdTimeDateTime> <!-- created time in XML schema dateTime format -->
<customFields> <!-- custom fields (integration) -->
<domain> <!-- domain name -->
<email> <!-- client's email -->
<httpSid> <!-- unique id -->
<ip>, <internalIp> <!-- client's IP and internal IP -->
<isClient> <!-- 1 if this is chat with client, empty is this is supporter to supporter chat -->
<lang> <!-- language -->
<location> <!-- URL where client started chat -->
<nick> <!-- client's nickname -->
<referrer> <!-- referrer URL of client's location -->
<supporterNick> <!-- supporter's nickname -->

Was this article helpful?