AnsweredAssumed Answered

Custom Query On Open Fire via Smack

Question asked by sujith on Nov 24, 2015
Latest reply on Dec 27, 2016 by hongtou

Hello,

 

I need some implementation ideas for this usecase.

 

I have a smack based client and the client wants to query for some information that's available in ofmucconversationlog and ofmucroom tables in openfire.

 

To be specific , I want to do something like this:

select r.roomID, r.name, l.logTime  from ofmucroom  as r join ofmucconversationlog as l on r.roomID=l.roomID

where r.publicRoom = "1" order by logTime desc;

 

What is the easiest way to achieve this?

Outcomes