Hello Jian, Thank you for sharing this great set of reports. They provide examples of using jQuery for plugins, which I have seen you recommend in the past, and I am eager to put to use. What a great resource!
Romola Chrzanowski Sr. Programmer/Analyst ITS - University Applications Development MSC-100 University at Albany, SUNY Albany, New York 12222 518.437.3842 From: [email protected] [mailto:[email protected]] On Behalf Of Jian Huang Sent: Tuesday, March 05, 2013 9:32 AM To: [email protected] Subject: Re: Use RQL to determine which users have changed (any) page Reports Manager. https://sites.google.com/site/simplyreddot/ReportsManager.zip -Jian On Monday, March 4, 2013 6:27:19 PM UTC-5, Jian Huang wrote: Brook, I...I think I have the solution, but it will cost you karma. I will post it tomorrow morning. Your cost: if you are buying coffee, pay for the guy in line behind you as well. Sent from my iPhone On Mar 4, 2013, at 3:20 PM, Brook <[email protected]<mailto:[email protected]>> wrote: Recently all of our users received new accounts, and their old accounts were saved and archived (ie: for each "user" there is now also "ARCHuser" for historical purposes). At least some of these accounts were instantiated yet never worked on any pages, and therefore do not need to be saved. Using RQL, is there a way to determine which users HAVE made changes to ANY page since the creation of their account? When you load a pages information ( <PAGE action="load" guid="[!guid_page!]"/> ) the "changeusername" provides the logon name of the person who edited the page, so if you ran a query for each page you would get a list of everyone who had edited pages. I was thinking you could then export the (very large) text response to Microsoft Excel, delimiting the data so that a Compare macro could be run on the "changeusername" field, comparing against a list of all of our users. Those that do not match would be the ones that have never made any edits. Would this work? I foresee a potential problem with running a query through every single page, is there a way to obtain this information by searching based on user info instead of page info? If this is a viable solution, how would I go about setting up a query to collect info from ALL pages rather than just one specific one at a time? Thanks for any ideas/help. -Brook -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To post to this group, send email to [email protected]<mailto:[email protected]>. Visit this group at http://groups.google.com/group/reddot-cms-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To post to this group, send email to [email protected]<mailto:[email protected]>. Visit this group at http://groups.google.com/group/reddot-cms-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/reddot-cms-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
