Re: [nmsinc] Bug in v2.14
Hi all,
This is just an update to explain what nmsinc found:
When setting a pulldown field to use values generated by an sql query that update dependent on another field in that view, the values were not being returned by the query or the query would not complete (and you would always see the 'loading...' placeholder).
Here's a bit about what advanced pulldowns are good for:
Advanced pulldowns are a great way to add features to CMSB records and, when coupled with the right SQL, can help make a lot of tasks a lot easier.
Using the 'update on change' option means that when the selected field is updated (the field on which we are waiting for information), an Ajax request is sent to re-populate the dependent field(s) with the appropriately filtered/retrieved values.
So, if you have three tables (say accounts - individuals with their contact info and a field called Company which populates from the Companies table, Companies - all the details of a company, Payments - which has a field Company that populates from the Company table and Users which uses an advanced sql query to populate).
You want the Payments view to allow you to choose a 'Company' and then a user from that company. Set the 'Users' field to be an advanced pulldown using a MySQL query, set the update on change field to 'Company'. When the 'create' form is opened, there will initially be no options in the 'Users' pulldown but, once 'Company' is selected, all users who are from that 'Company' will be displayed as options in the pulldown.
Tom