Hi, have you tried
//element(*, hfs:file)[jcr:contains(., 'testing')]/(@hfs:description | @hfs:formname) BR, Savvas 2009/9/11 Michael Shoener <[email protected]> > I am trying to figure out the correct Xpath query for the following SQL > query: > > SELECT hfs:description, hfs:formname FROM hfs:file WHERE CONTAINS(., > 'testing') > > The above query returns all records where either the hfs:description or > hfs:formname contains the value "testing". > > I tried the following in Xpath but it does not work: > > //element(*, hfs:file)/(@hfs:description | > @hfs:formname)[jcr:contains(., 'testing')] > > > What am I missing in my query to make it not return any records? > > > Best Regards, > > Michael Shoener > Support Staff > Software Application Services, Inc. > > >
