How to add a database stored function in search config field of custom domain manager ?

[dheeraj]

Laravel : 8.12
Aimeos : 2020.10
PHP Version : 7.4.13
Environment : Windows

I have created a new domain along with its manager, items and whatever necessary and everything is working fine.
But now i want to allow database stored functions to be added as filter conditions for searching items.
I guess i need to add a search function to the manager in its $searchConfig field but the problem is that the stored function is parameterized. The stored function has following signature -

Code: Select all

MYFUNC (parameter1, parameter2, parameter3, parameter4) 

I also need to compare the function return value against another value using any comparison operator in the SQL statement.
So, in total i need to pass five (4 function parameters + value to compare with return value) parameters for the values in the search filter condition.
I don't know whether aimeos supports stored functions and whether it is possible to pass these five parameters using filter conditions.

[aimeos]

Yes, it's possible using search functions like these ones:
https://github.com/aimeos/aimeos-core/b ... #L166-L183

Here you can see how it will be used:
https://aimeos.org/docs/latest/infrastr ... -functions