215 Posts
cubist
10 years ago
6
Topic

Is it possible to search a non-Joomla table, ie one that I add to the database? 

OR

Just search another database? 

I ask because clearly the latter would need a different connection string for user, pw, db and host.

Get a VIP membership
10 years ago
0
Level 1

I assume that if you create fields, that point to a custom storage location,
SEBLOD will search on that table, once the fields are added to the Search Type.

4229 Posts
Kadministrator
10 years ago
0
Level 1

For seblod to be able to search 3rd party table, each record needs to have a corresponding entry in the #__cck_core table as search query always starts with this table and then joins 3rd party table - at least this is what it seems from my tests

175 Posts
webcastor
10 years ago
0
Level 1

For SEBLOD to see that free table, there must be a matching item (row) in #_cck_core linking to that content.

116 Posts
nycxav
10 years ago
0
Level 1

Hi, 

To populate the #_cck_core table automatically you could create MySQL triggers that fire when you insert, delete or update a record in your non Joomla table.

If the database in which the non Joomla table resides is a remote database you might need to use federated storage engine. This topic might be of interest. 

Regards.
Xav.

548 Posts
joomleb
7 years ago
1
Level 1

Hi guys, 

Pease, Do you have more detailed instructionsinfo about ?

Is there any manual "how to" guide about it ?

Thanks for help

4229 Posts
Kadministrator
7 years ago
0
Level 2

Please don't hijack 2 year old threads

Get a Book for SEBLOD