Filter list in embedded list control

[stewx]

Simple but I cant find it anywhere, I have a UX with and Embedded UX that contains a list control, I'd like to filter the list when the panel is opened.

Tried these from videos showing similar, doesn't work:

function setFilter () {
{dialog.EmbeddedGrid_ORDERSEMBEDDED}.gridBaseFilterSet('StageID <> 1');
}

var co = {dialog.object}.getChildObject('Orders');
{dialog.object}._filterList(SoftwareOrders,StageID <> '1');


Tried javascript to run after ux embedded is loaded with this:

{dialog.object}._filterList('Orders','StageID <> 1');

[Davidk]

Re: Filter list in embedded list control

You just have to get the syntax right for referring to a child object.

And... you have to give the UX a second to render everything.

setTimeout(function(){

var cObj = {dialog.Object}.getChildObject('MYCHILDLIST','UX');
cObj._filterList('LISTCHILD','customer_id <> 1');

},500);

This code sets a pointer to the Embedded UX... which has a specific ALIAS of MYCHILDLIST. You set the Alias in the Parent Embedded Object control.

Once you have cObj child object, you run your _filterList method on it.

The Child UX has a List control named 'LISTCHILD'.

Then, wrap everything in a setTimeout function. In this case it's set to run half a second after the UX renders. Play with the time to get it to work best for you.

I've got this running in the Client-side onRenderComplete event.

[stewx]

Re: Filter list in embedded list control

thanks! Problem tho, I have everything in your example, put it in the javascript section on the left of the parent ux.

Getting error "object does not support property or method "_filterList"

I have the alias set up, do capital letters matter in the child ux name and list name? my list name is camel case but the alias is all caps.

also, i tried this directly in the child ux, left side main javascript section:

{dialog.object}._filterList('MyOrdersList','StageID = 1');
On this I get a syntax error (my list is called 'MyOrdersList' and I want to filter on StageID)

If I run the filter in the list properties filter option it works: StageID = '1'

[Davidk]

Re: Filter list in embedded list control

Is the setTimeout in place? If not, then when the code is in the onRenderComplete event, the code runs before the embedded object is actually embedded. There is not object to run the _setFilter on.

Instead of the Javascript section, put your filter code into a button click event in your child ux. That's actually where I started to ensure all was ok.

Case doesn't seem to matter.

[stewx]

Re: Filter list in embedded list control

It looks like a syntax error, I did the button method and it comes back as: invalid column name 'StageID'

here is what I'm using:

{dialog.object}._filterList('MyOrdersList','StageID = 1');

[stewx]

Re: Filter list in embedded list control

Here is the answer, after hours and much trial and error, hopefully this helps someone:

{dialog.object}._filterList('MyOrdersList','StageID = 1','','');

Need the "","" placeholders for the other parameters not used.

[Davidk]

Re: Filter list in embedded list control

That's odd for two reasons. I am not supplying the unused parameters and it's working for me. Normally, you don't need to supply the balance of parameters. E.g. If you use parameters 1,2,3,6,7 then you must supply 4 and 5. You can't skip parameters in between used params. But, if you don't use 4,5,6,7 then you only need to supply 1,2,3.

At any rate, glad it's working for you.