The following example shows how you might use a parameter expression in Java code. It creates an RqlStatement and uses it in executing a query to find person repository items where the value of the age property is greater than 23.

RepositoryView view = repository.getView("person");
RqlStatement statement = RqlStatement.parseRqlStatement("age > ?0");

Object params[] = new Object[1];
params[0] = new Integer(23);

RepositoryItem [] items =statement.executeQuery (view, params);

Here is another example that demonstrates a text comparison query:

RqlStatement statement=RqlStatement.parseRqlStatement("lastName STARTS WITH ?0");
Object params[] ={new String("m")};
    items = statement.executeQuery (view, params);

Note how in the text comparison queries the comparison value "m" is enclosed in double quotes; otherwise, the RQL parser assumes the comparison term refers to a property name rather than a property value.

Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices