Hello,
I would like to search between two dates using JCckContentArticle search method. Using:
$content = new JCckContentArticle;
$data = array( 'catid'=>2, 'state'=>1 );
$content->search( $content_type, $data );
I tried:
$content->with( 'created', '>=', '2018-09-01' );
$content->with( 'created', '<=', '2018-09-15' ); // Shows only <= 2018-09-15. The second 'with' replaces the first. There is no "And"
Then I tried:
$content->with( 'created', 'between', '2018-09-01', '2018-09-15'); // Error 1064 -> in the SQL syntax
$content->with( 'created', 'between', '2018-09-01', 'and', '2018-09-15'); // Error 1064 -> in the SQL syntax
I was trying 'between' operator I read in the Changelog, but I have no idea how:
---------------- 3.21.5 Upgrade Release [03-Dec-2021] --------------
+ "between" operator support added on JCckContent find/search methods.
Anybody knows how I can write this 'between' operator.
Thanks,
Narciso.
Using Seblod 4.0.1 and Joomla! 4.2.6