PS Query Lists - Revision history

http://www.homemarketeer.com/wiki/index.php?action=history&feed=atom&title=PS_Query_Lists PS Query Lists - Revision history 2026-10-17T07:18:07Z Revision history for this page on the wiki MediaWiki 1.16.0 http://www.homemarketeer.com/wiki/index.php?title=PS_Query_Lists&diff=1143&oldid=prev WikiSysop at 18:01, 19 March 2015 2015-03-19T18:01:21Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 18:01, 19 March 2015</td> </tr><tr><td colspan="2" class="diff-lineno">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>[[<del class="diffchange diffchange-inline">PS </del>Query]] has a way of comparing a list of values in the criteria to a particular column (or expression). You have to add each value individually - this is a bit of fun for a handful of values, but when the number of values in the list hit serious double figures, it becomes a bit tedious.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>[[<ins class="diffchange diffchange-inline">PeopleSoft </ins>Query]] has a way of comparing a list of values in the criteria to a particular column (or expression). You have to add each value individually - this is a bit of fun for a handful of values, but when the number of values in the list hit serious double figures, it becomes a bit tedious.</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>The list of values makes use of the "in" operator in SQL. If we already have the list in an email or spreadsheet, we can edit the list into the SQL format without having to rete the actual values, but then we need to get it into PS Query:</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>The list of values makes use of the "in" operator in SQL. If we already have the list in an email or spreadsheet, we can edit the list into the SQL format without having to rete the actual values, but then we need to get it into PS Query:</div></td></tr> </table>

WikiSysop http://www.homemarketeer.com/wiki/index.php?title=PS_Query_Lists&diff=1141&oldid=prev WikiSysop at 17:59, 19 March 2015 2015-03-19T17:59:13Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 17:59, 19 March 2015</td> </tr><tr><td colspan="2" class="diff-lineno">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>PS Query has a way of comparing a list of values in the criteria to a particular column (or expression). You have to add each value individually - this is a bit of fun for a handful of values, but when the number of values in the list hit serious double figures, it becomes a bit tedious.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">[[</ins>PS Query<ins class="diffchange diffchange-inline">]] </ins>has a way of comparing a list of values in the criteria to a particular column (or expression). You have to add each value individually - this is a bit of fun for a handful of values, but when the number of values in the list hit serious double figures, it becomes a bit tedious.</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>The list of values makes use of the "in" operator in SQL. If we already have the list in an email or spreadsheet, we can edit the list into the SQL format without having to rete the actual values, but then we need to get it into PS Query:</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>The list of values makes use of the "in" operator in SQL. If we already have the list in an email or spreadsheet, we can edit the list into the SQL format without having to rete the actual values, but then we need to get it into PS Query:</div></td></tr> </table>

WikiSysop http://www.homemarketeer.com/wiki/index.php?title=PS_Query_Lists&diff=1139&oldid=prev WikiSysop at 13:48, 18 March 2015 2015-03-18T13:48:27Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 13:48, 18 March 2015</td> </tr><tr><td colspan="2" class="diff-lineno">Line 9:</td> <td colspan="2" class="diff-lineno">Line 9:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>3: As an example, to make a list of Departments containing Sales, Marketing, Operations put the following into the expression list:</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>3: As an example, to make a list of Departments containing Sales, Marketing, Operations put the following into the expression list:</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><pre></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><pre></div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>A.DEPTID in ('SALES','MARKETING','OPERATIONS') and 'a'<del class="diffchange diffchange-inline">=</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>A.DEPTID in ('SALES','MARKETING','OPERATIONS') and 'a'</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>4: Click OK and save the expression and return to your new criterion.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>4: Click OK and save the expression and return to your new criterion.</div></td></tr> </table>

WikiSysop http://www.homemarketeer.com/wiki/index.php?title=PS_Query_Lists&diff=1137&oldid=prev WikiSysop at 20:56, 17 March 2015 2015-03-17T20:56:53Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 20:56, 17 March 2015</td> </tr><tr><td colspan="2" class="diff-lineno">Line 27:</td> <td colspan="2" class="diff-lineno">Line 27:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>*Windows</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>*Windows</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><pre></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><pre></div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div><nowiki>([^\r]*)</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><nowiki>([^\r]*)<ins class="diffchange diffchange-inline"></nowiki></ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Mobile Devices</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Mobile Devices</div></td></tr> </table>

