Error when executing ip_readByQuery with a filter on a custom relationship

[Michael Knecht]

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?

Edited May 8, 2024 by Michael Knecht