Hi Eric, Thank You very much for the reply. I definitely gave a thought for that approach but the issue we face is we have more than 1 companyname tag in the same document.
having xml like this : <CompanyName>Cisco</CompanyName> <CompanyName>British Telecom</CompanyName> <CompanyName>SunCor</CompanyName> The issue I am facing with this approach is , I cannot use the verity language options Starts,Matches and Contains(SubString). When i map CompanyName tag as a field, Then it is being saved as CompanyName : Cisco <> British Telecom <> SunCor Because of this the VQL Query : CompanyName <Starts> Cisco only will give me this result. CompanyName <Starts> British or CompanyName <Starts> Sun will fail to give me this document as a result. Matches will not work at all. My other option would be: <CompanyName1>Cisco</CompanyName1> <CompanyName2>British Telecom</CompanyName2> <CompanyName3>SunCor</CompanyName3> But this will make my Search Query Lengthy. Can you suggest any other option by which i can acheive this. Thanks in Advance, Swapna. ----- Original Message ----- From: "Eric Koleda" <[email protected]> To: "RedDot CMS Users" <[email protected]> Sent: Saturday, August 22, 2009 7:17 AM Subject: Re: LiveServer Date and Attributes Search 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 -~----------~----~----~----~------~----~------~--~---
