Hi,
I am trying to search a custom table using simple search. I have tried to follow the tutorial in the docs but cant seem to get it to work. I think the issue is the joinCriteria, but I dont know how to resolve it.
My custom package is built and functioning correctly.
The table in question has 4 columns labeled: isbn, title, stations and page. There are around 9500 rows.
I want to search the station column and return any resources using the title column. The titles match the longtitle in my modx resources.
My code:
&customPackages=`IndexToStations:station:its:{core_path}foo/:IndexToStations.title = modResource.longtitle`
When I search a value the page starts processing but does nothing until the site/browser grinds to a halt. There is no error in the modx log.
Can anyone give me some guidance?
Many Thanks