I am trying to do a very simple thing : show a list of order details for a subset of orders. I set up an OrderDetail form and an OrderDetail_to_OrderHeader relation including a join on order number plus a test on the status field of the order (which is a filed in the OrderHeader table).
When it shows, I still get all the OrderDetail table, except that the OrderHeader data fields I print along on each row of the list are missing for the “filtered” rows.
I tried the same thing with AddFoundsetFilterParam, with the same result.
I managed to get what I wanted through a loadRecord(appropriate SQL query) but could explain this strange standard behaviour or refer me to the proper section in the documentation, because to me, it makes no sense.
When it shows, I still get all the OrderDetail table, except that the OrderHeader data fields I print along on each row of the list are missing for the “filtered” rows.
So, you have a table or list view but you are missing related data?
When it shows, I still get all the OrderDetail table
Isn’t that what you want? Order details on the OrderDetail form?
except that the OrderHeader data fields I print along on each row of the list are missing for the “filtered” rows.
I guess you use the correct join?! Otherwise your own statement would give a faulty result as well right? But how do you show these data? is it a relation in a field?
A little more info would help because what you tell is too generic.
Also, what Servoy, what Java, what platform…