IQuery Issues (Doc ID 1909901.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Agile PLM Framework - Version 9.3.3.0 and later
Information in this document applies to any platform.

Symptoms

On Test : Agile PLM 9.3.3.0 version, Software Development Kit

IQuery issues

The below query is not working in 9.3.3

 IQuery selec All Items With Same Base = (IQuery)session.createObject(-5, "select * from [Items] where [Title Block.Number] like '" + baseNumber + "-%' " + "order by [Title Block.Number] asc");

The same Query it is working in 9.3.1 . We are going to migrated to 9.3.3 .could you some one help this.this is very urgent aspart of the migration.

ERROR
Root Cause exception : com.agile.util.exception.CMAppException: Attribute Title Block.Number" not found.

STEPS
The issue can be reproduced at will with the following steps:
1. Create an SDK code with the query
    IQuery select All Items With Same Base = (IQuery)session.createObject(-5, "select * from [Items] where [Title Block.Number] like '" + baseNumber + "-%' " + "order by [Title Block.Number] asc");
2. Run the code in 9.3.1 environment and 9.3.3 environment
3. Observe the code works in 9.3.1 but not in 9.3.3


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms