Hot answers tagged

6

Have you tried setting the DisableFilter property to true?


6

If you have Content Type management enabled for the list (if you see a list of content type with the option to add more), the display order of columns is set for each content type. Drill down into one of them and you'll see the option under the list of columns for that content type.


4

Since you are using strings as the data type, you need to format the data differently so that they sort correctly based on alphabetical order, ie 01.0.0 02.0.0 02.0.1 03.0.0 03.0.1 03.1.0 10.0.0 10.0.1 11.0.0


3

Simplest possible solution is to include section number in group field: 1. Permissions 2. Requirements Problem is that you can apply sort on groups only on group field. So if you use number in front of group name you can get desired results.


3

If you convert that view to a data view web part in Sharepoint Designer, you can build your own sorting logic and you should be able to sort by the nodeset average.


3

Do you use Publishing features? Normally you can changer order in Quick Launch settins from Site settings, Look and Feel column. You can find step by step guide here http://support.sherweb.com/Faqs/Show/how-to-change-the-order-of-the-items-in-the-quick-launch-of-sharepoint-sharepoint-2007 for example.


3

If ArticlePriority is a choice column then null values will be sorted before the ones with values. One solution could be to create a hidden calculated column with the formular something like =IF(ArticlePriority=0,9999,ArticlePriority) and then order by that column


3

The internal name of the field is PublishedDate. Try changing your query to use that name and hopefully that will solve the problem.


2

While not exactly like your accounting structure, you could name them P01, P02, etc and it will sort as you'd expect.


2

If publishing feature is enabled or you created site using publishing template, http://office.microsoft.com/en-us/sharepoint-server-help/customize-navigation-links-on-the-quick-launch-HA010255192.aspx#BM10 If not, you have to use code to sort it...Example here ...


2

I think the problem is that you on post backs do not create the ObjectDataSource object and configure the SPGridView object. Refactor your code to do this in the CreateChildControls() method that you must override from the base class. Also call grid.DataBind() in the PreRender phase and not in the Render phase. Here is another useful article on the ...


2

You need to customise the DVWP within SharePoint Designer. In this, you can enable sorting for columns as well as enabling pagination. further enhancements require you to edit the underlying XSLT behind the web part, which you can also do in SharePoint Designer.


2

You can configure a view with the sort you want, and use that as your RSS feed. Append: ?View=<View ID> You can also get the full URL of the view's RSS by clicking the little RSS icon next to the view's Name in the Edit View page. I'm not sure there is a way to sort the default feed, it doesn't seem to be using the default view.


2

You can write values as 00.00.000 (eg. 01.11.345). Not the best solution but the easiest one. More complex one is to write your own Custom Field Type. Also take a look at SharePoint MaskedEdit Field Control and Input-Masking in SharePoint Forms. Not exactly what are you looking for but just as idea (never tested it myself).


2

Your data is formatted as x.y.z, and you need 3 ordering rules: x ascending, then y ascending, then z ascending. You could use 3 columns to store x, y and z. You would apply the sorting criteria, and for rendering you would use a calculated column: =x+"."+y+"."+z If it's too many columns to handle, then you would have to use the 00.00.000 format suggested ...


2

Yes, you will need to implement a custom solution to accomplish this. The OOTB results Web part is unfortunately hard-coded for sorting by relevance or modified date. This limitation is first removed with SharePoint 2013 Search where managed properties can now be registered as sortable. In SharePoint 2007, you can implement custom sorting using the ...


2

You could sort list items using array.sort function: function getListItems(listTitle,success,error) { var ctx = SP.ClientContext.get_current(); var list = ctx.get_web().get_lists().getByTitle(listTitle); var items = list.getItems(SP.CamlQuery.createAllItemsQuery()); ctx.load(items); ctx.executeQueryAsync(function() { success(items); ...


2

As ModifiedOWSDATE is a STRING, you will need to parse it into a date format. Now, check your machine Regional settings (and even SP server settings), client not matching server for the date format as you say 11/05 is swapped to 05/11...?


2

Modify your view and choose Show items in ascending order (A, B, C, or 1, 2, 3) Now SE should not come before IT, see my screenshot


1

Modify your view and apply the sort as in the image. Make sure you select the check box.


1

You could add a number column to the list, call it, say, "Sort Order", and then create a view that sorts on the values of your "Sort Order" column.


1

You have to set the JSON property of your Web Part. It sounds weird as you don't want the dropdown with the available sorts order displayed. You just have to tweak the JSON property to add the RefinableDate01 and then uncheck the "Show sort dropdown" property so the sort box isn't displayed but the JSON will remains. REF: ...


1

As it turns out, I changed over to using FirstName and it worked. In digging around I found the following: Go to Central Admin, Go to Service Application, Search Service Application, Search Schema (left menu) Type in the Managed Property Name, ensure that it has "Sortable" as Yes (Active). And then, I guess, wait for the next crawl for it to work.


1

The default sort order is Relevance. You can change this to any sortable Managed Property if you like, for example Last Name for People (if you make the Last Name property Sortable).


1

You think that Event Date column is Date Time but it is written as Text in Managed properties and you use that property for sorting. For sorting to work properly you need link Crawled Property ows_q_DATE_EventDate to one of predefined Date Managed Properties (Date00-Date09) Go to Site Settings. Under Site Collection Administration click Go to top level ...


1

You mention jQuery, but it can be done without. SharePoint 2013 has its own subset of jQuery called mQuery So a (rather brute) method is to replace all html inside the TH tags with its own label (from the A tag) EnsureScriptFunc('mQuery.js', 'm$', function() { m$('[id^=diidSort]').forEach(function(tag){ if(tag.tagName==='A'){ ...


1

ok, im presuming that you are creating the list using xml and not querying in .cs? whats the full code and are you doing it like this? <Query> <OrderBy> <FieldRef Name="SomeUserField"/> </OrderBy> </Query> You dont need to add in ascending = true as by default it is ascending. You only need to use it if you ...


1

The sorting of Lookup columns (and a SPFieldUser is just a lookup column into the User Information List) depends on the LookupField of the lookup column. If you define your User field to display as one of the Name columns then the sorting of your Query should by the display name of the user.


1

DISCLAIMER: NOt sure if code based solution would work for the user as it is unclear to me where exactly it is being used. But if user has opportunity to write code to sort the versions, following algorithm is strong and will work without any workarounds like prefixing with 0 etc. ANSWER: You just need to write a custom comparer and sort it using custom ...


1

Change the order of the columns in the list's settings (or the content type)



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