**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
rs_MilestonesToday.projects_milestones.id, 1, int, 3, 1
rs_MilestonesToday.projects_milestones.mdate, 2, timestampfield, 3, 1
rs_MilestonesToday.projects_milestones.name, 3, text, 3, 1
rs_MilestonesToday.projects_milestones.intfield01, 4, int, 3, 1
rs_MilestonesToday.projects_milestones.id, 1, int, 3, 1
rs_MilestonesToday.projects_milestones.mdate, 2, timestampfield, 3, 1
rs_MilestonesToday.projects_milestones.name, 3, text, 3, 1
rs_ProjectReminderToday.projects.intfield01, 1, int, 3, 1
rs_ProjectReminderToday.projects.project_name, 2, text, 3, 1
rs_ProjectReminderToday.projects.project_reminder, 3, timestampfield, 3, 1
rs_ProjectReminderToday.projects.fuid, 4, int, 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) <= |**sql_today**| AND int4(field05) < 100) AND ((fid = -1 AND intfield01 IN (SELECT object_id FROM prg_tasks_members WHERE intfield01 = object_id AND member_uid LIKE '|**NAS_USER**|')) OR fid IN (SELECT pid FROM oxfolder_permissions WHERE fid = pid AND (orp >= 4 AND (role = 256 AND entity LIKE '|**NAS_USER**|' OR role = 32768 AND entity LIKE '|**NAS_USER**|' OR (role = 512 OR role = 65536) 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 OR role = 65536) AND entity IN (|**memberingroups**|)))) AND intfield01 IN (SELECT object_id FROM prg_tasks_members WHERE intfield01 = object_id AND member_uid LIKE '|**NAS_USER**|')))**
**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) >= |**sql_today**| AND date(timestampfield01) <= date(|**sysdate**|) + |**TaskDays**|) AND ((fid = -1 AND intfield01 IN (SELECT object_id FROM prg_tasks_members WHERE intfield01 = object_id AND member_uid LIKE '|**NAS_USER**|')) OR fid IN (SELECT pid FROM oxfolder_permissions WHERE fid = pid AND (orp >= 4 AND (role = 256 AND entity LIKE '|**NAS_USER**|' OR role = 32768 AND entity LIKE '|**NAS_USER**|' OR (role = 512 OR role = 65536) 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 OR role = 65536) 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 id, mdate, name, intfield01 FROM projects_milestones**
**NAS_WHERE = WHERE ((date(projects_milestones.mdate) = |**sql_today**|) AND projects_milestones.intfield01 IN (SELECT projects_participants.intfield01 from projects_participants WHERE projects_participants.id LIKE '|**NAS_USER**|'))**
**NAS_ORDER = ORDER BY mdate ASC**
**NAS_MR = 25**
**NAS_NFC = 25**
**NAS_SQL_OBJECTS NAME=rs_MilestonesToday**
**NAS_SQL_OBJECTS**
**NAS_SELECT = SELECT intfield01, project_name, project_reminder, fuid FROM projects**
**NAS_WHERE = WHERE ((date(project_reminder) = |**sql_today**|) AND project_status NOT LIKE '11' AND '|**NAS_USER**|' IN (SELECT projects_participants.id from projects_participants WHERE projects_participants.id LIKE '|**NAS_USER**|' AND projects_participants.role > 2))**
**NAS_ORDER = ORDER BY project_reminder ASC**
**NAS_MR = 25**
**NAS_NFC = 25**
**NAS_SQL_OBJECTS NAME=rs_ProjectReminderToday**
**NAS_SQL_OBJECTS**
**NAS_SELECT = SELECT timestampfield01 AS cDate, timestampfield01, timestampfield02, intfield01, field01 FROM prg_dates**
**NAS_WHERE = WHERE ((date(timestampfield01) >= |**sql_today**| AND date(timestampfield01) <= date(|**sysdate**|) + |**AppointmentDays**|) AND (intfield01 IN (SELECT object_id FROM prg_dates_members WHERE member_uid LIKE '|**NAS_USER**|' AND object_id = intfield01) AND (fid = -1 OR fid IN (SELECT pid FROM oxfolder_permissions WHERE fid = pid AND (orp >= 4 AND (role = 256 AND entity LIKE '|**NAS_USER**|' OR role = 32768 AND entity LIKE '|**NAS_USER**|' OR (role = 512 OR role = 65536) 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 OR role = 65536) 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 (((date(timestampfield03) <= |**sql_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 (((date(timestampfield01) >= |**sql_today**|) AND (date(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**