lucene query not work

[scot84]

I made a query to search a space that have a custom attribute named "office".
I want to made a 'like' query.

The value of attribute of the node in the repository is "SALES DEPARTMENT".

If I search with this query:

PATH:"/app:company_home/cm:Prat/*/*" AND TYPE:"{custom.model}prat" AND @custom\:office:*SAL*‍

RETURN  1 ROW

PATH:"/app:company_home/cm:Prat/*/*" AND TYPE:"{custom.model}prat" AND @custom\:office:*SALES*‍

RETURN 0 ROW

PATH:"/app:company_home/cm:Prat/*/*" AND TYPE:"{custom.model}prat" AND @custom\:office:*SALES DEPARTMENT*‍

RETURN 0 ROW

I have tried also without '*' but with no luck.
What i'm wrong !!!!

[rafaelscg]

Scot,

I dont know if this is the answer, but try to put te letter "L" in uppercase:

PATH:"/app:company_home/cm:Prat/*/*" AND TYPE:"{custom.model}prat" AND @custom\:office:*SALES*‍

Maybe the problem ir the CASE SENSITIVE letter.

[scot84]

Sorry, Rafael the "l" in lowcase is a typing error.

[mitpatoliya]

If you want to search the phrase you need to put it under double quote
something like this
PATH:"/app:company_home/cmrat/*/*" AND TYPE:"{custom.model}prat" AND @custom\ffice:"SAlES DEPARTMENT"

[scot84]

Thanks it worked