Filter lookup column not work IE

Forms
1

Hi Plumsail,

I used Plumsail form that It have a lookup column that lookup to list A, list A have choice column “Status”. I want filter following status equal “Inprogress” but it not work in IE.
Chrome run ok

My code : fd.field(‘Lookup’).filter = “Status eq ‘Inprogress’”

Please help me

Thanks

2

Dear @dat,
Are you sure that you are using both commands to apply filtering?

fd.field('Lookup').filter = "Status eq 'Inprogress'";
fd.field('Lookup').widget.dataSource.read();

Can you, please, send us your code, or perhaps record a video with IE not working? That should really help!

3

Yes, I am sure that I am using both that commands.

But I missed that my Status choice column have value with Unicode (Đang xử lý, Đã xử lý).

This is my code:

fd.spRendered(function(vue) {
fd.field('Lookup').filter = "Status eq 'Đã xử lý'";
fd.field('Lookup').widget.dataSource.read();
});

I tried that code with another choice column with choice value that do not have Unicode (New, Completed). It run OK on both IE, Chrome.

This is my code with another choice column:

fd.spRendered(function(vue) {
fd.field('NewLookup').filter = "NewStatus eq 'Completed'";
fd.field('NewLookup').widget.dataSource.read();
});

Lookup1
Lookup1858×457 3.11 KB

Lookup2
Lookup21420×745 37.5 KB

Please help me,
Thanks

4

Dear @dat,
Hmm, I see… Thank you for clarification! If this is the case, please, try to use the following code, it should work:

var filter = encodeURIComponent('Đang xử lý');
fd.field('Lookup').filter = "Status eq '" + filter + "'";
fd.field('Lookup').widget.dataSource.read();
5

It is ok now.

Thank you so much