DEVELOPERS FORUM - Searching across Properties on an Itemtype

fli - Thursday, April 7, 2011 3:33 AM:

Hi Community,

fli - Friday, April 8, 2011 8:01 AM:

Hi guys,

bump, Can someone help me about this, I would really like a quik answer.

Thanks,

Christoffer

PeterSchroer - Friday, April 8, 2011 8:28 AM:

Hi Christoffer -    If you are writing AML queries,   you should try using an OR.     This is what I used on the Community Projects site for example.  User can type a string,  and I search all Properties for a match.      For example:   the variable named Search has the string the user has typed.    The AML you see below has 2 criteria:    State must be Active   AND(  <description> contains the string   OR    <name> contains the string)   

<Item type='CP_CommunityProject' action='get' select='license,name,rating,description,downloads' order_by='name'><state>Active</state><or><description condition='like'>%" + search + "%</description><name condition='like'>%" + search + "%</name></or></Item>

 Is this what you need?       let me know if you need an example using the IOM instead of making the AML string directly.

--peter

fli - Friday, April 8, 2011 9:22 AM:

Hi Peter,

Thanks for the answer, I see this will take me some of the way.

I thougt maybe there was a solution like when searching the vault, with free text.

I need a search that will allow a search string with several words.

results coming up with #1 having the most hits on the most properties (for each word).

If you can point me in the right direction,

Thanks, Christoffer 

PeterSchroer - Friday, April 8, 2011 9:54 AM:

You would like enterprise search....  some strings searched across all the properties,  with a ranking of the results.

There are 2 solutions already available from Aras partners  (Northridge and Vdr Group).      Both will be demonstrated at the ACE meetings in April    Http://www.aras.com/ACE2011  

You can contact Mike Turcotte at  Northridge   [email protected]     for more information about their solution for Search (and a demo), which is based on the open source search engine Lucene.

--peter

fli - Friday, April 8, 2011 10:11 AM:

Peter,

Thanks thats isperfect.

BR/ Christoffer

Mike T - Tuesday, May 3, 2011 10:05 AM:

Christoffer,

I just replied to an email from Erik.

NorthRidge Software just released Discover Innovator - Community edition. This is a freely available search solution that has been integrated into Aras Innovator. I have offered to provide you with a demo at your convenience.

Thanks, Mike