AdvSearch possible to search custom table in same DB?#

Hi,

I have a custom table with content and an according docid stored in it. Is it possible to search those fields in this custom table? Do I have to build an XPDO schema?? How does it work? Documentation of the joined resources did not bring any clues to me...

Hope it is not a dump question *G*

Greets
MikeMcNuke

You need to provide the package name of your custom table. So you have to build an XPDO schema.

Read the chapter Declaration syntaxes - Joined of the query hook document.
This document is available from http://www.revo.wangba.fr/assets/files/cheatsheets/queryHook110_v1.0.pdf
Look also the demo named Dvd

Hi,

many thanks for your tips. Will look into it!!!

Bye

Hi,

model and schema is created. Works great.

but now I still don't know what to do next...

I should fill out the joinCriteria...but how should I fill it out so AdvSearch can tie a row of data from my table to a DocID ?? Is this even possible with it?

Hi,

model and schema is created. Works great.

but now I still don't know what to do next...

I should fill out the joinCriteria...but how should I fill it out so AdvSearch can tie a row of data from my table to a DocID ?? Is this even possible with it?

Edit:
Will try it with this snippet:
<?php
$joined = array(
array(
'package' => 'JHWproducts',
'class' => 'jhwp',
'packagePath' => '{core_path}components/JHWproducts/model/',
'fields' => 'content',
'withFields' => 'content',
'joinCriteria' => 'jhwprodukte.docid = modResource.id'
)
);

$qhDeclaration = array(
'qhVersion' => '1.1',
‘joined’ => $joined,
);

$hook->setQueryHook($qhDeclaration);
return true;

Also tried this join:

'joinCriteria' => 'jhwprodukte.docid = site_content.id'

But no results...

Look at the quipQHook snippet used on the quip demo. You can download the queryHook snippet examples from the documentation page.

Quip table is a joined table for the site_content table too.




EDIT:
if jhwp is the class name, you should try :

$joined = array(
array(
'package' => 'JHWproducts',
'class' => 'jhwp',
'packagePath' => '{core_path}components/JHWproducts/model/',
'fields' => 'content',
'withFields' => 'content',
'joinCriteria' => 'jhwp.docid = modResource.id'
)
);

Ah, ok thanks.