WikiSysop http://www.homemarketeer.com/wiki/index.php?title=PS_Query_Lists&diff=1129&oldid=prev WikiSysop at 19:10, 25 February 2015 2015-02-25T19:10:37Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 19:10, 25 February 2015</td> </tr><tr><td colspan="2" class="diff-lineno">Line 41:</td> <td colspan="2" class="diff-lineno">Line 41:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[File:RegularExpressionList.jpg|link=http://www.springboardsolutions.com/regular_expression.html]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[File:RegularExpressionList.jpg|link=http://www.springboardsolutions.com/regular_expression.html]]</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>''The [http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24 PeopleSoft Users Companion] is <del class="diffchange diffchange-inline">short </del>Kindle eBook packed with hints and tips on using the PeopleSoft web more effectively. Get your copy today.''</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>''The [http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24 PeopleSoft Users Companion] is <ins class="diffchange diffchange-inline">a </ins>Kindle eBook packed with hints and tips on using the PeopleSoft web more effectively. Get your copy today.''</div></td></tr> </table>

WikiSysop http://www.homemarketeer.com/wiki/index.php?title=PS_Query_Lists&diff=1127&oldid=prev WikiSysop at 21:20, 23 February 2015 2015-02-23T21:20:00Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 21:20, 23 February 2015</td> </tr><tr><td colspan="2" class="diff-lineno">Line 40:</td> <td colspan="2" class="diff-lineno">Line 40:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[File:RegularExpressionList.jpg|link=http://www.springboardsolutions.com/regular_expression.html]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[File:RegularExpressionList.jpg|link=http://www.springboardsolutions.com/regular_expression.html]]</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">''The [http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24 PeopleSoft Users Companion] is short Kindle eBook packed with hints and tips on using the PeopleSoft web more effectively. Get your copy today.''</ins></div></td></tr> </table>

WikiSysop http://www.homemarketeer.com/wiki/index.php?title=PS_Query_Lists&diff=1125&oldid=prev WikiSysop at 21:15, 23 February 2015 2015-02-23T21:15:31Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 21:15, 23 February 2015</td> </tr><tr><td colspan="2" class="diff-lineno">Line 39:</td> <td colspan="2" class="diff-lineno">Line 39:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>4: Click "Replace" and your comma separated list appears in the right hand box.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>4: Click "Replace" and your comma separated list appears in the right hand box.</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>[[File:RegularExpressionList.jpg]]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>[[File:RegularExpressionList.jpg<ins class="diffchange diffchange-inline">|link=http://www.springboardsolutions.com/regular_expression.html</ins>]]</div></td></tr> </table>

WikiSysop http://www.homemarketeer.com/wiki/index.php?title=PS_Query_Lists&diff=1123&oldid=prev WikiSysop at 19:42, 23 February 2015 2015-02-23T19:42:17Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 19:42, 23 February 2015</td> </tr><tr><td colspan="2" class="diff-lineno">Line 17:</td> <td colspan="2" class="diff-lineno">Line 17:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==Creating the List==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==Creating the List==</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Creating a quoted, comma separated list can be done in a text editor, in a spreadsheet or in an online tool such as <del class="diffchange diffchange-inline">[</del>[http://www.springboardsolutions.com/regular_expression.html Regular Expression Calculator<del class="diffchange diffchange-inline">]</del>].</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Creating a quoted, comma separated list can be done in a text editor, in a spreadsheet or in an online tool such as [http://www.springboardsolutions.com/regular_expression.html Regular Expression Calculator].</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>To convert a list of items, one to a line into a SQL "in" list:</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>To convert a list of items, one to a line into a SQL "in" list:</div></td></tr> </table>

WikiSysop http://www.homemarketeer.com/wiki/index.php?title=PS_Query_Lists&diff=1121&oldid=prev WikiSysop at 19:41, 23 February 2015 2015-02-23T19:41:22Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 19:41, 23 February 2015</td> </tr><tr><td colspan="2" class="diff-lineno">Line 17:</td> <td colspan="2" class="diff-lineno">Line 17:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==Creating the List==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==Creating the List==</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Creating a quoted, comma separated list can be done in a text editor, in a spreadsheet or in an online tool such as Regular Expression Calculator.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Creating a quoted, comma separated list can be done in a text editor, in a spreadsheet or in an online tool such as <ins class="diffchange diffchange-inline">[[http://www.springboardsolutions.com/regular_expression.html </ins>Regular Expression Calculator<ins class="diffchange diffchange-inline">]]</ins>.</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>To convert a list of items, one to a line into a SQL "in" list:</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>To convert a list of items, one to a line into a SQL "in" list:</div></td></tr> </table>

WikiSysop http://www.homemarketeer.com/wiki/index.php?title=PS_Query_Lists&diff=1119&oldid=prev WikiSysop at 19:36, 23 February 2015 2015-02-23T19:36:12Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 19:36, 23 February 2015</td> </tr><tr><td colspan="2" class="diff-lineno">Line 39:</td> <td colspan="2" class="diff-lineno">Line 39:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>4: Click "Replace" and your comma separated list appears in the right hand box.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>4: Click "Replace" and your comma separated list appears in the right hand box.</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>[File:RegularExpressionList.jpg]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">[</ins>[File:RegularExpressionList.jpg<ins class="diffchange diffchange-inline">]</ins>]</div></td></tr> </table>

WikiSysop