Hi Swapna, You sure packed a lot of questions into one post, you might want to split them up next time. I won't address everything, but I have some points:
1) When you are mapping your content attribute to a verity field, set the type as Date and not String. This allows Verity's automatic date processing to come in and makes the greater than and less than functionality work. Verity understands most date formats, but if it doesn't work for yours out of the box I think you can configure it. 2) Why not just map the these values to verity fields? Searching in attributes of specific tags isn't easy, verity fields are much easier to work with. 3) If you can't map the values to attributes, can you control the tag format? Instead of <Info Name="CompanyName" Value="Cisco"/> try <CompanyName>Cisco</CompanyName>. This would allow you to do "Cisco" <IN> CompanyName in your query. Best, - Eric On Aug 3, 5:47 am, swapna parsavedi <[email protected]> wrote: > Hi all, > > I am having some problems with verity search and thought you guys can guide > me. > I am having issue w.r.t searching some news releases by date. problem being > the date is saved in ISO:8601 Format in the news release. I can convert the > date zone into a field by changing verity config files for arithemtic > operations but > (29-04-2009, 12:41) transforms into (20090429T124100-0400) IN ISO Format. > > Even though Verity has arithmetic operations to work on date, they do not > work in this case as this is a string. I can use string manipulations to get > news releases for a particular day but cannot figure out how to get news > releases between a date range. Can anyone please help me on how i can > approach this. > > One other thing is : > I need to Search within attributes as they have important information > related to a release as part of attributes. > <Info Name="CompanyName" Value="Cisco"/> > <Info Name="GeographyCode" Value="California"/> > <Info Name="Contact" Value="please visitwww.cisco.com"/> > <Info Name="Version" Value="1.1"/> > <Info Name="Category" Value="a"/> > > So, I cant figure out a way to search for Value attribute only corresponding > to the Name attribute. > > I worked on various formats : > a. Value <CONTAINS> Cisco : this works but If a user searches Value > <CONTAINS> California ,Value <CONTAINS> 1.1 and even Value <CONTAINS> a , > this document comes up as a result which should not be the case. > > b. * <IN> Info <WHEN> (Name <Contains> CompanyName <AND> Value > <CONTAINS> Cisco) > The same thing is happening in this case also. What is happening is It is > searching in all the Attribute Name Values for CompanyName and in all The > Value attributes for Cisco. > So this document comes up as a result even if the search query is > * <IN> info <WHEN> (Name <Contains> CompanyName <AND> Value <CONTAINS> > California) or > * <IN> info <WHEN> (Name <Contains> CompanyName <AND> Value <CONTAINS>1.1) > > c. * <IN> //in...@name='CompanyName'] WHEN (Value <CONTAINS> Cisco) . > I thought this was definitely supposed to work but i have no idea why it is > not working. > > * <IN> //in...@name] WHEN (Value <CONTAINS> Cisco) ---- This works > completely fine but i get the same result for > * <IN> //in...@name] WHEN (Value <CONTAINS> California) or * <IN> > //in...@name] WHEN (Value <CONTAINS> 1.1) > > I am currently running out of options and was hoping if any of you would > help me out. Any advice on any one of them would be extremely helpful. I am > thinking that option 3 must work but cannot understand the logic why its not > working. > > Please do reply, > > Thanks in Advance, > Swapna. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/reddot-cms-users?hl=en -~----------~----~----~----~------~----~------~--~---
