Filter several fields at once

Hi

How can I filter several fields in a table in one operation? The built in search can filter only one field at a time. Will a custom search form do the job? Then how do I 'merge' a form with a connection? What is "form event name" in Search form Event?

I've not been able to find any other posts with a proper solution.

Thanks a lot,
Roger

Hi Roger,

The good news is that it is possible, the FAQs page here uses multiple filters in a ChronoForm.

The bad news is that I'd have to go back to work out how it is set up :-( Max did the original set up, then I have extended and modified it. Must be a case study here somewhere.

Here's a quick summary from looking at the setup as I write.

There's a single listing and a form. Both are linked by the KnowledgeBase application.

The Form is called KnowledgeBase and is in the KnowledgeBase Forms App group.

The form has multiple events but the key one here is called 'On list' and contains the Form Show HTML action (plus some CSS & JS) and a ChronoConnectivity Task action with the Task option set to 'List Data'.

On the CC side the Listing is also called KnowledgeBase and is in the KnowledgeBase Connections App group.

On the Listing General | Advanced tab the Forms App is set to KnowledgeBase.

On the Frontend List Settings | Search Settings tab Enable Search is set to yes and the Search Field Name and Search Button Name match the names in the ChronoForm. Show Search Box is set to 'No'.

I can add more if it helps but these seems to be the main links between the two . . .

Bob

Hi,

The built in search can filter only one field at a time

No, you can add a list of fields to the search fields names box, and all of them will be queried for your search string!

Regards,
Max

No, you can add a list of fields to the search fields names box, and all of them will be queried for your search string!

If one field in the table is 'firstname' and another is 'lastname' you can search on either "John" or "Doe". If you put "John Doe" in the search box you get no hits.

Roger

I have followed all the steps, but I can not see the search form created with ChronoForm. Can you help? Thanks in advance.

Hi Roger,

Exactly, since it searches for "John Doe", the whole string, but under all columns, it doesn't split them to "John" and "Doe".

@apollonia, did you setup the permissions for the search box ? they are under the search section, also please start a new topic for that since this is a different issue you have.

Regards,
Max

despite having followed all the steps I can not see the form, I see the list of all the records. In short, I can not figure out where I'm wrong. Could you enlighten me? Thank you in advance.

Ok, please start a new topic and explain the problem in details, screenshots may help too!

Regards,
Max

I could not find where to create a new topic.I apologize if I continue to post here.I have attached the screenshot of my situation.
Can you tell me where I'm wrong?
I also added a menu item associated with the form in chronoform, my doubt is I have to associate it with the commessione of chronoconnectivity
I repeat my request. Customize your search using a form with fields to search, and free of chronoform of chronoconnectivity.
Thanks in advance.

Hello,

Under the "Frontend Editing" tab, did you select your form and write "8" in the "Listing task handler" box ?

Also, you only want to search and filter your listing using some fields ? if yes then I have a completely new Connectivity which can help you do this, you may contact me through the "Contact us" page for a beta installer.

Regards,
Max

On the Frontend List Settings | Search Settings tab Enable Search is set to yes and the Search Field Name and Search Button Name match the names in the ChronoForm. Show Search Box is set to 'No'.

I can add more if it helps but these seems to be the main links between the two . . .

Bob

Please could you clarify the Search Field Name and Search Button Name?

I'm trying to understand this based on my CF form that I'm using on the date range tutorial and to get a listing.

I clicked the CC form and it shows up with the the two date fields (Start Date and End Date and Submit button created in CF) and a list of records (auto listing in CC) prepopulated onto the screen ( I really wanted to have no listing to appear until I hit the Submit button!). I enter the dates in and nothing happens! 😟 I'm not sure how to get the Submit button to search the dates and show all the dates within the range I entered. By the way with the datepicker icon tutorial - it shows up ok in just the CF but not when I click CC form - why's that? 🤨

If you have some other better route for me to take in order to get a listing based on the date range I enter then I'm open to suggestions. 🤣

Hope I've explained it OK with the above and I appreciate and thank you for your time and patience in reading this and look forward to hearing from you soon.🙂

Kind regards

Bionic Nelly

Hi Bionic Nelly,

Please could you clarify the Search Field Name and Search Button Name?

The values in those boxes in CC match the input names in the form. I think that is all.

I really wanted to have no listing to appear until I hit the Submit button

We've talked about this before. If I remember correctly the answer is to add a WHERE clause that returned a false statement like WHERE 1 = 2 unless search values are set.

the datepicker icon tutorial - it shows up ok in just the CF but not when I click CC form - why's that?

Sorry, no idea, what do you see in the JavaScript Console?

I'm not sure how to get the Submit button to search the dates and show all the dates within the range I entered.

It's not going to be drop-dead simple, you have to get the two dates entered in your form; make sure that they are formatted in a way that MySQL can read and put them into a suitable WHERE clause. The Debugger in CC is your friend here; it will show you what data you have and what query is being created from it.

Bob