Hi,

you need to create new search type and place your textarea field in the search tab. You could also replace it with smaller text box and set this new fields storage to the same setting as it is set to in textarea field.

Hi Klas,

I appreciate your answer.

Since in the search page on my site I'm already using a Search Type called "Search" I tried to follow your guidelines by adding a new field (called "Free Search") that these are its details:

Type: textarea

Rows: 1,

Columns: 25,

Storage (I used the exact storage info like the original field that I want to search whithin): Standard - Article - servicedescription.

I didn't mark anything in Alter field.

Results: In my search page on my site, this field didn't work when I searched for keywords that exist like: "humor" (when searching for a lecture about humor). More over, the text area spread on 5 row instaed of 1 row.

I hope you could help me.

Many thanks,

Ofer.

You also need to set the right matching (button 3 on the right), for your case it should be Permissive or Any words (if you with to search for articles that contain any of the words user searches for, not exact phrase). Instead of using textare I would recommend that you use Text as textarea is usually too big for searches.

Thanks. I changed it to text and it looks much better, but it doesn't do search. Meaning that when choosing Permissive or Any word doesn't give any result. I'm almost sure that I did somthing wrong in the Storge section.

What might it be?

Thank you very much.

Hi,
Yes, you're certainly right about the storage. At first always enable the debug mode on your search type if you find some issue and copy paste the SQL query displayed in your forum post.

To create what we call an "alias" of another field you must create this field by using the field manager (this field must not be linked to a content type but must be an independant field). To check this be sure after created your field that there is no message displays near the "storage" of your field such as "linked to a content type". 

Please post a screenshot of your alias field configuration.

Thanks Klas.

I have a few questions:

1. How do I enable the debug option?

2. How do I get to the Field Manager? 

3. How do I create an alias field? What are the steps?

Thank you very much for your help.

Ofer :)

Hi,

1. this is done in your search type configuration tab

2. field manager is in the left menu when you are in seblod component (Fields), you can find it also in Construction admin menu.

3. Alias field is a field using exactly the same storage as your original field, this way you can e.g. use a different type field in search than it is used in form

Thank you webcastor and Klas.

This is the SQL query that I get:

And you can also see how it looks like in the image attached.

My purpose all along was to create a line of text that will allow visitors to search within the database. What I tried to do here is to create an alias field that will search withing another field's data.

This is the ORIGINAL field:

This is the ALIAS field (that searches withing the original):

(am I uploading the images correct?)

Thank you very much,

Ofer.

Hi,

i might be my advice was a bit wrong - try deleting alias field and recreate it within your search type with padlock closed, I think what is happening is that field is searching within wrong table as when padlock is closed table is #__cck_store_form_CONTENTTYPENAME while if it is open like in your alias fields case table is #__cck_store_item_CONTENTTYPENAME - as you can see in your query it is looking at second one (see first join) while it probably should be looking at first.

Great :) 

I just didn't understand how do create a field with a closed padlock in my "Search" (Search Type)?

Many thanks,

Ofer.

Sorry, I missed there is no padlock in search - you need to go to your form and create new field there while having padlock closed (small paddlock on the top right side of the fields list). As new field is auto added to the content type you will need to remove it, then go to the search type and add it from the list of fields.

Will the new field have to use the same storage as the original field (whom i want to search within)?

Thanks :)

Of course it will have to use the same storage as the original field. The fields in SEBLOD are visual representation (on screen) of the data located in storage (database table columns), while containing the logic necessary to make it all work. Many fields can be bound (correspond to) a single table column. Even more so if you use Custom storage, when values are technically treated as different (based on attribute), but that is not the case in this matter.

However, it's important to remember the context, which in this case is Content Type. Since in your case your "context" is exclusive to content type, it have to be searched (referenced) as such.