MIGX: &where filter addressing MIGX_formname?

aaantz · May 19, 2023, 4:33pm

How can i use &where filtering in my getImageList call to output only results for forms whose MIGX_formname start with a certain word?

This here doesn’t work:
&where=`{"MIGX_formname:LIKE":"Car_%"}`
&where=`{"MIGX_formname:LIKE":"Flower_%"}`

halftrainedharry · May 19, 2023, 4:49pm

You can’t use normal SQL filtering, because here you are filtering the items of a JSON array and not rows in a database.

Take a look at the function filterItems to see what options are available:

github.com

Bruno17/MIGX/blob/06babc1c8a386f2f99860965cbaba1c916e98da5/core/components/migx/model/migx/migx.class.php#L2313


      
          
          
public function debug($key, $value, $reset = false) {
          
          
    $debug[$key] = $value;
              $chunk = $this->modx->getObject('modChunk', array('name' => 'debug'));
              $oldContent = $reset ? '' : $chunk->getContent();
              $chunk->setContent($oldContent . print_r($debug, 1));
              $chunk->save();
          }
          
          
function filterItems($where, $items) {
          
          
    $tempitems = array();
              foreach ($items as $item) {
                  $include = true;
                  foreach ($where as $key => $operand) {
                      $key = explode(':', $key);
                      $field = $key[0];
                      $then = $include;
                      $else = false;
                      $subject = $item[$field];

It probably works if you use contains.

Another option is to create a custom snippet (based on the getImageList snippet) where you code the filtering yourself based on your exact needs.

aaantz · May 19, 2023, 6:22pm

Thanks @halftrainedharry – contains works:

&where=`{"MIGX_formname:contains":"Car_"}`

system · May 21, 2023, 6:22pm

This topic was automatically closed 2 days after discussion ended and a solution was marked. New replies are no longer allowed. You can open a new topic by clicking the link icon below the original post or solution and selecting “+ New Topic”.