Will an FS gotten with databaseManager.convertFoundSet(fs,‘rel_name’) receive databroadcasts just as a related fs would?
And by databroadcasts I mean all CRUD events.
Thanks in advance.
it will receive all updates and deletes of records it contains
But not creates because it is a normal (none related) foundset and those dont suddenly add created records to its list
Hi Johan thanks for the reply.
So even if the fs I pass in as the first param is related, the resulting fs is not, and therefore won’t get new-record broadcasts correct?
yes because the resulting foundset is not a related foundset,
This can’t be because the resulting foundset does not have records of one declared relation, it has records of many combined relation instances.
and only RelatedFoundsets do listen to creation, normal foundsets dont do that.
I don’t know what’s happening behind the scenes to create this new fs, but I wonder how different it is from a right outer join? You guys removed right outer some time ago, but if the is performing a right outer join, maybe reexposing right outer in rel props is reasonable?
Jeff,
In Servoy the foundset queries always select the pk of the foundset table.
In case of right outer join this could result in null pk values, this does not make sense in Servoy.
For example, a right outer join from orders to order_details could return order_detail data for records that are not linked to an order.
In an order-foundset this is meaningless.
databaseManager.convertFoundSet(fs,‘rel_name’) will create a foundset on the related table with a join back to the main table.
When you have an orders foundset with some condition, databaseManager.convertFoundSet(fs,‘orders_to_order_details’) will give you an order_details foundset of all order_details that have orders that meet the original condition.
Rob
Great explanation. Thx