Blog

i am getting only 1000 rows in csv and excel when i am applying group by query in my collection and also get wrong number of records in grid pager. $ collections->getSelect()->group(‘main_table.name’); if i am comment this line all works fine. let me know if you need more info.Read more

I have a WebPart that has a custom query attached to it. The presentation of the WebPart is also hard coded to the WebPart. How can I change the WebPart Properties to GroupBy Month rather than site. Please find below the code to my WebPart <webParts> <webPart xmlns=”http://schemas.microsoft.com/WebPart/v3″> <metaData> <type name=”Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart, Microsoft.SharePoint.Publishing, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c”Read more

I have a list lst matching the pattern {{_String, _String, _?NumericQ, _?NumericQ}..}. The outer list has about 150,000 elements (inner lists), so it is certainly not very long. When I run: lst // GroupBy[(#[[2]] &) -> (Drop[#, {2}] &)] // Map[GroupBy[First -> Rest]] the code takes about 0.4 seconds to return the result. But whenRead more

I have a dataset, and I want to group by one of my columns, and then show the Length of another set of columns for each group. For example: letter color a red a red a blue b blue I want my new dataset to show: red blue a 2 1 b 0 1 whereRead more