Hot answers tagged filter
4
SharePoint List Filter web part is rendered as input text field for displaying filter value:
<input type="text" readonly="readonly" id="{ClientID}_SpListPicker_SelectionBox" title="Selected values" >
and input hidden field for storing filter value:
<input type="hidden" id="{ClientID}_SpListPicker_Selection" value="{FilterValue}">
Below ...
4
It is possible to accomplish with OOTB Metadata Navigation and Filtering Feature using Navigation hierarchies control.
Navigation hierarchies control allows to select an item in a hierarchy for a managed metadata column with filter for
single Term
Term with descendant child terms
Applying filter in Navigation hierarchies control corresponds to ...
3
The filter that worked for my library view... to show only "ABC" related folders and documents is shown below. Remember that SharePoint appears to be unix-based in that things are case-sensitive, so where "Folder" worked in the below filter, "folder" did not. Also note that, since most users who are creating folders don't apply categories, I used the "Name ...
2
Per Jakobsen has a very nice solution. You don't need to "muck up" anything, Chris! The only thing I have to add is to show how the REST url can be automated. Look at this:
var date = new Date(), //or some relevant date
filterFormat = "$filter={0} gt datetime'{1}'",
filterQuery = String.format(filterFormat, "Created", date.toISOString()),
url = ...
2
Well I'm using SharePoint Online and for me the webpart is working.
You can see how to connect the filter on my screenshot.
I guess your problem is you're not using internet explorer or you are blocking popups (as the connection menu is blocked by default).
2
Try to create calculated field based on your two columns that returns true if one of your columns is a substring of another and false otherwise. Use FIND function:
http://office.microsoft.com/en-us/windows-sharepoint-services-help/examples-of-common-formulas-HA010105479.aspx
Then create list view filter based on the calculated column.
2
Yes you can use CAML:
http://abstractspaces.wordpress.com/2008/05/05/caml-query-lookup-field-by-id-not-by-value/
or you can use this:
http://filteredlookup.codeplex.com/
or
How to make a filtered lookup field
2
AllItems.aspx is a view and as such it expects to display multiple items which is why the second approach works. That syntax creates a filter on the view based on the ID field and shows the ID you specify. This is the same thing that happens when you filter on a column from a view.
If you are looking to link directly to an item, the URL would be something ...
2
Unfortunately, as you've discovered, it isn't possible out of the box.
You can upgrade to SharePoint 2013 and PerformancePoint Services 2013 which now includes filter search. See What's New in PerformancePoint Services 2013. Not exactly the same as auto-complete, but pretty dang close.
Or, you could look at creating your own filter using the SDK. See ...
1
Without knowing your site structure or the structure of the data, the only reliable way would be to create custom Search Scopes and configure them to include only the desired content for those specific categories. You would then add the proper scope to the querystring when building the link.
A possible alternative is available if the desired filter can be ...
1
Follow these steps:
1- You can Edit the page from Browser: Ribbon -> Page -> Edit
2- Double click the ListView Web Part header: Ribbon -> Edit Web Part Properties
3- In Web Part Properties: Edit current view
4- In Edit View page, add filter to your field
5- Click save and you can see the filtered results!
1
It seems unlikely that they did not reuse the Query parser from the list/view/query in the web services. IF that is the case you could experiment your way into the answer using this tool:
http://www.codeproject.com/Articles/458008/CAML-Query-Builder
Point it at the list you want to target and make the most complex query you need and see how it works. Once ...
1
You need to specify the RegistrationType="ContentType" and RegistrationId="0x0101005e4b5d5098e94baba80f8d1ccf9eb507" attributes of the custom Action. Follwoing is the example:
<CustomAction
Id="ExportVersionHistory.DisplayForm"
RegistrationType="ContentType"
RegistrationId="0x01"
Location="CommandUI.Ribbon.DisplayForm"
...
1
You could programmatically create n views that would filter the list for the specific terms with the term has the view name.
If the number of locations is not so huge and rarely updated, I would create a small PowerShell script that would do the job proactively, otherwise, I would suggest creating a timer job that check for missing view based on available ...
1
You can simply achieve this by using webpart connections.
Let's say you already have a webpart page with the two webparts, one below the other, and there is a lookup column in the employees list to the department list, as you said in your question.
You just have to edit your web part page and select from the webpart dropdown menu Connections-> Send Row of ...
1
you can do 3 step with NINTEX component
step 1- define a workflow
Note : with graphic UI (Nintex designer) you can easily make a workflow steps you want
step 2- define parameter in named [TEMP DATE]
step 3- create a view : with filtering this Date Column
1
step 1- create a column named [TEMP DATE]
step 2- define a workflow
Note : when we want to track any changes in a SharePoint records , we can start a workflow.
you can define a workflow on changes in all records with SharePoint Designer to make a copy of modification date to [DATE TEMP] (that we create in step 1) for keep and hold modification date if ...
1
I think you should try using Content Query Webpart(CQWP) in your site.
You can fetch data from your parent site by using it.
here is a link which might be helpful.
http://pravahaminfo.blogspot.in/2012/02/content-query-webpart-cqwp-in.html
1
Unfortunately the filter doesn't support any advanced formulars. The only formulars are today +/- some days.
You may solve your problem by creating a calculated column CreatedWeekday as WEEKDAY([Created],2)
Then on you view you can use the filter:
CreatedWeekday Equals 5
AND
Created Greater than [Today]-8
AND
Created Less than [Today]
1
I think you have to trigger the new Request. My solution would be to Request __doPostBack and handle your Params via the Request properties.
In your case it would be:
var dates = new Array();
dates [0] = stringstart;
dates [1] = stringend;
__doPostBack("Button1", dates );
In the code himself these could be accessed by:
Request["__EVENTARGUMENT"];
1
Yes very easy even, via SharePoint Designer:
Go into your page use the Insert menu, choose Empty data View.
Click the in page on the "Choose data Source Details" and choose your target list.
From the Data Source windows choose fields to show and via the button "Insert Multiple Item View". Then choose from the Design your required. Now you should have all ...
1
Department Name should be a lookup column in the Classes List. The Class Name should be a lookup column in the Intiative List. By doing this , you create the basic foreign key relationship as depicted in the diagram.
The above should give you the basic structure to build customized queries on aggregated results from these lists using Dataview webpart. This ...
1
I am going to cover a few things as I don't know exactly what you're doing here.
1) Create a calculated column to display the first letter of your field using formula - lets call this "FirstLetter"
=LEFT([YourFieldName],1)
2) Optionally, you can then use the Group By feature to show a collapsed/expanded list on [FirstLetter] - (see "The By Last Name View" ...
1
SharePoint CAML queries work in pairs when it comes to filtering and I am fairly certain that the out of the box list view filters work in the same way and are probably CAML behind the scenes. When working with the pairings, I believe SharePoint always groups the top most items first.
Using your example I was able to get what I thought was the expected ...
1
Have a look at these solutions:
http://geekswithblogs.net/SoYouKnow/archive/2011/01/26/sharepoint-list-views-ndashquick-amp-easy-jquery-filter.aspx
http://www.bentedder.com/create-a-jquery-sharepoint-instant-searchfilter/
http://www.cyclingjames.com/sharepoint/filter-the-current-sharepoint-list-view-as-you-type/
...
1
If you want SPSiteDataQuery functionality along with caching, better to use CrossListQueryCache and CrossListQueryInfo classes.
Check here for excellent details : http://extreme-sharepoint.com/2012/07/17/data-access-via-caml-queries/
Only top voted, non community-wiki answers of a minimum length are eligible
