Hello.
I want to display a list view with items that have a date field todat. I have added a field calendar with default value now ( http://prntscr.com/iyv9xl )
I want to display the items of today +1day more... but i don't understand why doesn't show me the results of today.
My form contains 3 fields:
1. Camere libere - it's a radio button with Yes and No value
1. Date -field calendar with default value now ( http://prntscr.com/iyv9xl ) - this is filled by Article modified field.
2. Article modified - to have latest date modified.
Settings of my search list:
http://prntscr.com/iyvc8f - Live settings
http://prntscr.com/iyvcio - Match settings
In my search list i want to display items with radio value YES and date - today +1day more. I did this but i don't understand when i edit an item, it doesn't show me in this search list. Did i miss something?
To search by article modified you need to set your field to the same storage as article modified, right now it searches in data_camera_libera database column. You can activate debugging in the search type to see exactly what query your search produces.
I changed the "camere_libere" from Match -> Permissive to None and now i see results... but i don't understand why doesn't show me the results when i refresh the date midified.
SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS author,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias
FROM `#__cck_core` AS t0
LEFT JOIN `#__cck_store_form_unitate` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__content` AS t2 ON t2.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t2.state = 1
AND t2.access IN (1,1,2,3,6,7)
AND ( t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2018-04-04 18:10' )
AND ( t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down >= '2018-04-04 18:10' )
AND t0.cck = 'unitate'
AND t1.data_camera_libera >= '2018-04-04 00:00:00'
ORDER BY t2.title ASC
LIMIT 50
0.004 seconds (0.004); 17.95 MB (17.949) - afterSearch [Cache=OFF] = 3 results.
0.059 seconds (0.055); 20.50 MB (2.556) - afterRender [Cache=OFF]
As I wrote - if you want to filter by modified date you need to use Article Modified field, not your custom field (or change storage in your field to the same setting as article modified field).
Yes, thank you! :)