I was searching around all last week for a way to make a dropdown column in a BAQ and all I came across was people suggesting to use code. I stumbled across the Updatable Field Editor and was able to make a custom dropdown selection column for a dashboard.
I was wondering if anyone else uses this or if you don’t and why. I’m assuming if you know how to code it then its fairly simple but this might be useful for those who aren’t as savvy with coding.
First I added a UD field to my Order Release table and then added it to the form for display. Then I went to the baq designer and set it up as shown below. I had to edit the dashboard grid properties to show the field and then it started working as intended.
Yea - so picture you have a requirement for data from another BO (you could potentially add it to your BAQ), but if there is any data that is not available to the BAQ (say a value on the form for example), you have no way to deal with that case.
Other than that, for you needs - it looks like this is a homerun.
Works great if you are happy with all of the rows having the same selection values - but if you need a truly dynamic list, one that can change based on conditions, you just cant do it in the BAQ.
Example - a dropdown list showing me only the ShipTo’s of the customer on the current row (on each row)
Yeah you are right to that level. But I think for most use cases a user code or BAQ suffices, and you can hand off list maintenance to the end user through user code maintenance. It’s kind of dynamic (better than a typed list), but yes, may not get that level of sophistication.
I am using this in a DB (via BAQ) as well and it works extremely well but my wish it to be able to add to the drop down list short of going back and revising the BAQ. Is there a reasonably simple way of doing this?
I’m not sure what you mean. The BAQ looks up the information when you need it. If the information changes, the BAQ should pick up the changes and adjust the list. What’s your use case?
I put the lookup table in the BAQ (it is a UD field) and the picklist is defined in the BAQ and I believe I have boxed myself into updating the BAQ each time I need to add/delete from the picklist
Do you mean you typed the list in a BAQ? Or you are looking up the information in a BAQ? You have to give me more information. There are a lot of ways to get/create lists with a BAQ.
Another option would be to remove the criteria from the BAQ, and add it as a filter on the DB
(assuming that removing the criteria doesn’t create some overwhelming query on your server)
I just added the BAQ for the dropdown option but I want searchable dropdown. Also if I want to remove the selected value to blank there is no option for it. Any idea how to make the searchable dropdown?
I do agree that this method is by far, much easier, and suitable for most cases