Records are not displaying in lookup table when I have a Parent/Filter selected. I’m a user of PHPMaker 2018 upgraded to 2019, so in v2019 the Parent/Filter no longer accepts varchar as primary key datatype in link field?
Post table schema of your main table, lookup table and the settings of your lookup field so other users can try to reproduce the problem.
Try check “Use modal dialog for lookup”. My problem is similar when i use select box.parent code | child code | desc
1 | 1 | teste 1 (This don´t display)
1 | 2 | teste 2 (This don´t display)
1 | 5 | teste
2 | 04014 | SEDEX A VISTA
2 | 81019 | E-SEDEX STANDARD
3 | 1 | Correios - PAC
3 | 2 | Correios - EXPRESSO
3 | 3 | JadLog - .Package
3 | 4 | JadLog - .ComReturn for page:
[
{
“lf”: “1”,
“df”: “3”,
“df2”: “1”,
“df3”: “Correios - PAC”,
“df4”: “”,
“ff”: “3”
},
{
“lf”: “2”,
“df”: “3”,
“df2”: “2”,
“df3”: “Correios - EXPRESSO”,
“df4”: “”,
“ff”: “3”
},
{
“lf”: “5”,
“df”: “1”,
“df2”: “5”,
“df3”: “teste”,
“df4”: “”,
“ff”: “1”
},
{
“lf”: “04014”,
“df”: “2”,
“df2”: “04014”,
“df3”: “SEDEX A VISTA”,
“df4”: “”,
“ff”: “2”
},
{
“lf”: “81019”,
“df”: “2”,
“df2”: “81019”,
“df3”: “E-SEDEX STANDARD”,
“df4”: “”,
“ff”: “2”
},
{
“lf”: “3”,
“df”: “3”,
“df2”: “3”,
“df3”: “JadLog - .Package”,
“df4”: “”,
“ff”: “3”
},
{
“lf”: “4”,
“df”: “3”,
“df2”: “4”,
“df3”: “JadLog - .Com”,
“df4”: “”,
“ff”: “3”
}
]Table schema:CREATE TABLE tabela01 (
id int(11) NOT NULL,
nome varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;INSERT INTO tabela01 (id, nome) VALUES
(1, ‘pai 01’),
(2, ‘pai 02’),
(3, ‘pai 03’);CREATE TABLE tabela02 (
tabela01 int(11) NOT NULL,
id int(11) NOT NULL,
nome varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;INSERT INTO tabela02 (tabela01, id, nome) VALUES
(1, 1, ‘teste 1-1’),
(1, 2, ‘teste 1-2’),
(1, 5, ‘teste 1-5’),
(2, 1, ‘teste 2-1’),
(2, 2, ‘teste 2-2’),
(3, 1, ‘teste 3-1’),
(3, 2, ‘teste 3-2’),
(3, 3, ‘teste 3-3’),
(3, 4, ‘teste 3-4’);CREATE TABLE tabela03 (
tabela02-01 int(11) NOT NULL,
tabela02-id int(11) NOT NULL,
nome varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;INSERT INTO tabela03 (tabela02-01, tabela02-id, nome) VALUES
(1, 5, ‘teste01’),
(2, 1, ‘teste’);ALTER TABLE tabela01
ADD PRIMARY KEY (id);ALTER TABLE tabela02
ADD PRIMARY KEY (tabela01,id);ALTER TABLE tabela03
ADD PRIMARY KEY (tabela02-01,tabela02-id);
COMMIT;--------------------------------In PHPMaker 2019
Table: tabela02
Field: tabela01 → Edit Tag → Select → Check “Use lookup table”
Lookup Table → Table name: tabela01, Link field: id, Display fiel #1: nome
Table: tabela03
Field: tabela02-01 → Edit Tag → Select → Check “Use lookup table”
Lookup Table → Table name: tabela01, Link field: id, Display fiel #1: nome
Field: tabela02-id → Edit Tag → Select → Check “Use lookup table” and “Use modal dialog for lookup”
Lookup Table → Table name: tabela02, Link field: id, Display fiel #1: nome, Parent field: tabela02-01, Filter field tabela01After try uncheck “Use modal dialog for lookup”
Cannot simulate. Please check if the issue is resolved with the latest template. For registered user, click Tools → Update Template. Otherwise download the template again from our web site.If you are a registered user, you can send your project/database to the support email if problem persists.
From support:Please note that the feature of lookup table does not support to use table using a composite key as the lookup table. (The link field must be a unique value in the table).Please disable the option “Use lookup cache” in [Tools] → [Advanced Settings] then generate all files and try again.Or you can create a database view with a unique index primary key and the data required as your lookup table then try again.
I went downlaod Template php20190.zip and Please disable the option “Use lookup cache” in [Tools] → [Advanced Settings]
please help
Try clean a destination directory and generation all files again.
Do it and the same problem
Webmaster wrote:
If you are a registered user, you can send your project/database to the support email if problem persists.
When choosing an option in the “Parent/Filter†selection box, scheduled tasks still display all records rather than just those related to the selected parent or filter. This can cause confusion to end users when they do not see what they expect in the results.
We have a record that when the filter and parent records are selected, the Mybk survey filter options disappear. A user who doesn’t know how to enter a new value has no way of entering it regardless of how they change the filter. This is a big issue because the interface became unusable.