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