Using a pre-define list view

Forums SPJS Charts for SharePoint Using a pre-define list view

This topic contains 4 replies, has 2 voices, and was last updated by  Phil Grant 3 months, 2 weeks ago.

  • Author
    Posts
  • #16030

    Phil Grant
    Participant

    Hi,
    I’ building a chart on a pre-defined List view that I’ve created in Sharepoint, this vie limits the items to a specific project of a specific filetype and groups by project and has a item limit of one.

    The idea is to give me the latest items for each project but limited to specific projects.

    This looks great in SharePoint and works fine but when I use it as the source for a chart I get all the possible projects, If I use CAML for filtering I can improve the situation but I get counts that are much higher than they should be as if the values from entries that should not be included are included.

    The SharePoint pre-defined filter effectively gives me the latest item for each project I’ve pre-defined.

    Is my understanding wrong, if I have a pre-defined listview should the chart only use this data?

    Cheers,
    Phil

    • This topic was modified 3 months, 3 weeks ago by  Phil Grant.
  • #16040

    Alexander Bautz
    Keymaster

    Hi,
    If you want to use the list view as source you must NOT use the “Use custom CAML” option in the “Filter and Custom CAML” tab.

    Is this the issue?

    Alexander

  • #16092

    Phil Grant
    Participant

    No, even if I don’t use custom CAML filter I get the problem, I only tried CAML after the initial Chart displayed too much information.

    Phil

  • #16102

    Alexander Bautz
    Keymaster

    Not sure if this is the issue, but when using a predefined view as source for a chart, only the CAML query will be used and not paging or itemlimit settings.

    Have you applied any such settings to your list view?

    Alexander

  • #16105

    Phil Grant
    Participant

    AH! OK that’s probably it then, I do use the Item limit of 1 and group by project to give me the last document added for each project.

    Cheers

You must be logged in to reply to this topic.