Skip to Content
0
Former Member
Mar 12, 2008 at 11:21 AM

Error: The array of table schemas must contain at least one table

34 Views

Hello,

I'm trying to search items using FieldSearchDimension. and I'm getting the error:

"The array of table schemas must contain at least one table".

Here's my code:

TableId tableId = getRepositorySchema().getTable("MDM_PRODUCTS").getId();

FieldId[] fields = new FieldId[2];

fields[0] = getRepositorySchema().getField("MDM_PRODUCTS", "MDM_MDM_PRODUCT_ID").getId();

fields[1] = getRepositorySchema().getField("MDM_PRODUCTS", "MDM_COMP_NUMBER").getId();

ResultDefinition resultDefinition = new ResultDefinition(tableId);

resultDefinition.setSelectFields(fields);

Search search = new Search(tableId);

String compNumber = "aaa";

FieldSearchDimension fieldSearchDimension = new FieldSearchDimension(fields[1]);

TextSearchConstraint textSearchConstraint = new TextSearchConstraint(compNumber,TextSearchConstraint.EQUALS);

search.addSearchItem(fieldSearchDimension,textSearchConstraint);

RetrieveLimitedRecordsCommand retrieveLimitedRecordsCommand = new RetrieveLimitedRecordsCommand(getConnection());

retrieveLimitedRecordsCommand.setSession(getAuthenticatedUserSession());

retrieveLimitedRecordsCommand.setResultDefinition(resultDefinition);

retrieveLimitedRecordsCommand.setSearch(search);

retrieveLimitedRecordsCommand.execute();

Thanks,

Haguy