vLookup in List View

Forums vLooup for SharePoint vLookup in List View

Viewing 28 reply threads
  • Author
    Posts
    • #6570
      David S Kaimann
      Participant

      I’ve upgraded to the 2.0 version of vLookup (used both 2.000 and 2.002); however, I can no longer see my vLookup Column in ListView. Everything is working fine on the DispForm page and I’ve modified the code below my ListView to match what’s in the User Guide, but still no luck. Any chance you can confirm if there’s something I’m doing wrong? I’ve attached a file with more information.

      Thanks!

      Attachments:
      1. vLookup-Issue.docx
    • #6572
      Rich Rockwell
      Participant

      I’m having the same issue.

    • #6573
      avala
      Participant

      I am experiencing this issue as well.

    • #6597
      Alexander Bautz
      Keymaster

      Sorry for the delay, do you get any errors in the developer console (hit F12 > Console)?

      Alexander

    • #6607
      Rich Rockwell
      Participant

      I hope this is what you are looking for. Let me know if it isn’t.

      Object expected, line 687 character 1
      (line 687: ExecuteOrDelayUntilScriptLoaded(_initTRAWebPartWPQ2, “sp.ribbon.js”);window[‘heroButton’ + ‘WebPartWPQ2’]…
      Stepping through, next error is line 688 character 7, ‘ContextInfo’ is undefined, then a series of ‘ctx’ is undefined errors

    • #6610
      Alexander Bautz
      Keymaster

      Hi,
      Sorry, but this error does not sound like it originates from vLookup. It may cause vLookup to not function, but I cannot see that it is the source of the error.

      Anything else that might give me a clue as to what could be wrong?

      Alexander

    • #6618
      avala
      Participant

      I’ve run through the setup a few times and checked the developer console, but I’m still not seeing anything. I’ll keep looking though.

    • #6619
      Rich Rockwell
      Participant

      I repeated loading the view with IE developer tools and now I don’t see any errors. The child items from my vLookup list are still not showing, and I’m not seeing any errors.

      I tried using FireFox and here are some lines I see:

      [16:44:34.883] GET http://…/spjs-utility.js [HTTP/1.1 401 Unauthorized 16ms]
      [16:44:34.884] GET http://…/DFFS_frontend_min.js [HTTP/1.1 304 NOT MODIFIED 16ms]

      then a number of search.css warnings, then

      [16:44:34.996] GET http://…/spjs-utility.js [HTTP/1.1 401 Unauthorized 16ms]
      [16:44:35.090] GET http://…/spjs-utility.js [HTTP/1.1 304 NOT MODIFIED 31ms]

      Let me know if you can suggest some specific steps for troubleshooting.

      Thanks

    • #6623
      Alexander Bautz
      Keymaster

      Hi,
      I cannot recreate this error, can you confirm that the list view actually works with v1.7x of vLookup?

      Alexander

    • #6624
      David S Kaimann
      Participant

      Yes – this always worked in prior versions of vLookup for me – it only stopped working with the 2.0 version. I tried using the Console as well and didn’t see any errors at all.

    • #6625
      Alexander Bautz
      Keymaster

      OK, I have a suspicion as to what the cause could be. Can you help me verify it by adding this code to the CEWP that you use in the list view:

      <script type="text/javascript">
      setTimeout(function(){
      	spjs.vLookup.init();
      },1000);
      </script>

      You should add it just below this line:

      <script type="text/javascript" src="/[your path to the file]/vLookup_frontend_min.js"></script>

      This will initiate the vLookup script “manually” after 1000 milliseconds.

      Let me know if this works and I’ll look into a fix.

      Alexander

    • #6626
      avala
      Participant

      I just tried adding the new script to the CEWP and no luck. Tried on both a grouped and a non grouped view.

    • #6627
      David S Kaimann
      Participant

      No change for me. Here’s the full content of my CEWP, which is below the List WebPart.

      <script type=”text/javascript” src=”/sites/splqtmmy/Email/SiteAssets/DFFS/jquery.min.js”></script>
      <script type=”text/javascript” src=”/sites/splqtmmy/Email/SiteAssets/DFFS/spjs-utility.js”></script>
      <script type=”text/javascript” src=”/sites/splqtmmy/Email/SiteAssets/DFFS/vLookup_frontend_min.js”></script>
      <script type=”text/javascript”>
      setTimeout(function(){
      spjs.vLookup.init();
      },1000);
      </script>

    • #6628
      Rich Rockwell
      Participant

      I tried it with 1.731 and it works. I got prompted for the configuration and supplied all that, then it worked.

      I also tried the troubleshooting code above and no luck. I get the following ‘Error on page’:

      Webpage error details

      User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.2; .NET4.0C; .NET4.0E)
      Timestamp: Tue, 18 Nov 2014 17:12:51 UTC

      Message: ‘spjs.vLookup’ is null or not an object
      Line: 963
      Char: 24
      Code: 0
      URI: http://{MyDomain}/Lists/Librarian%20Sites/Sites%20by%20Requests.aspx?toolpaneview=2

      • #6630
        avala
        Participant

        1.731 is working for me as well. I also tested vLookup 2.0 in Firefox, Chrome, IE 10, IE 10 compatability mode, 9 and 8 with no luck.

    • #6631
      Alexander Bautz
      Keymaster

      Hi,
      I’m struggling to recreate this. Is it possible for me to access a site where I can see this problem “live”?

      If some of you can give me access, please email me – you find my email in the “About me” tab in the top of this page.

      Alexander

      • #6645
        avala
        Participant

        Unfortunately we cannot give you access inside our firewall. 1.731 is working for us now. Thanks for looking into it. I’ll continue to tinker as time allows.

    • #6635
      Rich Rockwell
      Participant

      Thanks for trying, Alexander. I’m afraid I can’t give you access. I’m with a large banking/financial institution and all my work is behind their firewall. I hope someone one else is able to get you access to their system.

    • #6644
      Joseph Mayo
      Participant

      Hey Alex I am having the same issue with 2.002. I am on SP 2010 server, ie9. No errors on f12 script pane. Works fine in the new/edit/display forms.

    • #6647
      Alexander Bautz
      Keymaster

      Hi,
      I had completely forgotten that I had rigged some basic debug alerts in the vLookup frontend – try adding this to the URL:

      .../AllItems.aspx?vLookupDebug=1

      This should produce three alerts for each vLookup column in the view (blob, query and itemcount).

      Let me know if someone of you can test this, and If you get NO alerts I’ll rig a new debug version that does it more thoroughly.

      Thanks for the patience,
      Alexander

    • #6651
      Rich Rockwell
      Participant

      Thanks, Alexander. I tried this and I get no alerts. I assume you mean to just enter ?vLookupDebug=1 after the name of the view on the view page. I tried that on 2 views, and I get no alerts.

    • #6652
      Alexander Bautz
      Keymaster

      I have rigged a new DEBUG version of vLookup frontend. Get it here: http://spjsfiles.com/index.php?dir=SharePoint+JavaScripts%2FvLookupForSharePoint%2FSP2010+and+SP2013%2FDEBUG%2F

      Post the output in a new comment in this topic.

      Alexander

      • #6655
        avala
        Participant

        After updating to the new Debug version V2.0 is now working. I’m not sure if you changed anything, but I’m glad to see it’s working!

        Update: I switched back to the pre-debug vLookup_frontend_min and it appears to be working. Confused, but grateful.

        • This reply was modified 4 years, 11 months ago by  avala.
    • #6657
      David S Kaimann
      Participant

      Thanks for the debut file! It still isn’t working for me, but below are my results when running the debug in both ListView and DispForm:

      List View
      vLookup DEBUG output:
      Waiting for sp.js to load and call spjs.vLookup.init…
      vLookup initiated.
      Found list view.
      Processing field “vLookup” in list “template%20and%20letter%20requests”.
      <Where><Eq><FieldRef Name=’Title’ /><Value Type=’Text’>template%20and%20letter%20requests:vLookup</Value></Eq></Where>
      Found 0 configuration for vLookup
      vLookup initiated.
      Found list view.
      Processing field “vLookup” in list “template%20and%20letter%20requests”.
      <Where><Eq><FieldRef Name=’Title’ /><Value Type=’Text’>template%20and%20letter%20requests:vLookup</Value></Eq></Where>
      Found 0 configuration for vLookup
      vLookup initiated.
      Found list view.
      Processing field “vLookup” in list “template%20and%20letter%20requests”.
      <Where><Eq><FieldRef Name=’Title’ /><Value Type=’Text’>template%20and%20letter%20requests:vLookup</Value></Eq></Where>
      Found 0 configuration for vLookup
      vLookup initiated.
      Found list view.
      Processing field “vLookup” in list “template%20and%20letter%20requests”.
      <Where><Eq><FieldRef Name=’Title’ /><Value Type=’Text’>template%20and%20letter%20requests:vLookup</Value></Eq></Where>
      Found 0 configuration for vLookup

      DispForm
      vLookup DEBUG output:
      Waiting for sp.js to load and call spjs.vLookup.init…
      vLookup initiated.
      Did NOT find list view.
      Processing field “vLookup” in list “template and letter requests”.
      <Where><Eq><FieldRef Name=’Title’ /><Value Type=’Text’>template and letter requests:vLookup</Value></Eq></Where>
      Found 1 configuration for vLookup
      Field: vLookup

      blob:
      {“listName”:”Template and Letter Requests”,”listBaseUrl”:”/sites/splqtmmy/Email”,”query”:{“fin1″:”Hotkey”,”type1″:”Text”,”value1″:”CON CK COLLEGE”,”fin2″:”ID”,”type2″:”LookupId”,”value2″:”4″,”fullCAML”:””,”AndOr”:”And”,”operator1″:”Eq”,”operator2″:”Neq”,”orderBy”:”ID”,”orderAscending”:false,”rowLimit”:””},”childTableHeight”:””,”viewFields”:[{“fin”:”Request_x0020_Type”,”settings”:””,”disp”:{“default”:”Type of Request”}},{“fin”:”Title”,”settings”:””,”disp”:{“default”:”Template Title”}}],”action”:”concat”,”action_groupBy”:”Status”,”action_groupByHeaderStyle”:””,”action_groupByExpanded”:true,”action_groupByPrefix”:{“default”:””},”openInDlg”:true,”refreshAllOnCallback”:true,”viewItemLink”:true,”editItemLink”:false,”hideLabelInForm”:false,”label”:{},”moreItemsLabel”:{“default”:””},”noItemsLabel”:{“default”:”No current or past template requests found.”},”addNew”:false,”newItemInDlg”:false,”addNewLabel”:{“default”:””},”addNewIn”:{“disp”:false,”edit”:false,”view”:false},”addNewFolder”:false,”addNewFolderLabel”:{“default”:””},”addNewFolderIn”:{“disp”:false,”edit”:false},”addNewDocLabel”:{},”inUrl”:[],”folderMetadata”:[]}
      Field: vLookup

      query:
      <View Scope=’RecursiveAll’><Query><Where><And><Eq><FieldRef Name=’Hotkey’ /><Value Type=’Text’>CON CK COLLEGE</Value></Eq><Neq><FieldRef Name=’ID’ LookupId=’TRUE’ /><Value Type=’Lookup’>4</Value></Neq></And></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=4 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><And><Eq><FieldRef Name=’Hotkey’ /><Value Type=’Text’>CON CK COLLEGE</Value></Eq><Neq><FieldRef Name=’ID’ LookupId=’TRUE’ /><Value Type=’Lookup’>4</Value></Neq></And></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=4 – Number of items matching the query: 1
      undefined

      Update:
      Could the “spaces” in my List Name be causing this? I noticed in the ListView, it translates them to %20, but in DispForm it doesn’t.

    • #6659
      Rich Rockwell
      Participant

      I got some very different results, so I am posting mine below. There was a section in the debug output that listed all of the details for every field in the parent list and the child list, where they existed. I omitted those details and marked the section “*** This section was removed…”
      ———-

      vLookup DEBUG output:
      Waiting for sp.js to load and call spjs.vLookup.init…
      vLookup initiated.
      Found list view.
      Processing field “vLookup” in list “librarian%20sites”.
      <Where><Eq><FieldRef Name=’Title’ /><Value Type=’Text’>librarian%20sites:vLookup</Value></Eq></Where>
      Found 1 configuration for vLookup
      vLookup itemID=1 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>1</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=2 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>2</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=3 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>3</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=4 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>4</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=5 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>5</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=6 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>6</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=7 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>7</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=8 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>8</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=9 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>9</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=10 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>10</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=11 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>11</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=12 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>12</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=56 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>56</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=57 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>57</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=58 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>58</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=59 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>59</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=60 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>60</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=61 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>61</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=62 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>62</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=63 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>63</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=64 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>64</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=65 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>65</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=66 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>66</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=67 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>67</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=68 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>68</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=69 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>69</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=70 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>70</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=71 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>71</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=72 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>72</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=73 – Running query for field “vLookup” (this is async so the itemcount will be shown further down)
      <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Site’ LookupId=’TRUE’ /><Value Type=’Lookup’>73</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ Ascending=’false’ /></OrderBy></Query></View>
      vLookup itemID=1 – Number of items matching the query: 0
      vLookup itemID=3 – Number of items matching the query: 0
      vLookup itemID=4 – Number of items matching the query: 0
      vLookup itemID=2 – Number of items matching the query: 0
      vLookup initiated.
      Found list view.
      Processing field “vLookup” in list “librarian%20sites”.
      <Where><Eq><FieldRef Name=’Title’ /><Value Type=’Text’>librarian%20sites:vLookup</Value></Eq></Where>
      Found 1 configuration for vLookup
      vLookup itemID=6 – Number of items matching the query: 0
      vLookup itemID=7 – Number of items matching the query: 0
      vLookup itemID=8 – Number of items matching the query: 0
      vLookup itemID=9 – Number of items matching the query: 0
      vLookup itemID=10 – Number of items matching the query: 0
      vLookup itemID=11 – Number of items matching the query: 0
      vLookup itemID=5 – Number of items matching the query: 0
      vLookup itemID=56 – Number of items matching the query: 0
      vLookup itemID=57 – Number of items matching the query: 0
      vLookup itemID=58 – Number of items matching the query: 0
      vLookup itemID=12 – Number of items matching the query: 0
      vLookup itemID=60 – Number of items matching the query: 0
      vLookup itemID=61 – Number of items matching the query: 0
      vLookup itemID=62 – Number of items matching the query: 0
      vLookup itemID=63 – Number of items matching the query: 0
      vLookup itemID=64 – Number of items matching the query: 0
      vLookup itemID=65 – Number of items matching the query: 0
      vLookup itemID=66 – Number of items matching the query: 0
      vLookup itemID=67 – Number of items matching the query: 0
      vLookup itemID=68 – Number of items matching the query: 0
      vLookup itemID=69 – Number of items matching the query: 5
      vLookup itemID=70 – Number of items matching the query: 0
      vLookup itemID=71 – Number of items matching the query: 0
      vLookup itemID=72 – Number of items matching the query: 0
      vLookup itemID=73 – Number of items matching the query: 0
      vLookup itemID=59 – Number of items matching the query: 0

      • This reply was modified 4 years, 11 months ago by  Alexander Bautz. Reason: Removed some extra information that was not needed
    • #6668
      Alexander Bautz
      Keymaster

      Hi,
      It is the space in the list name that causes this problem. Can you verify that this patched version works: http://spjsfiles.com/SharePoint%20JavaScripts/vLookupForSharePoint/SP2010%20and%20SP2013/DEBUG/vLookup_frontend_BETA.js

      If it does, I’ll update the official release with the fix.

      Thank you all for the feedback,
      Alexander

    • #6671
      Rich Rockwell
      Participant

      Yes it works! Thanks

    • #6673
      Alexander Bautz
      Keymaster

      Thank you for the feedback – and for the “beer”. I’ll publish an “official” update later tonight.

      Best regards,
      Alexander

    • #6682
      Alexander Bautz
      Keymaster

      Hi,
      Finally published v2.003 of the frontend vLookup script. This fixes the bug with space in the list name (in the URL). You find the link to the updated file under “Download and install” here: https://spjsblog.com/vlookup-for-sharepoint/

      Alexander

    • #6688
      David S Kaimann
      Participant

      Alexander,

      Thanks so much for the fix! It’s helped tremendously. However, I think I found one more related issue. I have a subsite that has “spaces” in the title (changed to %20 in the URL: http://sharepoint.DOMAIN.net/sites/SITENAME/Issue%20and%20Process%20Escalation/) and on this site; only, none of my vLookups are working (in ListView nor DispForm). I’ve tried replacing the %20 in the List base URL and there’s no impact. Below is the information I get in Debug mode:
      vLookup DEBUG output:
      Waiting for sp.js to load and call spjs.vLookup.init…
      vLookup initiated.
      Did NOT find list view.
      Processing field “vLookup” in list “sites”.
      <Where><Eq><FieldRef Name=’Title’ /><Value Type=’Text’>sites:vLookup</Value></Eq></Where>
      Found 0 configuration for vLookup
      Processing field “vLookup0” in list “sites”.
      <Where><Eq><FieldRef Name=’Title’ /><Value Type=’Text’>sites:vLookup0</Value></Eq></Where>
      Found 0 configuration for vLookup0

    • #6702
      Alexander Bautz
      Keymaster

      Hi,
      Sorry for the late reply. Somehow the email regarding this post ended up in my spam folder. It seems I have a bug with the “list name detection” in the vLookup script as the proper CAML query parameter should be “Issue%20and%20Process%20Escalation:vLooup” and not “sites:vLookup”.

      I’ll look into it and post a fix.

      PS: When creating vLookup columns, you only have to prefix it with vLookup. Your field names can be like this:
      vLookup_issues
      vLookup_tasks
      and so on…

      Alexander

    • #6713
      Alexander Bautz
      Keymaster

      Hi David,
      I have tried to set up a site and list as you describe, but I cannot recreate the issue. Can you email me some screenshots of your setup so I can look into it?

      You find my email in the “About me” tab in the top of the page.

      Best regards,
      Alexander

Viewing 28 reply threads
  • You must be logged in to reply to this topic.