Query Subfolder

Forums vLooup for SharePoint Query Subfolder

This topic contains 2 replies, has 2 voices, and was last updated by  Alexander Bautz 2 months ago.

  • Author
    Posts
  • #18376

    Michael
    Participant

    Hi,
    i’m not sure what exactly i’m doing wrong.

    I just want to Show items from a specific Folder, so i use the following query:

    <Query><Where><IsNotNull><FieldRef Name=’ID’ /></IsNotNull></Where></Query><QueryOptions><Folder>myLib/CustomFolder</Folder></QueryOptions>

    When i use this query e.g. in the query builder tool, i only recieve the Contents of this Folder. When i add it to the vlookup query configuration, all items / Folders in the library are shown.

    Can you please give me a hint what i’m doing wrong?!

    Regards,
    Michael

  • #18400

    Alexander Bautz
    Keymaster

    Hi,
    Based on the CAML syntax you are not doing anything wrong, but unfortunately I haven’t added support for specifying the QueryOptions like this in the vLookup setup.

    I’ll see what I can do about it in the next release.

    Alexander

  • #18402

    Alexander Bautz
    Keymaster

    I did another test and found that you can use this in the “Write your own CAML-query” field:

    <Where><Eq><FieldRef Name='FileRef' /><Value Type='Text'>SITE_URL/DOC_LIB/SUBFOLDER</Value></Eq></Where>

    Alexander

You must be logged in to reply to this topic.