Chronoconnectivity v5 how to add search field

Hello
how to add a search field at front end that show at the top like pagination?

Hi Qbik,

in the header area, add a normal input box, its name should be "srch", you should also list the columns to be searched in the "searchable" box in the admin area.

Regards,
Max

hi, i try to add a search box like you worte.
1. mu model name is "tel"
2. i insereted in the searchable box these fields:
tel.nome
tel.cognome
tel.telefono
3. i inserted in the header of the front list this code:
<b>Cerca:</b> <input type="text" name="srch" />

is it right? because when i insert a value in the field and press enter i have an empty pop-up window.
thank you
Mauro

Hi Mauro,

That looks fine to me, please enable the debug setting and post the sql queries shown at the search page ?

Regards,
Max

The search field doesn't work me either... The header code box has:

<input style="height:25px;" type="text" name="srch" />

and the Searchable box has the field listed as field.name. Here's what I get:

Array
(
    [0] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `table_chronoengine_extensions` AS `Extension` WHERE `Extension`.`enabled` = '1' ORDER BY `Extension`.`ordering` ASC
    [1] => SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` FROM `table_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'fields' AND `Connection`.`published` = '1'
    [2] => SELECT `field`.`id` AS `field.id`, `field`.`name` AS `field.name`, `field`.`label` AS `field.label`, `field`.`field_size` AS `field.field_size`, `field`.`description` AS `field.description`, `field`.`ordering` AS `field.ordering`, `field`.`published` AS `field.published`, `field`.`required` AS `field.required`, `field`.`values` AS `field.values`, `field`.`type` AS `field.type`, `field`.`selected` AS `field.selected`, `field`.`rows` AS `field.rows`, `field`.`cols` AS `field.cols`, `field`.`fee_field` AS `field.fee_field`, `field`.`fees` AS `field.fees`, `field`.`new_line` AS `field.new_line`, `field`.`textual` AS `field.textual`, `field`.`export_individual` AS `field.export_individual`, `field`.`export_group` AS `field.export_group`, `field`.`attendee_list` AS `field.attendee_list`, `field`.`usagelimit` AS `field.usagelimit`, `field`.`fee_type` AS `field.fee_type`, `field`.`filetypes` AS `field.filetypes`, `field`.`upload` AS `field.upload`, `field`.`filesize` AS `field.filesize`, `field`.`hidden` AS `field.hidden`, `field`.`group_behave` AS `field.group_behave`, `field`.`allevent` AS `field.allevent`, `field`.`showed` AS `field.showed`, `field`.`maxlength` AS `field.maxlength`, `field`.`date_format` AS `field.date_format`, `field`.`parent_id` AS `field.parent_id`, `field`.`selection_values` AS `field.selection_values`, `field`.`textareafee` AS `field.textareafee`, `field`.`showcharcnt` AS `field.showcharcnt`, `field`.`default` AS `field.default`, `field`.`confirmation_field` AS `field.confirmation_field`, `field`.`listing` AS `field.listing`, `field`.`textualdisplay` AS `field.textualdisplay`, `field`.`applychangefee` AS `field.applychangefee`, `field`.`tag` AS `field.tag`, `field`.`all_tag_enable` AS `field.all_tag_enable`, `field`.`minimum_group_size` AS `field.minimum_group_size`, `field`.`max_group_size` AS `field.max_group_size`, `field`.`discountcode_depend` AS `field.discountcode_depend`, `field`.`discount_codes` AS `field.discount_codes` FROM `table_ok_fields` AS `field` WHERE `field`.`id` = ''
)

Also, I noticed that the url changes to this: /administrator/index.php?option=com_chronoconnectivity5&cont=lists&act=edit&ccname=fields

Thanks.

Hi Dan,

Just tested this in both admin and front listings and they work as expected, does your header box have nay other code ?

The url change is also weird, do you have a table or custom list ? did you insert any form tags any where ?

How do you load the connection ?

I tested using a table list and using the view link in the CC admin page!

Regards,
Max

1. Here's my header box code:

<h3>Events</h3> 
<div style="float:right;"><strong>Search: </strong> <input style="height:25px;" type="text" name="srch" /></div><br />
<strong>Filter: </strong> 
<input style="height:25px;" type="text" name="fltr[event][title]" />
<br />
   _TOOLBAR_NEW_
    _TOOLBAR_DELETE_
    _TOOLBAR_SAVELIST_
    _TOOLBAR_CANCEL_
    _TOOLBAR_SAVE_
    _TOOLBAR_APPLY_
_PAGINATOR_LIST_
_PAGINATOR_NAV_

2. No form tags anywhere.
3. I tested using a table list and the view link in the CC admin page as well...
By the way, the filter option doesn't work either. Same output, blank screen and the url change.

Thank you

Hi Dan,

I found a small glitch and fixed it, but for now you an simply add a "submit" button before the toolbar buttons code and that should submit the search/filter data correctly.

Regards,
Max

Thanks, Max.
It works fine now.

Have a great day!

I followed the guidelines suggested here but does not worked, someone help me?

Hi julio.gomes,

Please start a new thread and tell us exactly what you have done. It is impossible to help you when the only information you give is 'It doesn't work'.

Bob

This discussion worked greatly for me! I was able to get a nice looking search bar at the top of my custom list!

Thanks a bunch! 😀

Is there documentation of the TOOLBAR statements? I didn't need them because this is for visitor searching only, not any sort of management. But, they look very interesting!

Great job once again guys! You are awesome!

Jennifer

Hi Jennifer,

All the toolbar functions are written under the help tab, what are you trying to do exactly ?🙂

And I suggest starting a new topic since this topic is about the search field!😉

Regards,
Max

Hi Max,

No problems here! I just wondered about the TOOLBAR, but that I know where to look, don't worry about it!. Everything is working perfectly and I was able to get a search feature hooked up. My client is very happy now! Nothing but compliments!

Thanks!

Jennifer