1

I am trying to use contains in Nuxeo , I want to search in all the metadata and title and content of the asset

Example If I search

ten

then the search result must return

Content22Jan.jpg

tent24.jpg

. when I use

select * from table where columnName like 'Con*'

I get the expected response

But If I do

select * from table where columnName like '*ten*'

the search does not return any result

Even

select * from table where columnName like '%ten%'

the search does not return any result Can someone tell me how to use contains .Even if I pass part of string I should get all the results which matches the search string

Swathi
  • 156
  • 1
  • 2
  • 11

1 Answers1

2

Try this:

SELECT * FROM table WHERE dc:columnName LIKE '%ten%'

Read this

Nickname_used
  • 430
  • 3
  • 18