I kind of have the same issue. I have an object
BusinessLine
- id
- name
ProductLine
- id
- name
- tbl foreignKey
I got the name of the businessLine to show up on the grid of the productLine by using the customSQL pattern. However, when I tried selecting the filter dropdown list I am getting a "View/Table not found" error.
Here is my code:
ListGridField tblField = new ListGridField("tblName", CONSTANTS.tbl(),500);
tblField.setEditorType(new SelectItem());
tblField.setFilterEditorType(new ComboBoxItem());
tblField.setDisplayField("name");
Do I need to do something on the filter setup?
TIA,
BusinessLine
- id
- name
ProductLine
- id
- name
- tbl foreignKey
I got the name of the businessLine to show up on the grid of the productLine by using the customSQL pattern. However, when I tried selecting the filter dropdown list I am getting a "View/Table not found" error.
Here is my code:
ListGridField tblField = new ListGridField("tblName", CONSTANTS.tbl(),500);
tblField.setEditorType(new SelectItem());
tblField.setFilterEditorType(new ComboBoxItem());
tblField.setDisplayField("name");
Do I need to do something on the filter setup?
TIA,
Comment