I've created a custom table and a 1:1 relationship to a standard table. Filtering on the relationship results in "There was an error processing the request".
This statement causes the error:
var ia = new API_Session();
ia.ip_readByQuery(
"APPYMT",
"RECORDNO, VENDORID, VENDORNAME, myrelationship.mycolumn",
"STATE='C' and myrelationship.mycolumn='ABC' ",
1000,
"xml",
dataReceived
);
If I remove it from the filter the statement succeeds.
var ia = new API_Session();
ia.ip_readByQuery(
"APPYMT",
"RECORDNO, VENDORID, VENDORNAME, myrelationship.mycolumn",
"STATE='C'",
1000,
"xml",
dataReceived
);
That should work shouldn't it?
