From b811360bcba279aba538f36f532da56642022f73 Mon Sep 17 00:00:00 2001 From: priyankabhagwat Date: Wed, 31 May 2017 16:16:04 +0530 Subject: minor changes --- CFD/casestudy-dev-doc.rst | 216 +++++++++++++++++++++++----------------------- 1 file changed, 108 insertions(+), 108 deletions(-) diff --git a/CFD/casestudy-dev-doc.rst b/CFD/casestudy-dev-doc.rst index 67e68c9..47c5941 100644 --- a/CFD/casestudy-dev-doc.rst +++ b/CFD/casestudy-dev-doc.rst @@ -109,17 +109,17 @@ accepted. `*http://cfd.fossee.in/case-study/manage-proposal* `__ **Roles-** Administrator, Case Study Reviewer - **Query-** - - SELECT node.title AS node\_title, node.nid AS nid, node.created AS - node\_created, 'node' AS - field\_data\_field\_case\_study\_status\_node\_entity\_type - FROM - {node} node - WHERE (( (node.status = '1') AND (node.type IN - ('case\_study\_proposal')) )) - ORDER BY node\_created DESC - LIMIT 25 OFFSET 0 + **Query-** + + SELECT node.title AS node\_title, node.nid AS nid, node.created AS + node\_created, 'node' AS + field\_data\_field\_case\_study\_status\_node\_entity\_type + FROM + {node} node + WHERE (( (node.status = '1') AND (node.type IN + ('case\_study\_proposal')) )) + ORDER BY node\_created DESC + LIMIT 25 OFFSET 0 Description @@ -139,8 +139,48 @@ accepted. `*http://cfd.fossee.in/case-study/cs-in-progress* `__ **Roles-** All + **Query -** + + SELECT node.title AS node\_title, node.created AS node\_created + FROM + {node} node + LEFT JOIN {field\_data\_field\_case\_study\_title} + field\_data\_field\_case\_study\_title ON node.nid = + field\_data\_field\_case\_study\_title.field\_case\_study\_title\_target\_id + AND (field\_data\_field\_case\_study\_title.entity\_type = 'node' AND + field\_data\_field\_case\_study\_title.deleted = '0') + LEFT JOIN {node} field\_case\_study\_title\_node ON + field\_data\_field\_case\_study\_title.entity\_id = + field\_case\_study\_title\_node.nid + INNER JOIN {field\_data\_field\_case\_study\_status} + field\_data\_field\_case\_study\_status ON node.nid = + field\_data\_field\_case\_study\_status.entity\_id AND + (field\_data\_field\_case\_study\_status.entity\_type = 'node' AND + field\_data\_field\_case\_study\_status.deleted = '0') + LEFT JOIN {field\_data\_field\_code\_submission\_status} + field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status + ON field\_case\_study\_title\_node.nid = + field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status.entity\_id + AND + field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status.field\_code\_submission\_status\_value + = 'Reject' + INNER JOIN {field\_data\_field\_code\_submission\_status} + field\_data\_field\_code\_submission\_status ON node.nid = + field\_data\_field\_code\_submission\_status.entity\_id AND + (field\_data\_field\_code\_submission\_status.entity\_type = 'node' + AND field\_data\_field\_code\_submission\_status.deleted = '0') + WHERE (( (node.status = '1') AND (node.type IN + ('case\_study\_proposal')) AND + (field\_data\_field\_case\_study\_status.field\_case\_study\_status\_value + = 'Approve') AND + (field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status.field\_code\_submission\_status\_value + IS NULL ) AND + (field\_data\_field\_code\_submission\_status.field\_code\_submission\_status\_value + = 'Complete') )) + ORDER BY node\_created DESC + LIMIT 25 OFFSET 0 - Description + **Description** - The display is in the table format @@ -151,46 +191,7 @@ accepted. - Content is published - Proposal Status -**Query -** - - SELECT node.title AS node\_title, node.created AS node\_created - FROM - {node} node - LEFT JOIN {field\_data\_field\_case\_study\_title} - field\_data\_field\_case\_study\_title ON node.nid = - field\_data\_field\_case\_study\_title.field\_case\_study\_title\_target\_id - AND (field\_data\_field\_case\_study\_title.entity\_type = 'node' AND - field\_data\_field\_case\_study\_title.deleted = '0') - LEFT JOIN {node} field\_case\_study\_title\_node ON - field\_data\_field\_case\_study\_title.entity\_id = - field\_case\_study\_title\_node.nid - INNER JOIN {field\_data\_field\_case\_study\_status} - field\_data\_field\_case\_study\_status ON node.nid = - field\_data\_field\_case\_study\_status.entity\_id AND - (field\_data\_field\_case\_study\_status.entity\_type = 'node' AND - field\_data\_field\_case\_study\_status.deleted = '0') - LEFT JOIN {field\_data\_field\_code\_submission\_status} - field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status - ON field\_case\_study\_title\_node.nid = - field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status.entity\_id - AND - field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status.field\_code\_submission\_status\_value - = 'Reject' - INNER JOIN {field\_data\_field\_code\_submission\_status} - field\_data\_field\_code\_submission\_status ON node.nid = - field\_data\_field\_code\_submission\_status.entity\_id AND - (field\_data\_field\_code\_submission\_status.entity\_type = 'node' - AND field\_data\_field\_code\_submission\_status.deleted = '0') - WHERE (( (node.status = '1') AND (node.type IN - ('case\_study\_proposal')) AND - (field\_data\_field\_case\_study\_status.field\_case\_study\_status\_value - = 'Approve') AND - (field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status.field\_code\_submission\_status\_value - IS NULL ) AND - (field\_data\_field\_code\_submission\_status.field\_code\_submission\_status\_value - = 'Complete') )) - ORDER BY node\_created DESC - LIMIT 25 OFFSET 0 + |image4| @@ -205,42 +206,42 @@ accepted. **Roles-** All **Query-** - SELECT node.title AS node\_title, node.nid AS nid, - field\_case\_study\_title\_node.nid AS - field\_case\_study\_title\_node\_nid, node.created AS node\_created, - 'node' AS field\_data\_field\_upload\_cs\_zip\_node\_entity\_type - FROM - {node} node - LEFT JOIN {field\_data\_field\_case\_study\_title} - field\_data\_field\_case\_study\_title ON node.nid = - field\_data\_field\_case\_study\_title.field\_case\_study\_title\_target\_id - AND (field\_data\_field\_case\_study\_title.entity\_type = 'node' AND - field\_data\_field\_case\_study\_title.deleted = '0') - LEFT JOIN {node} field\_case\_study\_title\_node ON - field\_data\_field\_case\_study\_title.entity\_id = - field\_case\_study\_title\_node.nid - LEFT JOIN {field\_data\_field\_upload\_cs\_zip} - field\_case\_study\_title\_node\_\_field\_data\_field\_upload\_cs\_zip - ON field\_case\_study\_title\_node.nid = - field\_case\_study\_title\_node\_\_field\_data\_field\_upload\_cs\_zip.entity\_id - AND - (field\_case\_study\_title\_node\_\_field\_data\_field\_upload\_cs\_zip.entity\_type - = 'node' AND - field\_case\_study\_title\_node\_\_field\_data\_field\_upload\_cs\_zip.deleted - = '0') - INNER JOIN {field\_data\_field\_case\_study\_status} - field\_data\_field\_case\_study\_status ON node.nid = - field\_data\_field\_case\_study\_status.entity\_id AND - (field\_data\_field\_case\_study\_status.entity\_type = 'node' AND - field\_data\_field\_case\_study\_status.deleted = '0') - WHERE (( (node.uid = '1' ) )AND(( (node.status = '1') AND (node.type - IN ('case\_study\_proposal')) AND - (field\_case\_study\_title\_node\_\_field\_data\_field\_upload\_cs\_zip.field\_upload\_cs\_zip\_fid - IS NULL ) AND - (field\_data\_field\_case\_study\_status.field\_case\_study\_status\_value - = 'Approve') ))) - ORDER BY node\_created DESC - LIMIT 25 OFFSET 0 + SELECT node.title AS node\_title, node.nid AS nid, + field\_case\_study\_title\_node.nid AS + field\_case\_study\_title\_node\_nid, node.created AS node\_created, + 'node' AS field\_data\_field\_upload\_cs\_zip\_node\_entity\_type + FROM + {node} node + LEFT JOIN {field\_data\_field\_case\_study\_title} + field\_data\_field\_case\_study\_title ON node.nid = + field\_data\_field\_case\_study\_title.field\_case\_study\_title\_target\_id + AND (field\_data\_field\_case\_study\_title.entity\_type = 'node' AND + field\_data\_field\_case\_study\_title.deleted = '0') + LEFT JOIN {node} field\_case\_study\_title\_node ON + field\_data\_field\_case\_study\_title.entity\_id = + field\_case\_study\_title\_node.nid + LEFT JOIN {field\_data\_field\_upload\_cs\_zip} + field\_case\_study\_title\_node\_\_field\_data\_field\_upload\_cs\_zip + ON field\_case\_study\_title\_node.nid = + field\_case\_study\_title\_node\_\_field\_data\_field\_upload\_cs\_zip.entity\_id + AND + (field\_case\_study\_title\_node\_\_field\_data\_field\_upload\_cs\_zip.entity\_type + = 'node' AND + field\_case\_study\_title\_node\_\_field\_data\_field\_upload\_cs\_zip.deleted + = '0') + INNER JOIN {field\_data\_field\_case\_study\_status} + field\_data\_field\_case\_study\_status ON node.nid = + field\_data\_field\_case\_study\_status.entity\_id AND + (field\_data\_field\_case\_study\_status.entity\_type = 'node' AND + field\_data\_field\_case\_study\_status.deleted = '0') + WHERE (( (node.uid = '1' ) )AND(( (node.status = '1') AND (node.type + IN ('case\_study\_proposal')) AND + (field\_case\_study\_title\_node\_\_field\_data\_field\_upload\_cs\_zip.field\_upload\_cs\_zip\_fid + IS NULL ) AND + (field\_data\_field\_case\_study\_status.field\_case\_study\_status\_value + = 'Approve') ))) + ORDER BY node\_created DESC + LIMIT 25 OFFSET 0 **Description** @@ -266,13 +267,12 @@ accepted. **Roles-** Administrator, Case Study Reviewer **Query-** - -SELECT node.title AS node\_title, node.nid AS nid, node.created AS node\_created, 'node' AS field\_data\_field\_code\_submission\_status \_node\_entity\_type FROM -{node} node -WHERE (( (node.status = '1') AND (node.type IN 'case\_study\_code\_submission')) -ORDER BY node\_created DESC -LIMIT 25 OFFSET 0 - + SELECT node.title AS node\_title, node.nid AS nid, node.created AS node\_created, 'node' AS field\_data\_field\_code\_submission\_status \_node\_entity\_type FROM + {node}node + WHERE (( (node.status = '1') AND (node.type IN 'case\_study\_code\_submission')) + ORDER BY node\_created DESC + LIMIT 25 OFFSET 0 + **Description** - The display is in the table format @@ -297,13 +297,13 @@ LIMIT 25 OFFSET 0 **Roles-** Administrator, Case Study Reviewer **Query** -SELECT node.title AS node\_title, node.nid AS nid, field\_case\_study\_title\_node.nid AS field\_case\_study\_title\_node\_nid, node.created AS node\_created, 'node' AS field\_data\_field\_attachment\_node\_entity\_type, 'node' AS field\_data\_field\_upload\_cs\_zip\_node\_entity\_type, 'node' AS field\_data\_field\_personal\_details\_node\_entity\_type {node} node -LEFT JOIN {field\_data\_field\_case\_study\_title} field\_data\_field\_case\_study\_title ON node.nid = field\_data\_field\_case\_study\_title.field\_case\_study\_title\_target\_id AND (field\_data\_field\_case\_study\_title.entity\_type = 'node' AND field\_data\_field\_case\_study\_title.deleted = '0') -LEFT JOIN {node} field\_case\_study\_title\_node ON field\_data\_field\_case\_study\_title.entity\_id = field\_case\_study\_title\_node.nid INNER JOIN {field\_data\_field\_code\_submission\_status} field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status ON field\_case\_study\_title\_node.nid = field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status.entity\_id AND (field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status.entity\_type = 'node' AND field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status.deleted = '0') | - WHERE (( (node.status = '1') AND (node.type IN ('case\_study\_proposal')) AND (field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status.field\_code\_submission\_status\_value = 'Complete') )) - ORDER BY node\_created DESC | - LIMIT 25 OFFSET 0 - Description + SELECT node.title AS node\_title, node.nid AS nid, field\_case\_study\_title\_node.nid AS field\_case\_study\_title\_node\_nid, node.created AS node\_created, 'node' AS field\_data\_field\_attachment\_node\_entity\_type, 'node' AS field\_data\_field\_upload\_cs\_zip\_node\_entity\_type, 'node' AS field\_data\_field\_personal\_details\_node\_entity\_type {node} node + LEFT JOIN {field\_data\_field\_case\_study\_title} field\_data\_field\_case\_study\_title ON node.nid = field\_data\_field\_case\_study\_title.field\_case\_study\_title\_target\_id AND (field\_data\_field\_case\_study\_title.entity\_type = 'node' AND field\_data\_field\_case\_study\_title.deleted = '0') + LEFT JOIN {node} field\_case\_study\_title\_node ON field\_data\_field\_case\_study\_title.entity\_id = field\_case\_study\_title\_node.nid INNER JOIN {field\_data\_field\_code\_submission\_status} field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status ON field\_case\_study\_title\_node.nid = field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status.entity\_id AND (field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status.entity\_type = 'node' AND field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status.deleted = '0') | + WHERE (( (node.status = '1') AND (node.type IN ('case\_study\_proposal')) AND (field\_case\_study\_title\_node\_\_field\_data\_field\_code\_submission\_status.field\_code\_submission\_status\_value = 'Complete') )) + ORDER BY node\_created DESC | + LIMIT 25 OFFSET 0 + **Description** - The display is in the table format @@ -327,12 +327,12 @@ LEFT JOIN {node} field\_case\_study\_title\_node ON field\_data\_field\_case\_st **Roles-** Administrator, Case Study Reviewer **Query** -SELECT node.title AS node\_title, node.nid AS nid, node.created AS node\_created, 'node' AS field\_data\_field\_upload\_cs\_zip\_node\_entity\_type -FROM -{node} node -WHERE (( (node.uid = '1' ) )AND(( (node.status = '1') AND (node.type IN ('case\_study\_code\_submission')) ))) -ORDER BY node\_created DESC -LIMIT 10 OFFSET 0 + SELECT node.title AS node\_title, node.nid AS nid, node.created AS node\_created, 'node' AS field\_data\_field\_upload\_cs\_zip\_node\_entity\_type + FROM + {node} node + WHERE (( (node.uid = '1' ) )AND(( (node.status = '1') AND (node.type IN ('case\_study\_code\_submission')) ))) + ORDER BY node\_created DESC + LIMIT 10 OFFSET 0 Description - The display is in the table format -- cgit