oracle.ifs.search
Class FreeFormQualification

java.lang.Object

  |

  +--oracle.ifs.search.SearchQualification

        |

        +--oracle.ifs.search.FreeFormQualification

All Implemented Interfaces:

java.lang.Cloneable, java.io.Serializable

public class FreeFormQualification

extends SearchQualification

The FreeFormQualification provides a hook for knowledgable & admin users. Users can specify any sql expression, which is integrated into the Search. The provided expression is not parsed in any way, so users must provide the exact sql.

Since the sql generated for searches always uses table aliases, for searches with FreeFormQualifiers you must provide class aliases in the SearchClassSpecification.

There are no restrictions on Admin users. In non admin mode the sqlString cannot contain references to unsecure database objects. This is to prevent users from bypassing the security system. But admin users can setup SearchObjects that contain FreeFormQualifiers and give access to normal users to execute them.

Currently FreeFormQualifiers don't support late binding. Hence the sqlString cannot contain '?'.

See Also:

Serialized Form

Constructor Summary

FreeFormQualification()
Constructs a FreeFormQualification.

Method Summary

java.lang.String	getSQLExpression() Gets the SQL expresion of this object.
void	setSqlExpression(java.lang.String sqlExpression) Sets the SQL expression for this object.

Methods inherited from class oracle.ifs.search.SearchQualification

clone

Constructor Detail

FreeFormQualification

public FreeFormQualification()
                      throws IfsException

Constructs a FreeFormQualification. SQL expression needs to be set before using this object in search.

Throws:

IfsException - if the operation fails

Method Detail

setSqlExpression

public void setSqlExpression(java.lang.String sqlExpression)
                      throws IfsException

Sets the SQL expression for this object.

Parameters:

SQL - expression for this qualification

Throws:

IfsException - if the operation fails

getSQLExpression

public java.lang.String getSQLExpression()
                                  throws IfsException

Gets the SQL expresion of this object.

Returns:

SQL expression of this object.

Throws:

IfsException - if the operation fails