Re: Candidate Profile Search which have multiple employers and Educations.

2010-08-26 Thread Sumit Arora
Thanks Ephraim for your response. Actually I am not using DIH to Sync the data from DB, I wrote on DB-SYNC by myself, and I am directly retrieving rows from MySQL-DB and Indexing to Solr. On my Earlier cases - I Picked Rows with Column Label from DB, and Similar Column Defined in my Sync Program,

RE: Candidate Profile Search which have multiple employers and Educations.

2010-08-26 Thread Ephraim Ofir
As far as I can tell you should use multiValued for these fields: In order to get the data from the DB you should either create a sub entity with its own query or (the better performance option) use something like: SELECT cp.name, GROUP_CONCAT(ce.CandidateEducation SEPARATOR '|') A