SOAP RoomService getRooms

[GoogleCodeExporter]

Which version of OpenMeetings are you running?
1.8.4

What's your operating system on client and server side?
Server-Debian, Client-Fedora

Is it a problem related to the client/usability or server-side?
Server

Did you have any trace/debug output?

My PHP SOURCE:
######################################
$params=array('SID'=>$this->session_id,'start'=>0,'max'=>1000,'orderby'=>'name',
'asc'=>true);
$listRooms=$this->roomClient->call('getRooms',$params);
print_r($listRooms);
######################################

RESULT:
Array
(
[faultcode] => soapenv:Server
[faultstring] => Failed to execute query "select c from Rooms c where c.deleted 
<> 'true' AND c.name LIKE :search ORDER BY name ASC". Check the query syntax 
for correctness. See nested exception for details.; nested exception is 
<openjpa-2.1.0-r422266:1071316 nonfatal user error> 
org.apache.openjpa.persistence.ArgumentException: Failed to execute query 
"select c from Rooms c where c.deleted <> 'true' AND c.name LIKE :search ORDER 
BY name ASC". Check the query syntax for correctness. See nested exception for 
details.
[detail] =>
)

Original issue reported on code.google.com by profiwar...@googlemail.com on 24 Oct 2011 at 1:13

[GoogleCodeExporter]

1.8.5 same problem

Original comment by profiwar...@googlemail.com on 24 Oct 2011 at 2:31

[GoogleCodeExporter]

Original comment by seba.wag...@gmail.com on 26 Oct 2011 at 9:21

• Changed state: Accepted
• Added labels: MileStone-Release1.8.6

[GoogleCodeExporter]

there is no error here.

The param to order with is "c.name" and not name ...

You could also just leave this string empty and would receive a result with 
default ordering. But if you actually want to order you need to specify the 
correct path ... I don't know how we should specify this better, cause actually 
appending the "c." to the query everytime is no general solution, cause you 
would forbid ordering on sub-queries in general that way...

Original comment by seba.wag...@gmail.com on 30 Oct 2011 at 1:45

• Changed state: Review