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