Can someone tell me how the "Keywords" field in the "Users" and "Marketplace" areas works for Users? What fields are searched when a word is typed in there? What are the rules governing matches (partial words? full words only?)?
Thanks!
Searching the "Keywords" field
Moderators: hugo, alexandre, rmvanarkel
Re: Searching the "Keywords" field
We use PostgreSQL's full text search for the users and ads search, however, with an user friendly query syntax.
PostgreSQL's native query syntax requires connectors between words, and is very strict. For example: "car london" is translated to "car | london".
The full text process has 2 steps, which use a dictionary matching the language set in the Configuration
Partial matches are not performed, unless the query has an asterisk. Example: eng* would match engineering, england, etc.
The query syntax is:
PostgreSQL's native query syntax requires connectors between words, and is very strict. For example: "car london" is translated to "car | london".
The full text process has 2 steps, which use a dictionary matching the language set in the Configuration
- Removal os stopwords: Words which are too common to mean anything are removed. In English: a, the, and, ... are removed
- Stemming: Words end up with their root only. For example: jumped, jumping, jumpy -> jump
Partial matches are not performed, unless the query has an asterisk. Example: eng* would match engineering, england, etc.
The query syntax is:
- a b: Seach for a OR b
- a +b: Seach for a AND b
- a -b: Search for A AND NOT b
- Also, parenthesis can be used to group words, like (a b) -(c d)
- Full name
- Login name
- Custom fields (marked as allowed for search in the product)
- Title
- Description
- Custom fields
- User's full name
- User's login name
- User's email
- User's custom fields (marked as allowed for search in the product)
Luis Fernando Planella Gonzalez
Cyclos development team
Cyclos development team
Re: Searching the "Keywords" field
Thanks so much for the info, Luis!
Allowing the custom profile fields available in user and ad searches works, but it also creates a problem. These fields now appear in the user search box, underneath the "keywords" search field. This is confusing for our members. We want to have just one search bar showing where people can type in whatever data they are looking for. Is this possible?
We also want to create a custom profile field to be queried in the user search keyword field, but have the field only be visible to the user and our system admin. In this field members would enter any and all words they think someone might use to search for their offerings (for example, a clothing boutique owner might enter sweaters, handbags, belts, coats, etc.) The user wouldn't want this whole field to be shown to other users, they would just want their profile to pop up when people search on those items. Is this possible?
Thanks,
Kelleigh
Allowing the custom profile fields available in user and ad searches works, but it also creates a problem. These fields now appear in the user search box, underneath the "keywords" search field. This is confusing for our members. We want to have just one search bar showing where people can type in whatever data they are looking for. Is this possible?
We also want to create a custom profile field to be queried in the user search keyword field, but have the field only be visible to the user and our system admin. In this field members would enter any and all words they think someone might use to search for their offerings (for example, a clothing boutique owner might enter sweaters, handbags, belts, coats, etc.) The user wouldn't want this whole field to be shown to other users, they would just want their profile to pop up when people search on those items. Is this possible?
Thanks,
Kelleigh
Re: Searching the "Keywords" field
It is already planned for Cyclos 4.4 to separate the setting for a custom field to be included as a search filter and the one for it to be used in keywords. For 4.3 this is not possible.kellmck wrote:Allowing the custom profile fields available in user and ad searches works, but it also creates a problem. These fields now appear in the user search box, underneath the "keywords" search field. This is confusing for our members. We want to have just one search bar showing where people can type in whatever data they are looking for. Is this possible?
We hadn't thought about it, but it can be interesting. When we implement the setting for include a field in keyword search, if possible, we'll make it independent on field visibility, so your suggestion can be achieved.kellmck wrote:We also want to create a custom profile field to be queried in the user search keyword field, but have the field only be visible to the user and our system admin. In this field members would enter any and all words they think someone might use to search for their offerings (for example, a clothing boutique owner might enter sweaters, handbags, belts, coats, etc.) The user wouldn't want this whole field to be shown to other users, they would just want their profile to pop up when people search on those items. Is this possible?
Luis Fernando Planella Gonzalez
Cyclos development team
Cyclos development team
Re: Searching the "Keywords" field
Thanks, Luis. Any idea when 4.4 is slated for release?
Re: Searching the "Keywords" field
We don't have an official release date, but we are planning to release 4.4 between April and May.
Luis Fernando Planella Gonzalez
Cyclos development team
Cyclos development team