Product filter

[David]

Why is this filter not working?

Code: Select all

      
$productFilter->add($productFilter->and([
	$productFilter->is($productFilter->make('product:prop', ['vendor_code', null, $productData[0]] ), '!=', null),
        $productFilter->is($productFilter->make('product:prop', ['barcode', null, $productData[8]] ), '!=', null),
 ]))->add( 'product.type', '==', 'default');

Code: Select all

$productManager->search($productFilter->add('product.type', '==', 'default')
          ->add($productFilter->make( 'product:prop', ['vendor_code', null, $productData[0]]), '!=', null)
          ->add($productFilter->make( 'product:prop', ['barcode', null, $productData[8]]), '!=', null));

And this one works

Code: Select all

      
$productFilter->add($productFilter->and([
         $productFilter->is($productFilter->make('product:prop', ['vendor_code', null, $productData[0]] ), '!=', null),
]))->add( 'product.type', '==', 'default');

And this one works

Code: Select all

     
$productFilter->add($productFilter->and([
         $productFilter->is($productFilter->make('product:prop', ['barcode', null, $productData[8]] ), '!=', null),
]))->add( 'product.type', '==', 'default');

How to query for two properties?

[aimeos]

That doesn't work because relational databases join tables and records this way:

Code: Select all

id, code, label, propertyid, propertytype, propertyvalue
1, 'prod', 'Test', 10, 'vendor_code', 'abcd'
1, 'prod', 'Test', 11, 'barcode', '1234'

Thus, there will be no joined record with contains both property types/values.

[TGergo]

I have two questions:

There is a product attribute called Author with many names.
The promblem is, filter dropdown does not include all names.

And other.
Can I list the suppliers by number DESC?
Thank You!

[aimeos]

There's an internal (configurable) limit how many items are fetched in one request to mitigate DoS attacks. You can increase the limit using this setting: https://aimeos.org/docs/2022.x/config/c ... /#max-size