I have a table ServiceTable, which among other information has a field of type CustAccount
I have another table GoodCustomers with one field Custaccount
I have create a table relation between the tables at the ServiceTable
Validation=No
Cardinality = ZeroOne
Related Table Cardinality = ZeroOne
Field from serviceTable = field from GoodCustomers
I have a class HandleServiceTable with a initquery method where the table ServiceTable is added as the only datasource
The class is a contract class with attribute DataContractAttribute and it implements SysoperationValidatable, SysOperationInitializable
when I run this class I can filter fields from servicetable.
When I use Joins i can see my servicetable.
I mark it and use add table Join
I can see my table GoodCustomers, I select it and use select
The table is added to the query as expected.
I execute the class and I get the expected result - only servicetable records where the field CustAccount exists in table goodCustomers are handled.
I execute the class HandleServiceTable again
I can still see that my goodcustomers table is added to the query, But I can't remove it. The function remove table join is greyed out
I have another Class - Change status which is created with a querybuild method where the servicetable is added as the only table.
When I start this class my table goodcustomers is added to the query automatically. When I use records to include I can see that the table goodcustomers is included.
I look at the join and can see that the table is added to the query, and I can remove it.
I return to my first class HandleServiceTable.
Here I also can see that my goodcustomers table is removed.
I have discovered that if I create a query in AOT and use it it works as expected.
can anyone point me in a direction of solving this issue, so I can remove the added table relation?
