**NAS_DB_OBJECTS** rs_TasksToday.prg_tasks.timestampfield02, 1, timestampfield, 3, 1 rs_TasksToday.prg_tasks.intfield01, 2, int8, 3, 1 rs_TasksToday.prg_tasks.field01, 3, text, 3, 1 rs_TasksNew.prg_tasks.intfield01, 1, int8, 3, 1 rs_TasksNew.prg_tasks.field01, 2, text, 3, 1 rs5.prg_dates.cDate, 1, timestampfield, 3, 1 rs5.prg_dates.timestampfield01, 2, timestampfield, 3, 1 rs5.prg_dates.timestampfield02, 3, timestampfield, 3, 1 rs5.prg_dates.intfield01, 4, int8, 3, 1 rs5.prg_dates.field01, 5, text, 3, 1 rs6.prg_projects.field01, 1, text, 3, 1 rs6.prg_projects.intfield01, 2, text, 3, 1 rs7.prg_projects_milestones.object_id, 1, int8, 3, 1 rs7.prg_projects_milestones.sid, 2, int8, 3, 1 rs7.prg_projects_milestones.title, 3, text, 3, 1 **NAS_DB_OBJECTS** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT timestampfield02, intfield01, field01 FROM prg_tasks** **NAS_WHERE = WHERE ((date(timestampfield02) <= 'today' AND field05 < 100) AND ((fid = -1 AND intfield01 IN (SELECT object_id FROM prg_tasks_members WHERE member_uid LIKE '|**NAS_USER**|')) OR fid IN (SELECT pid FROM oxfolder_permissions WHERE (orp >= 4 AND (role = 256 AND entity LIKE '|**NAS_USER**|' OR role = 32768 AND entity LIKE '|**NAS_USER**|' OR role = 512 AND entity IN (|**memberingroups**|)) OR (orp = 2) AND prg_tasks.created_from LIKE '|**NAS_USER**|' AND (role = 256 AND entity LIKE '|**NAS_USER**|' OR role = 32768 AND entity LIKE '|**NAS_USER**|' OR role = 512 AND entity IN (|**memberingroups**|))))))** **NAS_ORDER = ORDER BY timestampfield02 ASC, field04 DESC** **NAS_MR = 25** **NAS_NFC = 25** **NAS_SQL_OBJECTS NAME=rs_TasksToday** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT intfield01, field01 FROM prg_tasks** **NAS_WHERE = WHERE ((date(creating_date) >= 'today' AND creating_date <= date(|**sysdate**|) + |**TaskDays**|) AND ((fid = -1 AND intfield01 IN (SELECT object_id FROM prg_tasks_members WHERE member_uid LIKE '|**NAS_USER**|')) OR fid IN (SELECT pid FROM oxfolder_permissions WHERE (orp >= 4 AND (role = 256 AND entity LIKE '|**NAS_USER**|' OR role = 32768 AND entity LIKE '|**NAS_USER**|' OR role = 512 AND entity IN (|**memberingroups**|)) OR (orp = 2) AND prg_tasks.created_from LIKE '|**NAS_USER**|' AND (role = 256 AND entity LIKE '|**NAS_USER**|' OR role = 32768 AND entity LIKE '|**NAS_USER**|' OR role = 512 AND entity IN (|**memberingroups**|))))))** **NAS_ORDER = ORDER BY timestampfield02 ASC, field04 DESC** **NAS_MR = 25** **NAS_NFC = 25** **NAS_SQL_OBJECTS NAME=rs_TasksNew** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT timestampfield01 AS cDate, timestampfield01, timestampfield02, intfield01, field01 FROM prg_dates** **NAS_WHERE = WHERE ((date(creating_date) >= 'today' AND creating_date <= date(|**sysdate**|) + |**AppointmentDays**|) AND ((fid = -1 AND intfield01 IN (SELECT object_id FROM prg_dates_members WHERE member_uid LIKE '|**NAS_USER**|')) OR fid IN (SELECT pid FROM oxfolder_permissions WHERE (orp >= 4 AND (role = 256 AND entity LIKE '|**NAS_USER**|' OR role = 32768 AND entity LIKE '|**NAS_USER**|' OR role = 512 AND entity IN (|**memberingroups**|)) OR (orp = 2) AND prg_dates.created_from LIKE '|**NAS_USER**|' AND (role = 256 AND entity LIKE '|**NAS_USER**|' OR role = 32768 AND entity LIKE '|**NAS_USER**|' OR role = 512 AND entity IN (|**memberingroups**|))))))** **NAS_ORDER = ORDER BY timestampfield01, timestampfield02 ASC** **NAS_MR = 20** **NAS_SQL_OBJECTS NAME=rs5** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT field01, intfield01 FROM prg_projects** **NAS_WHERE = WHERE (((timestampfield03 <= 'today') AND (field05 NOT LIKE 'DONE' AND field05 NOT LIKE '100')) AND ((user_right LIKE '|**NAS_USER**|' AND group_right LIKE 's') OR (group_right LIKE 'g' AND intfield01 IN (SELECT object_id FROM prg_projects_members WHERE member_uid LIKE '|**NAS_USER**|'))))** **NAS_ORDER = ORDER BY timestampfield01, timestampfield02 ASC** **NAS_MR = 400** **NAS_NFC = 25** **NAS_SQL_OBJECTS NAME=rs6** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT object_id, sid, title FROM prg_projects_milestones** **NAS_WHERE = WHERE (((timestampfield01 >= 'today') AND (timestampfield01 <= date(|**sysdate**|) +3 )) AND prg_projects_milestones.sid IN (SELECT prg_projects.intfield01 FROM prg_projects WHERE prg_projects_milestones.sid = prg_projects.intfield01 AND (prg_projects.field05 NOT LIKE 'DONE' AND prg_projects.field05 NOT LIKE '100' AND prg_projects.user_right LIKE '|**NAS_USER**|' AND prg_projects.group_right LIKE 's') OR (prg_projects.group_right LIKE 'g' AND prg_projects.intfield01 IN (SELECT object_id FROM prg_projects_members WHERE prg_projects.intfield01 = prg_projects_members.object_id AND member_uid LIKE '|**NAS_USER**|'))))** **NAS_ORDER = ORDER BY timestampfield01 ASC** **NAS_MR = 400** **NAS_NFC = 25** **NAS_SQL_OBJECTS NAME=rs7** Groupware - **OX_APP_TITLE**
   Обзор       Текущее    
 
 **ACTDATE**  
**PINBOARD-REPEAT**
 Сегодня    Новое
Встречи:
  **magicAppointments**
**NAS-REPEAT NAME=rs_TasksToday** **NAS-REPEAT NAME=rs_TasksToday**
Задачи:
  **rs_TasksToday.prg_tasks.field01** 
**NAS-REPEAT NAME=rs6** **NAS-REPEAT NAME=rs6** **NAS-REPEAT NAME=rs7** **NAS-REPEAT NAME=rs7**
Проекты:
  **rs6.prg_projects.field01**
  **rs7.prg_projects_milestones.title** 
 
Почта:
  **mailcheck**
**NAS-REPEAT NAME=rs5** **NAS-REPEAT NAME=rs5**
Встречи:
**rs5.prg_dates.cDate** **rs5.prg_dates.timestampfield01**  **rs5.prg_dates.field01** 
**NAS-REPEAT NAME=rs_TasksNew** **NAS-REPEAT NAME=rs_TasksNew**
Задачи:
  **rs_TasksNew.prg_tasks.field01**
 
Сборка: **build_number**
Powered by http://www.open-xchange.org