We have some custom data that we are managing within Umbraco. This data isn't in a document type, and is just in a standard database table. Access to it is via the petapoco from DatabaseContext.
I would like to index this table so that I can search it. I can't find any articles that explain how i'd set this up. Can anyone help?
Lucene/Examine index & search of database data
Hi,
Very new to Umbraco. Using v7 latest
We have some custom data that we are managing within Umbraco. This data isn't in a document type, and is just in a standard database table. Access to it is via the petapoco from DatabaseContext.
I would like to index this table so that I can search it. I can't find any articles that explain how i'd set this up. Can anyone help?
Thanks,
Adam
Hi Adam and welcome to our.
I am not a .NET developer, but perhaps you can get an idea how you could do it by look at Ismail Mayat comment in this thread https://our.umbraco.org/forum/umbraco-7/using-umbraco-7/50026-creating-own-index-with-examine?p=0#comment178900
Hope this can help you a step further.
/Dennis
Adam,
If you download the source code for examine see https://github.com/Shazwazza/Examine and specfically look at the custom indexing example here https://github.com/Shazwazza/Examine/blob/master/Projects/Examine.Web.Demo/OrmReaderDataService.cs as well as explore the config settings etc you should be able to hack that and index your db table.
Regards
Ismail
Thanks,
These links helped. I seem to have it working now.
is working on a reply...