Re: DeltaImport problem

2009-09-17 Thread KirstyS
.CmsArticleCollectionId = aac.CmsArticleCollectionId >>>>>>>>>>>                        inner join CmsArticle a (nolock) on >>>>>>>>>>> aac.Cms

Re: DeltaImport problem

2009-09-17 Thread KirstyS
>>> = a.CmsArticleId >>>>>>>>>>                  where (a.LiveEdit is null or a.LiveEdit = 0) >>>>>>>>>>                         and >>>>>>>>>> aac.SourceCmsArticleArticleCollectionId >>>>>>>&g

Re: DeltaImport problem

2009-09-17 Thread Noble Paul നോബിള്‍ नोब्ळ्
   inner join CmsArticle a (nolock) on >>>>>>>>>>> aac.CmsArticleId >>>>>>>>>>> = a.CmsArticleId >>>>>>>>>>>                  where (a.LiveEdit is null or a.LiveEdit = 0) >>>>>>>>

Re: DeltaImport problem

2009-09-17 Thread Noble Paul നോബിള്‍ नोब्ळ्
;>>>>>>                         and aac.SourceCmsArticleArticleCollectionId >>>>>>>>>> is >>>>>>>>>> null" >>>>>>>>>>            deltaQuery="Select a.CmsArticleId, a.CreatorId

Re: DeltaImport problem

2009-09-17 Thread Noble Paul നോബിള്‍ नोब्ळ्
t;>>>>                          a.StrapHead, ShortHeading, HomePageBlurb, >>>>>>>>> ByLine, >>>>>>>>> ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank, >>>>>>>>>                          c.CategoryId, Ancest

Re: DeltaImport problem

2009-09-17 Thread KirstyS
       c.CategoryId, AncestralName, CategoryName, >>>>>>>> CategoryDisplayName, ParentCategoryId, c.SiteId >>>>>>>>                   from Category c (nolock) >>>>>>>>                        inner join CmsArticleColle

Re: DeltaImport problem

2009-09-17 Thread Noble Paul നോബിള്‍ नोब्ळ्
CmsArticleCollection ac (nolock) on >>>>>>> c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId >>>>>>>                        inner join CmsArticleArticleCollection aac >>>>>>> (nolock) >>>>>>> on ac.CmsArti

Re: DeltaImport problem

2009-09-17 Thread KirstyS
d - although the info suggests that the correct number of > records have been indexed > > Kev > > -- View this message in context: http://www.nabble.com/DeltaImport-problem-tp25471596p25488073.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: DeltaImport problem

2009-09-17 Thread Kevin Jackson
Hi, > Hi! thanks so much, I have the latest release. > Now, it shows that the delta import is successful but when I query for the > updated article I am expecting, it has not updated. It's like the index is > not being updated with the changes...Any ideas? I have experienced the same issue with a

Re: DeltaImport problem

2009-09-17 Thread KirstyS
;>                        inner join CmsArticleArticleCollection aac >>>>>> (nolock) >>>>>> on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId >>>>>&

Re: DeltaImport problem

2009-09-16 Thread Noble Paul നോബിള്‍ नोब्ळ्
                       inner join CmsArticleArticleCollection aac >>>>> (nolock) >>>>> on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId >>>>>                        inner join CmsArticle a (nolock) on >>>>> aac.CmsArti

Re: DeltaImport problem

2009-09-16 Thread KirstyS
null or a.LiveEdit = 0) >>>>                         and aac.SourceCmsArticleArticleCollectionId is >>>> null >>>>                                                 and (LastUpdateDate > >>>> '${dataimporter.last_index_time}' >>>

Re: DeltaImport problem

2009-09-16 Thread Noble Paul നോബിള്‍ नोब्ळ्
d aac.SourceCmsArticleArticleCollectionId is >>> null >>>                                                 and (LastUpdateDate > >>> '${dataimporter.last_index_time}' >>> OR a.CreationDate > '${dataimporter.last_index_time}')" >

Re: DeltaImport problem

2009-09-16 Thread KirstyS
he other date >> fields. To no avail. My Full Import works perfectly but I cannot get the >> command=delta-import to pick up the updated records. The LastUpdateDate >> is >> being updated. When I run this in the debug interface with delta-import >> it >>

Re: DeltaImport problem

2009-09-16 Thread Noble Paul നോബിള്‍ नोब्ळ्
> command=delta-import to pick up the updated records. The LastUpdateDate is > being updated. When I run this in the debug interface with delta-import it > just never calls the delta import. > Please, if anyone knows what I am doing wrong??? > Many thanks > Kirsty > -- >

DeltaImport problem

2009-09-16 Thread KirstyS
: http://www.nabble.com/DeltaImport-problem-tp25471596p25471596.html Sent from the Solr - User mailing list archive at Nabble.com.