[David S Kaimann]

Alexander,

Great work! I appreciate all of the help! I attached a Word Document showing some of my testing results. I tried to test all of the items, but wasn’t able to get to them all.

THANKS for all your hard work!

Attachments:

1. DFFS-Beta-Testing.docx

[David S Kaimann]

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

• This reply was modified 10 years ago by David S Kaimann.
• This reply was modified 10 years ago by David S Kaimann.

[David S Kaimann]

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.

• This reply was modified 10 years, 1 month ago by David S Kaimann.

[David S Kaimann]

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>

[David S Kaimann]

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.

[Author]

Posts