Searching records list by updatedDate

Hey, Jerry.

I was able to do this after adding the following search field for a specific section:

    Updated Date|updatedDate|query

Then on the list page, I entered YYYY-MM-DD into the "Updated" search field. (Replace YYYY-MM-DD with actual date to search for.)

Hope that works for you.
Deborah

Hi Deborah,

Thanks for the suggestion.

When I replaced _all_ with your suggested search criteria, it allowed me to search on updatedDate

But, when I tried adding Updated Date|updatedDate|query to new line in the search, that didn't work. 

So it seems that, unless I'm doing something wrong, the search is limited to either the new Updated Date|updatedDate|query criteria or _all_ but not both.

Is that your finding as well?

Jerry Kornbluth

Jerry,

I was able to add that field in addition to _all_. (CMSB ver 3.53.)

My search fields are:

    _all_
    Client|client|match
    Due|date_due|match
    Updated Date|updatedDate|query

Maybe the order the fields are listed has some bearing? Try putting updatedDate last in the list. Also refresh the list page search by clicking "show all" after making changes to the list, before testing.

Deborah

Thanks for  getting back, Deborah.

I'll give it a try.

Enjoy the weekend,

Jerry

Hi Deborah,

Couldn't get it to work in 3.54 with more than one line in the search criteria tab.

Not sure why.

Based on the other post, I changing the updatedDate 'type' entry in the schema file from 'none':

'updatedDate' => array(
'order' => '4',
'type' => 'none',
'label' => 'Last Updated',
'isSystemField' => '1',
),

to 'textfield':

'updatedDate' => array(
'order' => '4',
'type' => 'textfield',
'label' => 'Last Updated',
'isSystemField' => '1',
),

That allowed me to keep the search criteria as _all_ and search for specific updatedDates with the format yyyy-mm-dd hh:mm:ss or any portion of that format (like year only or day only, etc.)

I've created new records and modified and deleted old ones with no unexpected errors, but I'd still like a programmer from Interactive Tools to weigh in on this just in case I missed something.

Any thoughts?

Best,

Jerry Kornbluth

Hi Jerry,

Would you be able to submit a second level support request for this? https://www.interactivetools.com/support/request/

We would like to take a look and see what's going on. In version 3.54, I am able to have additional lines of search terms after "_all_" without having to change the field type from "none" for "updatedDate" so I'd like to take a look and see what's happening with your install of CMS Builder.

Ideally, we would not want to need to change the field type for default fields. 

I'll keep an eye out for a support ticket from you, and as always, we're happy to help.

Hi All,

Here's an update on the solution to this dilemma.

Seems that Deborah's solution worked all the time.

The issue was that any custom searches end up under the 'more' button, and I was so used to that only showing the per page dialog, that I never looked there.

Thanks to Jenna Cooke for pointing this out and solving the problem.

The search criteria in the section editor that I ended up with which allowed both text searches in the main search field and date searches for updatedDate was:

_all_
Updated Date|updatedDate|query

Hope that helps someone.

Best,

Jerry Kornbluth