Hot answers tagged

5

Your caml query should have <Value Type="Lookup">9</Value> instead of <Value Type="Integer">9</Value>


3

You need to use below updated code as your CAML query. SPQuery query = new SPQuery(); query.Query = "<Where><And><Eq><FieldRef LookupId='TRUE' Name='Program'/><Value Type='Lookup'>6</Value></Eq><Eq><FieldRef LookupId='TRUE' Name='Responsible_x0020_Group'/><Value Type='Lookup'>9</Value></Eq&...


3

You don't have to go the CSR route but some JavaScript is required. You already know the HTML in Calculated Column trick... Let's extend that, the data you are after is in the global ctx object disclaimer; I did not test this exact code, might be typos ="<img src=""/_layouts/images/blank.gif"" onload=""{" &"var TR=this.parentNode.parentNode....


2

You could use Audience Targeting on the List View Web Parts. For instance for the default LVWP for your document library, set its target audience to be the Teachers group. Then add another LVWP for the same document library to the same page, set its target audience to be the Students group, set up a view for that LVWP that filters by Created by = [Me], and ...


2

Welcome to the site. What happens when you add site columns to a list or content type is that a copy of that column is taken and added to the list or content type. For this reason, if you were to delete the columns from the list or content type, you would only ever be deleting the copy. Are you using content types in your list? If so, go to your list's ...


1

You can set up a Yes/No calculated field with the following formula. =IF(OR(MID(Title,7,1)="7",MID(Title,7,1)="6",MID(Title,7,1)="5"),"Yes","No") Just change "Title" to your Tracking Number field.


1

You can use filter WebPart for multiple filters.When you want to filter between two dates then you need to use SP Designer to pass parameters.And for by default functionality SP only provide Choice filter WebPart not any specific to dropdown. Find the screenshot below I used to filters Choice filter and Text filter and applied both.The two filter are ...


1

When you open a document through the SharePoint UI with IE, it is being opened via an ActiveX control: <A onclick="return DispEx(this,event,'TRUE','FALSE','FALSE','SharePoint.OpenDocuments.3','1','SharePoint.OpenDocuments','','','','18','0','0','0x7fffffffffffffff')" onfocus=OnLink(this) href="/sites/MySite/Library/some.docx">some</A> When ...


1

I'm not sure about preventing access to a view, but you could prevent access to the documents. I've had this requirement before, so I create a SharePoint 2010 list workflow with an impersonation step that, when the document is created/uploaded, permissions are replaced with the user who created it, and whoever else needs access. I try to use groups as much ...


1

Another option is to include them in the view to get the data on the ctx.CurrentItem object, but then use CSR to ultimately hide them. Even if you use Danny Engelman's workaround, you will still need to include that column in the view. You are correct in noting that in order to get the data, you will either need to include the columns in the view, or make ...


1

You stuff the Item data you need in a Calculated Column and use that Column(value) to proces the Item in your CSR code But.. you can't get complex fields like Lookup, Multiple Choice into a Calculated Column. =[Title] & "," & [Priority] & "," & [Status] Then in your CSR code: var values = CTXITEMVALUE.split(',');


1

Here's a viable approach: Add web parts X and Y to your page as normal. Use audience targeting to make web part X visible only to Group A. Add a content editor web part that uses CSS or JavaScript to hide web part Y (setting its root element's style.display property to "none"). Apply audience targeting to your content editor web part so that it only ...


1

Views cannot have security applied to them. They can have audiences. There is a difference in that you are not preventing access, but directing users to relevant information. As a point of note, search results of the list will return all results.


1

You can set permission on the list level easily from the list settings page. navigate to the that page and under permission, you will have to break the inheritance and grant these people (direct adding of each of these individuals a read only access). Once you do that, all the list views will inherit the permissions from the list


1

In OOB SharePoint, any user with read access can navigate to any views and we don’t have any permission which can be applied on the list view. Please refer the workaround for the same in below given link. How to set View level permission for a List/Library in SharePoint


1

As SharePoint does not support to have hyperlink column as lookup field, you might have to use some additional scripting to get the desired solution. You may try following steps to get the desired output. Create CourseLink column in COURSE list as Single line of text. Update Course lookup column in ROLE-COURSE list as shown in following screenshot. i.e. ...



Only top voted, non community-wiki answers of a minimum length are eligible