[QUESTION] Filter values change

[guanjiwang2016]

Hello,

I want to get some technical help from you as I have met some difficulties.

The existed function :

In query form, we have parent filter and children filter, the children filter values are changed and shown according to the selected value(s) in parent filter by executing an SQL command in the backend.

The expected function :

I want to change and show the children filter values according to the selected values in parent filter not by executing the SQL but by the pre-saved value list or store in js controller.

What I have done for it:

1. Create a new form component js in client public and add new fire event in both controller and component js, according to the parent change.
2. Locate the target form container in formController.
3. Successfully get the parent/children parameter's type, value and their connection but there is no method for setting personal values directly to children parameters. Children values are changed and shown only by store, proxy, property.

Can you give me some instruction about how to do the rest, please?
Thank you for your help.
regards,
Guanji

[PabloA-dev-coder]

Hi,
Can we have a status on that please ?

Best regards
Pablo

[bfiorito]

Hi Guanji,

I’m not sure to correctly understand your problem so i’ll try to sum up
just to clearify :
You are working with form components, espacially combobox ( = parent and
children filter) and you try to filter children client-side after selecting
something in the parent combobox, is it right ?

If it’s the case, i think you can try to :

1- Change queryMode in children combobox in order to load local data :

​queryMode : 'local'​

2- ​Try to use MemoryProxy in the children store (many examples in SITools) in order to add data manually

proxy : {
                type : 'memory',
                reader : {
                    type :'json',
                    root : 'dataset.columnModel',
                    idProperty : 'id'
                }
            }​
}

3- Use store.add() or store.loadData() methods, to add new records according to the store’s model.

​Let me in touch if i have answered to your question​.

​Best ​Regards,
Bastien​

[guanjiwang2016]

Hi Bastien,
Thank you for your reply. Yes, that's what we want to do exactly.
But I want to add store.load locally for SOHOListBoxMultiple(like ListBoxMultiple),

I have created the store, model, fire event, but I don't know how to load the local store, here are my codes,
1- My store:

2- My model:

3. Add fireEvent in the listeners in client-public/js/forms/components/ListBoxMultiple.js:
   

4. Add event detail in fireEvent in client-user-3.0/app/controller/component/form/FormController.js, try to load store locally but not by proxy:
   

Can you give me an example, please?
Thank you very much.
Regards,
Guanji

[bfiorito]

Hi Guanji,

We wrote an example for you, let me know if it helps you :

https://fiddle.sencha.com/#view/editor&fiddle/2201

[guanjiwang2016]

Hi Bastien,

That is super! 
Thank you so much!

Best regards,
Guanji