Popup Window List - SQL filter -- doews not work

[MichaelCarroll]

I have a pop up windows container in a UX that contains a list control. It is a list of people. I am using this list to select staff and vendors as they relate to a work orders that the user is filling out.

On the UX I have a hidden field that is populated by a lookup button.

(Customers lookup button) is clicked and this hidden field is populated with the text "Customers".
The button also triggers a popup window container to be shown. The List in this container has an argument that is bound to this hidden field. In the List genie the SQL works with the supplied argument. When the Popup Window is opened it does not run the filter on the list as is expected and I get the whole list.

If I put a button on the popup window to refresh the shown list -- the List filters the data correctly.


I tried delaying the opening of the window as the hidden field changes based on what button is clicked to lookup a staff person or vendor.

{dialog.Object}.setValue('hiddenType',"Sales");
setTimeout(function() {
 {dialog.object}.showContainerWindow(this,'WINDOW_1');
}, 1500);

What could I be doing wrong here?

Thank you,

Michael Carroll

[frankbicknell]

Re: Popup Window List - SQL filter -- doews not work

Perhaps you can refresh the list data.

{dialog.Object}.setValue('hiddenType',"Sales");
setTimeout(function() {
 {dialog.object}.showContainerWindow(this,'WINDOW_1');
}, 1500);
{dialog.object}.refreshListData(UXListName [,options]);

[Davidk]

Re: Popup Window List - SQL filter -- doews not work

I don't think you need a setTimeout in this case... and Frank is right... you need to refresh the List Control data because you're changing it's filter after it's been rendered.

You don't need it, but if you're going to use a setTimeout... I'd be a bit uncomfortable putting the refresh after the setTimeout... because it will probably be run before the setTimeout. In this case, it's most likely ok, but usually it causes trouble.

I would change your List to "Delay render till explicit refresh"... and then add your .refreshListData() method to the Window Container onBeforeShow event. That way your List won't load with data before you're ready, and will be refreshed before the Window is shown.

Another way to handle this is to use one of the .filter methods on the List... but then you'd be rendering the full List and just filtering what's shown. If you have a lot of List rows you may not want to do this. The upside is that .filter is client-side and so no server callbacks. If you do this, don't use "Delay render till explicit refresh".

[MichaelCarroll]

Re: Popup Window List - SQL filter -- doews not work

I don't think you need a setTimeout in this case... and Frank is right... you need to refresh the List Control data because you're changing it's filter after it's been rendered.

You don't need it, but if you're going to use a setTimeout... I'd be a bit uncomfortable putting the refresh after the setTimeout... because it will probably be run before the setTimeout. In this case, it's most likely ok, but usually it causes trouble

.
Dropped the timeout.

I would change your List to "Delay render till explicit refresh"... and then add your .refreshListData() method to the Window Container onBeforeShow event. That way your List won't load with data before you're ready, and will be refreshed before the Window is shown.

Ok did this.

Another way to handle this is to use one of the .filter methods on the List... but then you'd be rendering the full List and just filtering what's shown. If you have a lot of List rows you may not want to do this. The upside is that .filter is client-side and so no server callbacks. If you do this, don't use "Delay render till explicit refresh".

Good to know.

Got it to work perfectly.

Thank you Frank and Dave.