A
A
Alexander Ivanov2017-05-06 21:45:05
MODX
Alexander Ivanov, 2017-05-06 21:45:05

Is it possible through where in pdoTools to display a value from tv of type multiple list?

//В tv у меня множественный список типа чекбокс
@SELECT pagetitle, id FROM modx_site_content WHERE parent=5

//т.е. pdoTools выглядит примерно так
              

//на выходе получаю такие штуки
15||17 
8 
15||16 
15||16||29 
6 
15||16||39 
6||8 
6||8

In this case, I want to get, for example, all values ​​from 15
____________________
in SQL, it will look like this:
SELECT *
FROM `db`.`modx`
WHERE (
CONVERT( `value`
USING utf8 ) LIKE '%15%'
)
LIMIT 0 , 30

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Ivanov, 2017-05-08
@cimonlebedev

nothing is impossible:
&where=`{"tegs:LIKE":"%2%"}`

Y
Yuri Tatarkin, 2017-05-11
@tomasoyer

Wrote an incorrect example.
Will get records 151 or 215

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question