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



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,, 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?