http://www.endusersharepoint.com/STP/ SharePoint QA en Thu, 19 Nov 2009 22:54:10 +0000 http://www.endusersharepoint.com/STP/topic/identifying-current-site-metadata-in-a-dvwp#post-11532 Thu, 19 Nov 2009 17:29:10 +0000 JohnM 11532@http://www.endusersharepoint.com/STP/ <p>This is the scenario:</p> <p>1. All sites are recorded in the Site Directory ("Site List") with a tag identifying the site owner.<br /> 2. Policy is that all sites must display the name of the (current) site owner.</p> <p>The approach is to use a DVWP on every site that displays the item on the Site List that matches the current site on view.</p> <p>I can do it this way :</p> <p>1. Identify the current site URL &#38; put in a parmeter (in scope)<br /> <code>&lt;ParameterBinding Name=&quot;CurURL&quot; Location=&quot;ServerVariable(URL)&quot; DefaultValue=&quot;&quot;/&gt;</code><br /> 2. Grab the URL value from the Site List<br /> 3. Create an XSLT filter to compare them &#38; filter the Site List.</p> <p>Problem is that $CurURL and @URL have different formats:</p> <p>1. @URL is the full path (twice) &#38; excludes the page name:<br /> e.g. "http://server/site/subsite/.../subsite, <a href="http://server/site/subsite/.../subsite" rel="nofollow">http://server/site/subsite/.../subsite</a>"</p> <p>2. $CurURL includes the page name (typically default.aspx but not necesarily) but excludes the protocol/server name .<br /> e.g. "/site/subsite/.../subsite/default.aspx"</p> <p>A bit of messy xsl will do it but assumes the page name is default.aspx :</p> <p><code>[substring-after(substring-after(substring-before(@URL,&#39;,&#39;),&#39;//&#39;),&#39;/&#39;)=substring-after(substring-before($CurURL,&#39;/default.aspx&#39;),&#39;/&#39;)]</code></p> <p>i.e "site/subsite/..." = "site/subsite/..."</p> <p>Questions<br /> 1. Is there a more efficient way of achieving this?<br /> 2. If not, what's the best way to eliminate the "default.aspx" assumption? </p> http://www.endusersharepoint.com/STP/topic/user-with-contribute-being-denied-access#post-11531 Thu, 19 Nov 2009 16:42:58 +0000 jbhoward 11531@http://www.endusersharepoint.com/STP/ <p>Found the problem/bug.</p> <p>Edit permission was set to <em>None</em>. When I changed it to <em>Only their own</em>, I stopped getting the error. I've reported it to MS.</p> <p>Very strange.</p> <p>Blessings,<br /> Jim Bob </p> http://www.endusersharepoint.com/STP/topic/meeting-workspace-default-modification#post-11530 Thu, 19 Nov 2009 16:29:44 +0000 Julien.Fournier 11530@http://www.endusersharepoint.com/STP/ <p>Hello,<br /> We have managed to modifie a meeting workspace to show the on call schedule week by week for our team, using the meeting workspace with a recurence for every week, however I am having the issue that it always shows the week after the curent week. This is beacose the first day of the week is a sunday, then comme monday it shows the schedule for next week. I was hopping somewone has a way to make it so that when I select the schedule link it would be defaulted to the week before. As in, today is monday, I am currently seeing next weeks schedule, but wath I wan't is to be able to see the week before by default (wich is this week). thanks for the help </p> http://www.endusersharepoint.com/STP/topic/user-with-contribute-being-denied-access#post-11529 Thu, 19 Nov 2009 16:24:47 +0000 bmcmann 11529@http://www.endusersharepoint.com/STP/ <p>Any modifications made to the default newitem, edititem, or viewitem form pages for this list with SharePoint Designer? </p> http://www.endusersharepoint.com/STP/topic/show-version-history-edits-in-data-view#post-11528 Thu, 19 Nov 2009 13:32:42 +0000 erugalatha 11528@http://www.endusersharepoint.com/STP/ <p>Hello.</p> <p>We have a list with a Comments column. Append to Text is enabled on that Comments column.</p> <p>I have added a data view web part to he DispForm.aspx in SharePoint Designer. I want to make that data view web part to show the version history of the current item.</p> <p>How can I show this in the data view web part? </p> http://www.endusersharepoint.com/STP/topic/bad-column-can-edit-it-for-some-docs-not-others#post-11527 Thu, 19 Nov 2009 12:34:51 +0000 katscasa 11527@http://www.endusersharepoint.com/STP/ <p>A user just notified me that she is unable to save property changes to a particular column in a document library. I went and saw it for myself: she would go into the document properties (we did it both on the edititem page and in datasheet), type a subject for the document (it's a single line of text column), and when she'd click OK (or enter in datasheet view), it would disappear. AND- it only happened for some docs and not others. </p> <p>Also, for the problem documents, we COULD add/edit the other properties. It was just the one that was deleting itself.</p> <p>I tried to find a pattern (who uploaded the docs that were problems, what were the library settings, column settings, etc.), but I couldn't pinpoint anything that would/should cause such a problem.</p> <p>I finally created another single line of text column w/ a similar name, created a view that put them side-by-side, and I tried editing both for one of the problem docs. Sure enough, the problem column went blank, but the new column retained what I had typed.</p> <p>Any ideas? Our solution was to populate (using datasheet) the new column w/ any data that had been retained in the old column. Once all data was transferred, we planned to delete the old column. While that should prove a decent solution for us, it doesn't really answer the question we have: WHY did this happen? How can a column be corrupt, and how can it only be corrupt for certain documents?</p> <p>Thanks to anyone who can shed some light on this very bizarre issue!<br /> Kat </p> http://www.endusersharepoint.com/STP/topic/easy-tabs-v31-splitting-the-tabs-into-3-rows#post-11526 Thu, 19 Nov 2009 11:18:42 +0000 DSMyers 11526@http://www.endusersharepoint.com/STP/ <p>Thanks! </p> http://www.endusersharepoint.com/STP/topic/add-total-count-of-items-in-view-to-item-limit-value#post-11525 Wed, 18 Nov 2009 16:48:49 +0000 will266 11525@http://www.endusersharepoint.com/STP/ <p>I have a request to provide a total count of items in a list view - the view is on our home page, and we have it limited (via Item Limit) to showing in batches of 5.</p> <p>At the bottom of the the web part, it shows 1-5 and a right arrow to indicate more items exist in the view.</p> <p>The client would prefer 1-5 of 28, then the right arrow.</p> <p>I have limited tools (i.e. CEWPs, but no Designer as it is locked down to our corporate team). </p> <p>I will need to use some jQuery goodness or the like, as the request, while valid, is too trivial to be escalated to our corporate group.</p> <p>Thanks in advance! </p> http://www.endusersharepoint.com/STP/topic/user-with-contribute-being-denied-access#post-11524 Wed, 18 Nov 2009 16:16:11 +0000 katscasa 11524@http://www.endusersharepoint.com/STP/ <p>So it sounds as though this isn't OOB contribute. You created a custom permissions level based on contribute that doesn't include the three personal permissions, correct?</p> <p>I recently had a problem where a user could not view his "My Settings" (he was trying to view/manage his alerts). He was getting permissions via a domain group (of sorts) via FBA. Anyway, that group had been given "contribute, not delete" which was a modified version of contribute. Once the group was switched from the custom permissions level to the OOB "contribute", he could access the "My Settings" once again.</p> <p>Not that that is related directly to what you've described, but I wonder if, in general, there are some problems w/ custom permission levels (and/or when they are added to a domain group?).</p> <p>Can you try the OOB "contribute" (personal permissions and all) and see if that makes a difference? Nothing scientific here- just grasping at straws. :)</p> <p>Good luck w/ it!<br /> Kat </p> http://www.endusersharepoint.com/STP/topic/affordable-anti-virus#post-11523 Wed, 18 Nov 2009 15:01:58 +0000 eric 11523@http://www.endusersharepoint.com/STP/ <p>In the past, we've used Microsoft ForeFront on our Sharepoint farms. Here we have Symantec Endpoint rolled out. </p> http://www.endusersharepoint.com/STP/topic/sharepoint-designer-kills-webparts-on-customized-pages#post-11522 Wed, 18 Nov 2009 14:57:55 +0000 latimoreb 11522@http://www.endusersharepoint.com/STP/ <p>These are any webparts we have on the page i.e. content editor webpart, or summary links webpart </p> http://www.endusersharepoint.com/STP/topic/affordable-anti-virus#post-11521 Wed, 18 Nov 2009 14:49:01 +0000 smittyatthebeach 11521@http://www.endusersharepoint.com/STP/ <p>We are currently looking for an affordable anti virus solution for MOSS. We are curious what people are using, like and dislike...</p> <p>Thanks, </p> http://www.endusersharepoint.com/STP/topic/inserting-form-action-workflow-into-survey-finish#post-11520 Wed, 18 Nov 2009 13:44:02 +0000 AutoSponge 11520@http://www.endusersharepoint.com/STP/ <p>@Jim,</p> <p>JSAPI is a project that lets you talk to SP web services with JavaScript (http://darrenjohnstone.net/2008/07/22/a-cross-browser-javascript-api-for-the-sharepoint-and-office-live-web-services/). There's been a few more people entering the space. </p> <p><a href="http://spservices.codeplex.com/" rel="nofollow">http://spservices.codeplex.com/</a><br /> another link I can't find atm. </p> http://www.endusersharepoint.com/STP/topic/pdf-shared-reviews-in-sharepoint#post-11519 Wed, 18 Nov 2009 13:41:47 +0000 msmiley 11519@http://www.endusersharepoint.com/STP/ <p>Eric:</p> <p>Thank you for the prompt reply. The example you gave me isn't exactly completing what I want. I find the visual aspect of Adobe's commenting tools incredibly helpful. That's why I was so insistent on using them. Here's an example of what I'm talking about: </p> <p><a href="http://s905.photobucket.com/albums/ac254/EndUserSPExample/?action=view&#38;current=commentsWithView.gif">Adobe Comments</a></p> <p><a href="http://s905.photobucket.com/albums/ac254/EndUserSPExample/?action=view&#38;current=commentsWithoutView.gif">SP Discussion</a> </p> http://www.endusersharepoint.com/STP/topic/update-list-a-when-a-form-submits-to-form-library-b-and-more#post-11518 Wed, 18 Nov 2009 13:09:39 +0000 NancyCentury 11518@http://www.endusersharepoint.com/STP/ <p>Well, I figured this one out myself. Not awesomely slick or jazzy but it gets the job done!</p> <p>To get the submitted forms to "count themselves" for me, so I could know when the number of items received = the number if items requested, I had to abandon my previous settings of NOT allowing the form to overwrite itself each time a user submitted one to the library. So if 5 users got the notice that they needed to sign off (open the InfoPath form and submit it), instead of getting 5 forms submitted there would only be one, overwritten 4 times.</p> <p>For the first user who submits their form, the "Item Count" field is given a value if 1. Each subsequent overwrite is recognized as a modification to the initial item, so I added a workflow that runs On Change: if Item Count = 1, calculate item Count + 1 and replace Item Count with that new value. So now I am looking at overwritten form properties BUT the Item Count has increased by 1, "counting" itself for me. </p> <p>BUT- this took away my capability of saving the InfoPath data from the promoted properties each time a new person submitted their form. I have to track that for the item owners. </p> <p>So I had to add a second workflow action running on the Form Library ("create list item") to copy all the data to a second list, called 'Copy of Form Data' each time form submission OR overwrite occurs, duplicating my form data fields exactly in the new list (also bringing over the incremented Item Count value each time). So my "parent" form library now only shows one item per instance of the form; but my Copy List shows all data corresponding to each form submission (5 items in the above scenario). For each of the 5 items, the "Item Count" field value is one more than the preceding item. </p> <p>Another field present is "Total Requested," so a third WF running each time a new item is created in the 'Copy of Form Data' list evaluates these 2 fields. If the values are the same, the WF will "know" that all the required forms have now been submitted and the notification of process completion can go to the item owner. So when my 5th person submits theuir form, the form overwrites, the Item Count value goes from 4 to 5, and a copy of the item is created in the Copy List, where THAT workflow recognizes that 5 = 5 and the process is complete for this sign-Off instance.</p> <p>Whew! I hope that makes sense and maybe someone can use it! </p> http://www.endusersharepoint.com/STP/topic/pdf-shared-reviews-in-sharepoint#post-11517 Wed, 18 Nov 2009 13:04:15 +0000 eric 11517@http://www.endusersharepoint.com/STP/ <p>Have you looked into the Document Library and Review Fabulous 40 template? It's actually pretty basic but aggregates comments nicely.</p> <p><a href="http://technet.microsoft.com/en-us/windowsserver/sharepoint/bb407286.aspx" rel="nofollow">http://technet.microsoft.com/en-us/windowsserver/sharepoint/bb407286.aspx</a></p> <p>Freely tryable on wssdemo.com<br /> <a href="http://templates.wssdemo.com/document/default.aspx" rel="nofollow">http://templates.wssdemo.com/document/default.aspx</a><br /> Username:corp\demouser<br /> password: <a href="mailto:pass@word1">pass@word1</a> </p> http://www.endusersharepoint.com/STP/topic/inserting-form-action-workflow-into-survey-finish#post-11516 Wed, 18 Nov 2009 12:57:52 +0000 jbhoward 11516@http://www.endusersharepoint.com/STP/ <p>Paul,</p> <p>Yes, it is copied from SPD XSL from a custom form action button/link.</p> <p>Web services... wouldn't know how to start that process...</p> <p>Thanks for answering. I'll keep looking.</p> <p>Blessings,<br /> Jim Bob </p> http://www.endusersharepoint.com/STP/topic/inserting-form-action-workflow-into-survey-finish#post-11515 Wed, 18 Nov 2009 12:46:15 +0000 AutoSponge 11515@http://www.endusersharepoint.com/STP/ <p>Jim,</p> <p>I've never tried to trigger workflow from JavaScript.</p> <p>Technically, what you entered: "javascript: {ddwrt..." doesn't do anything in the JavaScript world. That looks like XSL you copied from SPD (I could be wrong, it's been a while since I used that stuff).</p> <p>You might be able to use web services to make an entry in another list that will trigger workflow. But by that token, you could just as easily use web services to write the form data to the target list and skip workflow all together. </p> http://www.endusersharepoint.com/STP/topic/datetime-field-cant-pick-past-date#post-11511 Wed, 18 Nov 2009 12:36:24 +0000 AutoSponge 11511@http://www.endusersharepoint.com/STP/ <p>@schundru,</p> <p>Parsing dates in JavaScript isn't exactly fun. There's a way to do it though, how much help do you need on this? Do you have any scripting knowledge?</p> <p>start by reading one of my older articles: <a href="http://autosponge.spaces.live.com/Blog/cns" rel="nofollow">http://autosponge.spaces.live.com/Blog/cns</a>!D7F85948C20F0293!477.entry</p> <p>then read up on javascript date objects (I suggest the W3cSchools site) </p> http://www.endusersharepoint.com/STP/topic/reuse-workflow#post-11510 Wed, 18 Nov 2009 12:02:09 +0000 eric 11510@http://www.endusersharepoint.com/STP/ <p>Work flows aren't portable in the 2007 version of WSS/MOSS. This is changing in the next version. They typically have to be recreated on other lists.</p> <p>What may be possible is saving the original list as a template with content, then creating new lists off of this template. Then open up SPD and see if a new copy of the workflow exists. I haven't tried this so I don't know if it will work. </p> http://www.endusersharepoint.com/STP/topic/pdf-shared-reviews-in-sharepoint#post-11509 Wed, 18 Nov 2009 11:56:21 +0000 msmiley 11509@http://www.endusersharepoint.com/STP/ <p>I've been contemplating this issue for some time now and the only solution I've come up with is mediocre at best (in my personal opinion).</p> <p>First, I would like to list what tools I do and do not have available to me so we don't have to waste time later. I’m working on MOSS 2007 Standard and I can only use solutions that can be implemented with the browser (e.g. a CEWP) or SharePoint Designer. My XML and JavaScript is nowhere near a practical or usable level, but if that's what it takes, I am more than willing to step up and learn it.</p> <p>I do not have access to Visual Studio and nor will I receive access in the future (near or far). Furthermore, no one in my company’s development team will use resources to develop a solution for me; my team is just too small to warrant such an action. I understand that and I’m fine with it.</p> <p>My teammate and I design a variety of graphics/print/media that need to be reviewed and approved. We export PDFs from our design programs, as that is the most universal file format we have available to us.</p> <p>Currently, we gather comments on our PDFs via a Shared Review. There are a couple significant flaws in this:</p> <p>1. Users do not know when new comments have been posted.<br /> a. Trying to educate anyone on tracker has been fruitless.<br /> i. Tracker only checks for comments every hour<br /> ii. Users have to download the PDF and store it locally for tracker to work<br /> b. Users do not respond to other comments because they aren't notified.<br /> c. Users will not manually check the PDF for new comments (can't say I blame them).<br /> d. I must manually send reminders to view the PDF and respond.<br /> 2. Organizing the Reviews in the folder and in Tracker is neither easy nor efficient.</p> <p>However, there are several benefits to the Shared Review:</p> <p>1. We don't receive thousands of emails remarking on the same issue.<br /> 2. We don't receive thousands of emails we have to compile into one set of instructions.<br /> 3. The comments (comment icon actually) can be placed directly on the image or issue so people don't have to describe the location of the image or error (i.e. faster and easier)<br /> 4. Shared Review creates an XML comment file for each invited user, instead of editing the PDF itself.<br /> 5. People can comment at the same time without the risk of overwriting each other.</p> <p>My goal is to leverage SharePoint for the storage, organization and notification of these reviews.</p> <p>When you initiate a Shared Review in Acrobat, you are allowed to upload the file to a document library within SharePoint. There are several good things and bad things to this, however.</p> <p>The Good:<br /> 1. There is one document library for storage and organization.<br /> 2. I can set alerts to the XML folder.<br /> 3. Most of my users are already comfortable with Shared Review<br /> 4. Shared Review creates the XML files and stores them on SharePoint.<br /> 5. The link opens the PDF in the browser and they can make their comments in the browser.</p> <p>The Bad:<br /> 1. Shared Review creates the XML files and stores them on SharePoint.<br /> a. Users would have to put the alert on the folder containing the XML files that hold the comments, not the PDF which is what they would think to do.<br /> b. I would have to manually set/clean the alerts.<br /> 2. Permissions would need to allow Contribute rights to make comments and I don’t want them to be able to touch the metadata I assign or delete the PDF.<br /> 3. In this case, the SharePoint email alert is not user friendly – visually, it doesn’t convey the project name well (because the alert is on the XML).</p> <p>Please note that I do NOT want to create groups of people to send alerts. My audience changes too quickly and there are too many documents; it would be a mess with that many groups of people running around.</p> <p>I do NOT want to use SharePoint’s comments either. Those comments are appended as metadata and users would have to describe the location of the element in question.</p> <p>These PDFs cannot be converted to SharePoint friendly documents such as a word document. I tried it and it doesn’t retain the original look.</p> <p>So, if anyone has any ideas, I’d be happy to see them. </p> http://www.endusersharepoint.com/STP/topic/web-part-background-color-change#post-11508 Wed, 18 Nov 2009 11:19:08 +0000 sasha 11508@http://www.endusersharepoint.com/STP/ <p>Thanks for the advice!<br /> I have used the script to change a few different web parts except for one. For some reason, in edit mode, the border is the correct color I chose. Once I publish it, it changes back to the original themed color. Any ideas as to why this might be happening?<br /> Thanks again for your help. </p> http://www.endusersharepoint.com/STP/topic/data-view-web-part-for-publishing-page-rollup#post-11507 Wed, 18 Nov 2009 11:01:30 +0000 cclamz 11507@http://www.endusersharepoint.com/STP/ <p>Where I work we run MOSS 2007 with publishing for the news articles on our intranet. We use a content query web part with a custom style to rollup the most recently posted articles. This has worked well, but I find that when I want to make a change to the layout, modifying itemstyle.xsl and adding to the CustomViewField property of the cqwp to be overly cumbersome, confusing, and prone to error.</p> <p>What I would really like to do is rollup the pages and style it with a data view web part instead of a cqwp. I know the dvwp well and can style it easily. It also makes filtering, sorting, and grouping easy. I've mocked this up on a test page and it works well.</p> <p>What's strange to me is that I've googled like crazy and have found almost nothing about this. When it comes to rolling up publishing pages, everyone talks about the cqwp, but nothing on using a data view. Can anyone see a problem with using a data view for publishing page rollups? </p> http://www.endusersharepoint.com/STP/topic/cant-connect-current-user-filter-to-dvwp#post-11506 Wed, 18 Nov 2009 10:54:39 +0000 GeorgeW 11506@http://www.endusersharepoint.com/STP/ <p>Does anyone have any ideas on how to make this work, please? </p> http://www.endusersharepoint.com/STP/topic/kpi-percent-complete-calculation-based-on-presence-of-a-date#post-11505 Wed, 18 Nov 2009 09:42:26 +0000 u0010002 11505@http://www.endusersharepoint.com/STP/ <p>I have a custom list which I need to track percent complete. A row in the list is considered "Complete" when a date is entered in a certain field.</p> <p>The problem - the KPI conditions do not seem to work when dealing with a date field! Example- where [Datecolumn]&gt; 01/01/1901 or even when [Datecolumn] = a date value known to exist.</p> <p>One attempted workaround was to create a calculated Yes/No column, if datecolumn &gt; 0 then "Yes", otherwise "No". The values calculates, but (I think) there really is no value in each row.. only at page display time - so any calculation based on this doesn't work either!!</p> <p>I could just slap in another field, and have the users maintain it too.. but I'd like to avoid changing their procedure at this time... </p> <p>Also - note that any solutions have to be on the client side... no SPD or Server side shenanigans! </p> http://www.endusersharepoint.com/STP/topic/quick-launch-not-visible-1#post-11504 Wed, 18 Nov 2009 00:55:11 +0000 illest 11504@http://www.endusersharepoint.com/STP/ <p>What kind of page is having this issue is it default.aspx or a web part page you created in a document library? </p> http://www.endusersharepoint.com/STP/topic/item-level-permissions#post-11503 Wed, 18 Nov 2009 00:51:54 +0000 illest 11503@http://www.endusersharepoint.com/STP/ <p>Either use a workflow to set the permissions or create custom views for each user type to hide what they should not see. </p> http://www.endusersharepoint.com/STP/topic/web-part-background-color-change#post-11502 Wed, 18 Nov 2009 00:48:47 +0000 illest 11502@http://www.endusersharepoint.com/STP/ <p>You don't need to edit the properties of the web parts. If you only want certain web parts to be changed you will need to edit the page layout so that the zone where they are is wrapped in a td or div with an id that you can use to target them with CSS. </p> <p>This post should help. <a href="http://thesug.org/Blogs/kyles/Lists/Posts/ViewPost.aspx?ID=18&#38;RootFolder=%2FBlogs%2Fkyles%2FLists%2FPosts" rel="nofollow">http://thesug.org/Blogs/kyles/Lists/Posts/ViewPost.aspx?ID=18&#38;RootFolder=%2FBlogs%2Fkyles%2FLists%2FPosts</a> </p> <p>Try adding a CEWP to the page and putting this CSS into it.</p> <p>.ms-WPBorder { border-color: #bababa; background: red;}</p> <p>If it works you will know because the background of your web parts will be red. </p> http://www.endusersharepoint.com/STP/topic/item-level-permissions#post-11501 Tue, 17 Nov 2009 23:34:26 +0000 shareidea 11501@http://www.endusersharepoint.com/STP/ <p>Other choices I can figure out is Audience Targeting and <a href="http://www.sharepointboost.com/columnpermission.html">Column View Permission(third part tool)</a>, But if you get lot of items and groups, then it is time consuming and complex. </p> http://www.endusersharepoint.com/STP/topic/list-of-views-for-a-list#post-11500 Tue, 17 Nov 2009 23:26:00 +0000 shareidea 11500@http://www.endusersharepoint.com/STP/ <p>Your question reminds me a tool called SharePoint View Favorite, which allows users to save views and perform several simple manipulate like name, group. I think it is not so useful, but this conclusion seems not true in your situation. </p> http://www.endusersharepoint.com/STP/topic/calculated-column-help#post-11499 Tue, 17 Nov 2009 18:44:12 +0000 Dessie Lunsford 11499@http://www.endusersharepoint.com/STP/ <p>Glad to hear it works...and nice work on the workflow, those can be a bear at times as well so its good to see that you figured out a workaround :)</p> <p>- Dessie </p> http://www.endusersharepoint.com/STP/topic/maintain-approver-comments#post-11498 Tue, 17 Nov 2009 18:19:22 +0000 mfbreakbeat 11498@http://www.endusersharepoint.com/STP/ <p>I found a simple solution that meets my needs - posting in case it helps someone else. </p> <p>I created another list to hold rejected item history (List 2). List 2 has the same columns as List 1. Both lists have versioning turned on. I created a workflow on List 1 in SPD that says if approval status = rejected, copy the list item to List 2. I need to capture the approver comments from List 1 so I created a column called "comments made by approver" in List 2 and I used the update action to populate that field with the contents of the approver comments from List 1. I created another column in List 2 called "List 1 ID", (to link the items in the two lists) then I update that field with the ID # from the rejected item in List 1. </p> http://www.endusersharepoint.com/STP/topic/user-with-contribute-being-denied-access#post-11497 Tue, 17 Nov 2009 18:01:48 +0000 eric 11497@http://www.endusersharepoint.com/STP/ <p>If it was a web policy, then all users would experience it since the group is all domain users. </p> http://www.endusersharepoint.com/STP/topic/content-query-webpart-assign-to-me-filter-does-not-work#post-11496 Tue, 17 Nov 2009 17:40:08 +0000 bmcmann 11496@http://www.endusersharepoint.com/STP/ <p>Wanted to create a Content Query Webpart that would roll up all tasks in a site collection that were assigned to me. Utilized the Assign to Me filter within the content query webpart, and get an error message. Looked at the logs and saw this error...</p> <p>All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists. at the following url: /Locations. Web Part title: Content Query Web Part</p> <p>Looks like the query the CQWP produces does not work. Anyone have any luck in getting the Assign to Me filter to work with the CQWP for all tasks lists in a site collection? </p> http://www.endusersharepoint.com/STP/topic/calculated-column-help#post-11495 Tue, 17 Nov 2009 17:31:09 +0000 bmcmann 11495@http://www.endusersharepoint.com/STP/ <p>Thanks for the explanation, which makes perfect sense. I was balancing having formulas that might be easier for a client to maintain - since they are not experts in calculated columns - and ensuring that they will work.</p> <p>Your replies were extremely helpful and helped me get to where I needed to be - so yes, I have a solution that is working now. One interesting tidbit however. Another component of this was having a SPD workflow that would populate a Date Completed column based on when the value of the status column was changed to completed. SPD will not populate the time it was done - it always resorts to 12am. </p> <p>So I had to create a string variable in SPD and set that variable to the current item modified field. Then in the actions portion of the workflow step, I set the value of the date completed column to that variable (the column is a single line of text column). Then I have a calculated column (formatted as Date and Time) that takes the value of the Date Completed column with the formula =[Date Completed]. </p> <p>So a calculated column comes to the rescue of a limited SPD feature for not being able to display the proper time when you select the today parameter for setting a value of a date/time column within SPD. </p>