Yes I did

    public ActionResult GetNewsByParentId(int Id,int PageIndex = 0,int PageSize = 10, string filter = null)
    {
        //are there children for this content id?
        bool hasChildren = Services.ContentService.HasChildren(Id);

        IEnumerable<IContent> Children = Services.ContentService.GetPagedChildren(Id, PageIndex, PageSize, out long TotalChildren, null, Ordering.By("CreateDate", Direction.Descending, null, false));

        //create Json object
        var result = new JsonResult
        {
            Data = new
            {
                 TotalChildren
                ,PageIndex
                ,PageSize
                ,Children
            },
            JsonRequestBehavior = JsonRequestBehavior.AllowGet
        };
        return result;
    }

The extra info from the class ordering https://github.com/umbraco/Umbraco-CMS/blob/853087a75044b814df458457dc9a1f778cc89749/src/Umbraco.Core/Services/Ordering.cs

when using custom fields set the last property on true and use your custom field

In my case it's 5

It's just giving me "{Umbraco.Core.Models.Content[0]}"

I can't step in to it.. https://ibb.co/xm3ZLbx

Thank you! :D

you're welcome

Thanks!

I can't get it to filter en a custom property..

var filter = SqlContext.Query<IContent>().Where(x => x.GetValue<DateTime>("date", culture).Year == year && x.IsCulturePublished(culture));

I get this error:

"an expression tree may not contain a call or invocation that uses optional arguments"

Thomas

I am stuck on that too, for now, I believe you can only use:

Id, Name, Key, VersionId, Trashed, Path, SortOrder, ParentId, CreateDate, UpdateDate, Level, ContentTypeId, CreatorId, Published

I am goining to create a featue request on github, hopefully It will get some extra explanation.

Cool, Thanks for your help !

Hi Thomas,

For your question I think it implies you are using a non Static method.

public static string YourMethod() { ... }

or create a new instance (this is my working example)

public ActionResult GetNewsByParentId(int Id,int PageIndex = 0,int PageSize = 10, string filter = null)
{
    var Filter = SqlContext.Query<IContent>();

    if (filter != null)
    {
         Filter = Filter.Where(x => x.Name.Contains(filter));
    }
    else
    {
        Filter = null;
    }

    IEnumerable <IContent> Children = Services.ContentService.GetPagedChildren(Id, PageIndex, PageSize, out long TotalChildren, Filter, Ordering.By("CreateDate", Direction.Descending, null, false));
 var result = new JsonResult
        {
            Data = new
            {
                 TotalChildren
                ,PageIndex
                ,PageSize
                ,Children
            },
            JsonRequestBehavior = JsonRequestBehavior.AllowGet
        };
        return result;
    }

On the otherhand:

I do not think Umbraco is going to fix this problem properly because al the data is saved as a Json object in the Database. And you can only query Json nativily from sql server 2016. So that you can write querys that can query Json object.

I think it would be a better solution to create a own stored procedure and add all the parameters you want to query. This will work better then the current native Umbraco function.

If you are using sql server 2016, you can use Json query (https://docs.microsoft.com/en-us/sql/t-sql/functions/json-query-transact-sql?view=sql-server-2016) Otherwise ==> https://stackoverflow.com/a/23724200/2910930

regards

Thanks for your reply !

I actually ended up using the content service and quering and filtering on that.

IEnumerable<IPublishedContent> content = Umbraco.Content(pageId).Descendants().Where(x => x.IsVisible() && x.ContentType.Alias == "articlePage").OrderByDescending(x => x.Value("date"));

And then for that pageing and pagesize:

IEnumerable<IPublishedContent> CurrentContent = content.Skip((page - 1) * pageSize).Take(pageSize);

Thanks :)

Is this way one of the common pitfalls https://our.umbraco.com/documentation/reference/common-pitfalls/?