**NAS_DB_OBJECTS** rs_TasksNew.prg_tasks.intfield01, 1, int8, 3, 1 rs_TasksNew.prg_tasks.field01, 2, text, 3, 1 rs3.prg_pin_board.intfield01, 1, int8, 3, 1 rs3.prg_pin_board.field01, 2, text, 3, 1 rs4.prg_knowledge.intfield01, 1, int8, 3, 1 rs4.prg_knowledge.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.intfield01, 1, int8, 3, 1 rs6.prg_projects.field01, 2, text, 3, 1 rs8.prg_contacts.intfield01, 1, int8, 10, 1 rs8.prg_contacts.field01, 2, text, 7, 1 rs9.prg_bookmarks.intfield01, 1, int8, 3, 1 rs9.prg_bookmarks.field01, 2, text, 3, 1 rs10.prg_forum_entries.intfield01, 1, int8, 3, 1 rs10.prg_forum_entries.intfield02, 2, int8, 3, 1 rs10.prg_forum_entries.field01, 3, text, 3, 1 **NAS_DB_OBJECTS** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT intfield01, field01 FROM prg_tasks** **NAS_WHERE = WHERE ((date(creating_date) >= date(|**sysdate**|) - |**sDays**|) 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 field01 ASC** **NAS_MR = 200** **NAS_SQL_OBJECTS NAME=rs_TasksNew** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT intfield01, field01 FROM prg_pin_board** **NAS_WHERE = WHERE (creating_date >= date(|**sysdate**|) - |**sDays**|) AND ((user_right LIKE '|**NAS_USER**|') OR (group_right LIKE 'a') OR ((group_right LIKE 'g' AND intfield06 IN (SELECT object_id FROM prg_pin_board_read WHERE (((user_right LIKE '|**NAS_USER**|') OR (group_right IN (|**memberingroups**|)))))) OR ((group_right LIKE 'g' AND intfield06 IN (SELECT object_id FROM prg_pin_board_read WHERE ((user_right IS NULL) AND (group_right IS NULL)))))))** **NAS_ORDER = ORDER BY field01 ASC** **NAS_MR = 200** **NAS_SQL_OBJECTS NAME=rs3** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT intfield01, field01 FROM prg_knowledge** **NAS_WHERE = WHERE (creating_date >= date(|**sysdate**|) - |**sDays**|) AND ((group_right LIKE 'a' OR user_right LIKE '|**NAS_USER**|') or ( group_right LIKE 'g' AND intfield06 in (SELECT object_id from prg_knowledge_read WHERE ((user_right IS NULL) AND (group_right IS NULL)) OR (user_right LIKE '|**NAS_USER**|') OR (group_right in (|**memberingroups**|))))) ** **NAS_ORDER = ORDER BY field01 ASC** **NAS_MR = 200** **NAS_SQL_OBJECTS NAME=rs4** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT timestampfield01 AS cDate, timestampfield01, timestampfield02, intfield01, field01 FROM prg_dates** **NAS_WHERE = WHERE ((creating_date >= date(|**sysdate**|) - |**sDays**|) 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 ASC, timestampfield02 ASC** **NAS_MR = 200** **NAS_SQL_OBJECTS NAME=rs5** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT intfield01, field01 FROM prg_projects** **NAS_WHERE = WHERE (creating_date >= date(|**sysdate**|) - |**sDays**|) 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 field01 ASC** **NAS_MR = 200** **NAS_SQL_OBJECTS NAME=rs6** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT intfield01, field01 FROM prg_contacts** **NAS_WHERE = WHERE ( (creating_date >= date(|**sysdate**|) - |**sDays**|) AND (( fid = -1 AND pid 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_contacts.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**|))))) 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_contacts.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 field01 ASC** **NAS_MR = 200** **NAS_SQL_OBJECTS NAME=rs8** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT intfield01, field01 FROM prg_bookmarks** **NAS_WHERE = WHERE (creating_date >= date(|**sysdate**|) - |**sDays**|) AND ((group_right LIKE 'a' OR user_right LIKE '|**NAS_USER**|') or ( group_right LIKE 'g' AND intfield06 in (SELECT object_id from prg_bookmarks_read WHERE ((user_right IS NULL) AND (group_right IS NULL)) OR (user_right LIKE '|**NAS_USER**|') OR (group_right in (|**memberingroups**|))))) ** **NAS_ORDER = ORDER BY field01 ASC** **NAS_MR = 200** **NAS_SQL_OBJECTS NAME=rs9** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT prg_forum_entries.intfield01, prg_forum_entries.intfield02, prg_forum_entries.field01 FROM prg_forums, prg_forum_entries** **NAS_WHERE = WHERE (prg_forum_entries.creating_date >= date(|**sysdate**|) - |**sDays**|) AND ((prg_forum_entries.intfield02=prg_forums.intfield01) AND ((prg_forums.group_right LIKE 'a' OR prg_forums.user_right LIKE '|**NAS_USER**|') or ( prg_forums.group_right LIKE 'g' AND prg_forums.intfield06 in (SELECT object_id from prg_forum_read WHERE ((user_right IS NULL) AND (group_right IS NULL)) OR (user_right LIKE '|**NAS_USER**|') OR (group_right in (|**memberingroups**|)))))) ** **NAS_ORDER = ORDER BY field01 ASC** **NAS_MR = 200** **NAS_SQL_OBJECTS NAME=rs10** **NAS_VO TYPE="CHOICE" NAME="sDays" DB_VALUE=1|3|5|10|20|30 HTML_VALUES=Со вчерашенего дня|За последние 3 дня|За последние 5 дней|За последние 10 дней|За последние 20 дней|За последние 30 дней REFERENZ=SD1 JAVASCRIPT=onChange="this.form.submit();" class="select-normal"**