Where is the relationship for an embedded list called?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-04-2022 02:06 PM
So I understand that the refineQuery(current, parent) function within a relationship sets up a query that can be used to pull records for a embedded/related list.
Where exactly does this query actually get executed? .query() or .next()?
I'm struggling with an embedded list not updating with a field change on the form.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-04-2022 02:32 PM
Hey Patrick,
I was making a couple of embedded lists last week. The query is defined on the relationship record not on the form or current record. Since the related or embedded list is a list of records separate from the current record, I believe you'll need to save the change to your current record then reload the form for the related or embedded list to update.
Rick
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-04-2022 02:39 PM
Thank you for your reply!
I understand where the query is defined, I'm wondering how it's implemented.
My refineQuery() function is set up properly and is getting all the correct data passed through it and set up in a query via current.addQuery('field','value).
I'm just looking for where that set-up query is actually executed; I've looked through business rules, client scripts, etc. and can't find any place that implements the execution of relationships.
Thanks again!
Patrick
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-04-2022 02:47 PM
you're trying to trigger the reload of the list on a field change right?
only place I know is where you can tell it to load related lists with the form, after or on demand....but even if you do trigger the list reload it's going to look at the DB not the loaded form with the updated field.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-04-2022 03:20 PM
Okay I see - what exactly is the manual process for triggering an embedded list reload? I've been saving and refreshing to try and yield updated embedded list results.
Is it a business rule?
It's okay if it looks back at the DB - that all is being updated properly, it's just not making its way to the embedded list. The field on the form, the m2m table it's referencing, and the table the relationship is querying from all have the correct, updated values.