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 visit www.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
-~----------~----~----~----~------~----~------~--~---
