Search query - поисковый запрос

[Vladimir_PV]

search in two fields is obtained
поиск по двум полям получается
“select * from data where
classname LIKE '%” + document.childByName(“textClassStudentSearch”).content.text + “%’
AND firstname LIKE '%” + document.childByName(“textNameStudentsSearch”).content.text + "%’
"
but three fields fail
но три поля не получается
highschool.pma (1.5 MB)

[Michael]

If you need to search by first and last name, you can use the following SQL query:

"select *, firstname || ' ' || lastname as 'fullname' from data where \
classname LIKE '%" + document.childByName("textClassStudentSearch").content.text + "%' \
AND fullname  LIKE '%" + document.childByName("textNameStudentsSearch").content.text + "%' \
"