Dynamic options in databasejoin

[Bauer]

I have a datbasejoin element that uses the ajax feature to refresh the options based on a WHERE condition.

I want to trigger an alert that notifies the user when the number of options in that databasejoin select dropdown list is empty (i.e. the query returned no results). But I need to wait for the spinner to go away before I 'count' the options in the select.

Is there a Fabrik event handler that will allow me to know when a filter applied to a databasejoin element (via the 'Joins where and/or order by statement (SQL)' condition) has competed?

 

[cheesegrits]

Yes, I think fabrik.dbjoin.update should do it, fires at the end of the AJAX complete function.

https://github.com/Fabrik/fabrik/bl...rik_element/databasejoin/databasejoin.js#L406

requirejs(['fab/fabrik', function() {
   Fabrik.addEvent('fabrik.dbjoin.update', function(el, options) {
      // your code here.  'el' is the join element object, options should be an array (or object, I dunno) of the new options
   });
});

-- hugh

 

[Bauer]

Thanks Hugh - sounds like just what I needed.