(public).sospep.events ~ view task ~ REVIEW-api-indeed

<h1 style="text-align: center;">CREATE-task# # -</h1>
<h1 style="text-align: center;">FEATURE-000n-view-buying - porting to .org</h1>
<h2>[previously]</h2>
<ol>
<li><strong>[00:00] NEW task IN </strong></li>
<ol>
<li>[] # 2919 - <a href="/view/task?id=2919" target="_blank">CREATE-task# # </a>- ADD-FEATURE - view buying - port - ] porting the view / buying functionality into the .org version</li>
<li>[*] reference example = # 2793 - <a href="/view/task?id=2793" target="_blank">CREATE-task# #</a>&nbsp; -FEATURE-4900-view-bio - porting to .org - currently the MyStuff/Bio feature is not functional</li>
<li>[] TLDR - 'view buying' should show 'all'&nbsp; 'items' that have a status value of "Need" ( and a Priaaority value of "" )</li>
<li>[] these items are then organized by the warehouse, inventory and itemgroup that they appear in, aka bio_by_project, [*] based on view_priority (actually uses db viewPriority&nbsp;</li>
<li>[]</li>
<li>[*] repurposing this task, ORIG = PROCESS misc - tasks that, ON = 2019-09-19, content moved to today</li>
</ol>
<li><strong>[00:00] NEW task IN - <a href="/view/plans?id=1" target="_blank">prj-022</a> - ISSUE-001<a href="/view/plans?id=1" target="_blank"><br /></a></strong></li>
<ol>
<li>[x] # # - FEATURE view/buying - server error on page load</li>
<li>[x] ISSUE-001 - error of @Session VS Session</li>
</ol>
<li><strong>[00:00] NEW task IN</strong></li>
<ol>
<li>[x] EDIT PAGE - view buying - save copy of original/current version to deprecate</li>
</ol>
<li><strong>[00:00] NEW Task IN - database<br /></strong></li>
<ol>
<li>[x] EDIT db - .org - added new view_buying view, as per sql below</li>
<li>[x] EDIT db - dons - added new view_buying, renamed orig table as prev_view_buying, ] delete ?</li>
<li>[]</li>
</ol>
<li><strong>[00:00] NEW task IN - UPDATES</strong></li>
<ol>
<li>[x] added isAuthenticated check on 'display' "edit links toolbar",</li>
<li>[x] moved view/task link to taskName VS in "edit links toolbar",</li>
<li><span style="background-color: #ffff99;">[*] use of code inside code block, example nested if statement, 2nd if requres @{&nbsp; ... } wrapper</span></li>
</ol>
<li><strong>&gt;[00:00] NEW task IN - CLOSE <br /></strong></li>
<ol>
<li>[x] REM OVEd - case statement for cases based on IF called from plan, see below</li>
</ol>
<li><strong>[00:00] NEW task IN - *</strong></li>
<ol>
<li>[x] not seeing issue-002 - database view_buying</li>
<li>[x] not seeing issue-003 - view missing required column</li>
<li>[x] not seeing issue-005 - headings with no content</li>
</ol>
<li><strong>[] [00:00] NEW task IN -&nbsp; stats bar - location and style<br /></strong></li>
<ol>
<li>[x] used NEW statsBarBio AS example</li>
<li>[x] in NEW LOCATION = relocated it to directly below navHeader, [x] removed current style of "statsbar" (used absolute postioning),</li>
<li>[x] created AS _statsBarBuying = itemsCount, itemsTotalCOST,</li>
</ol>
<li><strong>[00:00] NEW task IN - refactor</strong></li>
<ol>
<li>[x] removed unused vars</li>
<li>[x] re ordered vars</li>
<li>[x] renamed vars</li>
<li>[] notes in source comments</li>
</ol>
<li><strong>[] NEW task IN - add view for single warehouse by name<br /></strong></li>
<ol>
<li>[x] add case "warehouse" where we can get view_buying for just a single warehouse</li>
<li>[x] add 4th parameter as warehouse name</li>
<li>[x] http://sospep.org/view/buying/warehouse/Want/1/nations</li>
</ol>
<li><strong>[00:00] NEW task IN - review</strong></li>
<ol>
<li>[] dont seem to see/find any documentation for view/buying OR view/selling </li>
<li>[] </li>
</ol></ol>
<div><hr /></div>
<ol>
<li><strong>[] &gt;[00:00] NEW task IN - ISSUE-007 - stats bar functionality<br /></strong></li>
<ol>
<li>[]&nbsp; # # - [] stats bar - functionality -</li>
<li>[x] moved 'statsBar' into '/Shared' as partial page, call RenderPage,</li>
<li>[] ERROR re: - var doesnt exist in this context, RESOLUTION: changed varName to Page.varName</li>
<ol>
<li>[] even after changing to Page["var"] property</li>
<li>[] PROBLEM WAS - shared page is rendered BEFORE values are caculated. Values are calculated in the display list items loop. Page is rendered at the top. This is why was previously using</li>
<li>[] RESOLUTION =</li>
<li>[1] return prev, render component after display loop, then re position&nbsp; (update from :using absolute position, to: ] reposition with script ] reposition with css)</li>
<li>[] https://stackoverflow.com/questions/104953/position-an-html-element-relative-to-its-container-using-css</li>
<li>[2] call js method - ] write vars to input hidden, ] call js method, updateStatsBar(), ] write js method updateStatsBar, -uses hidden input vars to update statsbar # values</li>
</ol>
<li>[] ERROR re: type passed into arg, when calling the calculateCompletedPercentage helper method</li>
</ol>
<li><strong>&nbsp;[] [00:00] NEW task IN - git commit &amp; merge</strong></li>
<ol>
<li>[x] commit -m = {"ADD-FEATURE - bio - porting feature functionality from original sospep.com version"}</li>
<li>[x] git local commited branch(ADD-FEATURE-bio)</li>
<li>[x] merged branch into master</li>
</ol></ol>
<h2>[currently]</h2>
<ol>
<li>&nbsp;<strong>[00:00] NEW task IN </strong></li>
<ol>
<li>[] # # -</li>
</ol></ol>
<h2>[next]</h2>
<ol>
<li><strong>[00:00] NEW task IN TODO</strong></li>
<ol>
<li>[x] content is left aligned -</li>
<li>[] heading styles -</li>
<li>[x] stats bar - location</li>
<li>[x] stats bar - style</li>
<li>[i] stats bar - functionality</li>
<li>[x] why are 'heading's that have no content displaying -</li>
<li>[i] database - update VIEW on OTHER DATABAseS, - [x] public [x] dons, [] ewa, [] other(s) ,</li>
</ol>
<li><strong>&nbsp;[00:00] NEW task IN </strong></li>
<ol>
<li>[] # # - <a href="/view/task?id=1839" target="_blank">CREATE-task# # </a>-</li>
<li>[] bio - all</li>
<li>===</li>
<li>[] bio - by calendar</li>
<li>[] bio - by plan/document</li>
<li>[] bio - by taskgroup</li>
<li>===</li>
<li>[] bio - by period - ( day, month, week, quarter, )</li>
<li>[] bio - by period - custom</li>
</ol></ol>
<h2>[reference]</h2>
<div><ol>
<li>[*] sospep public - # 4900 - feature definition</li>
</ol></div>
<hr />
<h1 style="text-align: center;">query</h1>
<p style="text-align: left;">SELECT * FROM `view_p1` WHERE priority = -5 and status = 'Completed'</p>
<p style="text-align: left;">SELECT * FROM view_buying WHERE status = Want || NEED ||</p>
<p style="text-align: left;">and priority =</p>
<p style="text-align: left;">&nbsp;</p>
<h1 style="text-align: center;">create view</h1>
<p><br /><br />[] rewriting view_priorities as view BUYING<br /><br />CREATE VIEW view_buying AS SELECT items.*, itemcategories.id_itemCategory, itemcategories.name_itemCategory, itemcategories.parent_id AS parent_id_itemCategory, inventories.id_inventory, inventories.name_inventory, inventories.parent_id AS parent_id_inventory, warehouses.id_warehouse, warehouses.name_warehouse<br />FROM items<br />JOIN itemcategories ON items.parent_id = itemcategories.id_itemCategory<br />JOIN inventories ON itemcategories.parent_id = inventories.id_inventory<br />JOIN warehouses ON inventories.parent_id = warehouses.id_warehouse;</p>
<p>&nbsp;</p>
<div><hr /></div>
<div>displaying groups</div>
<div>- EDITed code on parent_id</div>
<div>- TO&nbsp; if (plan.parent_id_plan == calendar.id_calendar){</div>
<div><hr /></div>
<h1 style="text-align: center;">create query</h1>
<div>[] my groups - using order by in query to get dessired grouping, WORKS but very slow&nbsp; <br /><br />SELECT * FROM view_p1 WHERE priority=@0 &amp;&amp; status=@1 ORDER by name_calendar ASC, name_plan ASC, name_taskgroup ASC <br />SELECT * FROM view_p1 WHERE priority= -1 &amp;&amp; status='Completed' ORDER by name_calendar ASC, name_plan ASC, name_taskgroup ASC;</div>
<div><hr /></div>
<div>[] 2019-10-30 <br />[] FIX ISSUE - ERROR missing bracket<br />[] TEST appears to be in div displayList <br />[] removed some razor comments<br />[] bracket matching, i think i found and eliminated the extra <br />[] TEST = PASS BUT - page loads, BUT no results<br /><br />[] FIX ISSUE = no results display on page <br />[] CAUSE - suspect = view on database wasn't created properly<br />[] TRY =&nbsp; <br />[] RESOLUTION - created new view ,<br />[]</div>
<div><hr /></div>
<h1 style="text-align: center;">[] logic blocks from view buying</h1>
<div>// LOGIC BL 1 - to build qry's IF called from viewCalendar's<br />&nbsp;&nbsp;&nbsp; if (planId=="000")<br />&nbsp;&nbsp;&nbsp; { // put code here for CAL <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (String.IsNullOrEmpty(status1))<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; selectQuery = "select * from tasks where parent_id IN (select id_taskgroup from taskgroups where parent_id IN (select id_plan from plans where parent_id=@0))";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var tasks=db.Query(selectQuery,Parent);<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msg ="planId= 000 and no status";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Page["tasks"] = tasks;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (!String.IsNullOrEmpty(status1))<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // EX selectQuery= "SELECT * FROM tasks WHERE parent_id IN (SELECT id_taskgroup from taskgroups where parent_id=@0 ) &amp;&amp; status IN(@1) ORDER by name_task ASC";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; selectQuery = "select * from tasks where parent_id IN (select id_taskgroup from taskgroups where parent_id IN (select id_plan from plans where parent_id=@0)) &amp;&amp; status IN(@1) ";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var tasks= db.Query(selectQuery,parent_id, status1);<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msg ="parentid 000 and HAS status";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Page["tasks"] = tasks;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp; }<br />&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp; // LOGIC BL 2 - to build qry IF called from viewPlan's<br />&nbsp;&nbsp;&nbsp; if (parent_id=="000")<br />&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // WORKs -this means 1] we dont know the tgr id bc this page is being called from a higher level, ie PLAN or CAL<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // msg ="test IF tgr is 000 YES it is, the PLAN Id is: "+planId;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // - this means 1] we dont know the plan id bc this page is being called from a higher level ie CAL<br />&nbsp;&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //TRY 002 will just add IF statement and use selectQry1 IF */<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (String.IsNullOrEmpty(status1))<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; selectQuery= "SELECT * FROM tasks WHERE parent_id IN (SELECT id_taskgroup from taskgroups where parent_id=@0 ) &amp;&amp; status IN('Completed','To-Do','In-Process') ORDER by name_task ASC";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // selectQuery= "SELECT * FROM tasks WHERE parent_id IN (SELECT id_taskgroup from taskgroups where parent_id=@0 ) ORDER by name_task ASC";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var tasks=db.Query(selectQuery,planId);<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msg ="parentid 000 and no status";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Page["tasks"] = tasks;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (!String.IsNullOrEmpty(status1))<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; selectQuery= "SELECT * FROM tasks WHERE parent_id IN (SELECT id_taskgroup from taskgroups where parent_id=@0 ) &amp;&amp; status IN(@1) ORDER by name_task ASC";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var tasks= db.Query(selectQuery,planId, status1);<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msg ="parentid 000 and HAS status";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Page["tasks"] = tasks;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } <br />&nbsp;&nbsp;&nbsp; }<br />&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp; // LOGIC BL 3 - to build qry's IF called from viewTaskGroups<br />&nbsp;&nbsp;&nbsp; if (!String.IsNullOrEmpty(status1) &amp;&amp; parent_id !="000" &amp;&amp; planId !="000")<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; selectQuery = "SELECT * FROM tasks WHERE parent_id=@0 &amp;&amp; status IN(@1) ORDER by name_task ASC";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // REV fea 001 <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // selectQuery = "SELECT * FROM tasks WHERE parent_id IN(@0) &amp;&amp; status IN(@1) ORDER by name_task ASC"; // NOT WORKING PRB with params<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // try ### subqry<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // selectQuery= "SELECT * FROM tasks WHERE parent_id IN (SELECT id_taskgroup from taskgroups where parent_id=@0 ) &amp;&amp; status IN(@1) ORDER by name_task ASC";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var tasks= db.Query(selectQuery,parent_id, status1);<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msg ="parentid NOT 000 and HAS status" ;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Page["tasks"] = tasks;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp; /*<br />&nbsp;&nbsp;&nbsp; // LOGIC BL 0044 - to build qry's IF called from viewTaskGroups and NOT from search page<br />&nbsp;&nbsp;&nbsp; if (String.IsNullOrEmpty(status1) &amp;&amp; parent_id !="000" &amp;&amp; planId !="000" &amp;&amp; Request["qry"].IsEmpty()){<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //selectQuery= "SELECT * FROM view_priority";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; selectQuery= "SELECT * FROM view_priority WHERE priority=@0 and parent_id=@1";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // var tasks=db.Query(selectQuery,parent_id,-2);<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var tasks=db.Query(selectQuery,Priority,parent_id);<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // var sqlQ= "select name_taskgroup from taskgroups where id_taskgroup=parent_id"<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //var sqlQcalendars="select * from calendars";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //var sqlQcalendars= "SELECT id_calendar,name_calendar from view_priority GROUP BY id_calendar ORDER BY name_calendar ASC";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var sqlQcalendars= "SELECT id_calendar,name_calendar,id_plan,name_plan,id_taskgroup,name_taskgroup from view_priority GROUP BY id_calendar ORDER BY name_calendar ASC";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var sqlQplans= "SELECT id_plan,name_plan,plan_parent_id from view_priority GROUP BY id_plan ORDER BY name_plan ASC";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var sqlQtaskgroups= "SELECT id_taskgroup,name_taskgroup, parent_id_taskgroup from view_priority GROUP BY id_taskgroup ORDER BY name_taskgroup ASC";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // var sqlQgroups = "SELECT id_taskgroup,name_taskgroup FROM view_priority GROUP BY id_taskgroup";&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var calendars=db.Query(sqlQcalendars);<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var plans = db.Query(sqlQplans);<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var taskgroups = db.Query(sqlQtaskgroups);<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Page["tasks"] = tasks;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Page["calendars"]= calendars; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Page["plans"] = plans;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Page["taskgroups"]=taskgroups;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msg ="HELLO WORLD! FROM status=Null, parentid !='000' and planId !='000' &amp;&amp; Request['qry'].IsEmpty "; <br />&nbsp;&nbsp;&nbsp; }<br />&nbsp;&nbsp;&nbsp; */<br />&nbsp;<br />&nbsp;&nbsp;&nbsp; // LOGIC - BL 005 - <br />&nbsp;&nbsp;&nbsp; // Feature - 802 - Search Events by Feild MODIFIED for viewPriority IN Taskgroup/<br />&nbsp;&nbsp;&nbsp; // if (!Request["qry"].IsEmpty()){</div>

~ view task ~ TaskGroup] language-javascript FROM [ Plan] planning-project IN [ calendars] technology-developer-www