Repository for the PnP JavaScript Core component development together with community members
setItemMetaDataMultiField but I can't find it in 2.x
This is a question I asked on Github, https://github.com/pnp/pnpjs/issues/1078#issuecomment-591804936, but I am still unable to resolve it.
Below is the complete js code. I am getting "undefined" while trying to display the Email portion of a People or Group field called
"ServiceContact" that I created on a custom list called Services. FYI, I am implementing this on a SharePoint 2016 web page. Please help?
<script type="text/javascript" src="/scripts/js/es6-promise.auto.min.js"></script>
<script type="text/javascript" src="/scripts/js/fetch.js"></script>
<script type="text/javascript" src="/scripts/js/pnp.min.js"></script>
<div>
<div>
<p id="countid">No Information Management services found.</p>
<table width="100%" cellpadding="5" cellspacing="2" class="main-table" id="Main">
</table>
</div>
</div>
<script type="text/javascript">
var filterValue = "Expire eq 'No'&ServiceOwner eq 'Information Management'&$orderby=Title asc";
$pnp.sp.web.lists.getByTitle('Services')
.items
.select('Title,ServiceDescription,ServiceDeliveryDetails,ServiceDuration,ServiceContact/EMail')
.expand('ServiceContact')
.filter(filterValue)
.get()
.then(function(result) {
if(result.length > 0)
$('#countid').html("<b>Number of IM Services found:</b> "+ result.length);
for(var i=0; i< result.length; i++){
$("#Main").append(
"<tr><td><h2>" + result[i].Title + '</h2></td></tr>'+
"<tr><td><b>Service Description</b>" + result[i].ServiceDescription + '</td></tr>'+
"<tr><td><b>Delivery Details</b>" + result[i].ServiceDeliveryDetails + '</td></tr>'+
"<tr><td><b>Contact</b>" + result[i].ServiceContact.Email + '</td></tr>'+
"<tr><td><b>Duration</b>" + result[i].ServiceDuration + '</td></tr>'+
"<tr><td><hr></td></tr>");
}
}).catch(function(err){ alert(err);});
</script>
result[i].ServiceContact.Email should be result[i].ServiceContact.EMail"Expire eq 'No'&ServiceOwner eq 'Information Management'&$orderby=Title asc" <- this, is btw incorrect too. Condotions should be joined with and or or, but not the &. ServiceOwner eq 'Information Management' is just ends up ignored.$orderby should not be placed to filter, but .orderBy('Title', true).I'd recommend using debugger and console to understand why something in JS says it's undefined. This has no connection to the library. If on the learning curve you're not ready for debugger, etc. a trick is to use just console.log() for an object you're not sure about, or printing it in <pre> tag using JSON.stringify(yourObject, null, 2) to see what's in response, etc. Cheers!
sp recursively? I've tried with sinon, but I'm only able to stub the first part, then I must mock the rest.Something like this would be awesome (fictional):
when(sp.web.getList('web/Lists/A').items.filter(`Title eq 'yes'`).get).thenReturn([{ Id: 1 }]);
when(sp.web.getList('web/Lists/A').items.filter(`Title eq 'no'`).get).thenReturn([{ Id: 2 }]);
when(sp.web.getList('web/Lists/B').items.filter(`Title eq 'yes'`).get).thenReturn([{ Id: 3 }]);I made my own, does t his look good?
const mySp = when(sp);
mySp.web.getList('web/Lists/A').items.filter(`Title eq 'yes'`).get.thenReturn([{ Id: 1 }]);
mySp.web.getList('web/Lists/A').items.filter(`Title eq 'no'`).get.thenReturn([{ Id: 2 }]);
mySp.web.getList('web/Lists/B').items.filter(`Title eq 'yes'`).get.thenReturn([{ Id: 3 }]);
console.log(1, mySp.web.getList('web/Lists/A').items.filter(`Title eq 'yes'`).get());
console.log(2, mySp.web.getList('web/Lists/A').items.filter(`Title eq 'no'`).get());
console.log(3, mySp.web.getList('web/Lists/B').items.filter(`Title eq 'yes'`).get());
// Prints:
// 1 [ { Id: 1 } ]
// 2 [ { Id: 2 } ]
// 3 [ { Id: 3 } ]Then I use rewiremock to replace sp with mySp. I could also just replace it with require('@pnp/sp-commonjs').sp = mySp before require my code.
The stubbing hack I made will work in browser and node
Here is an example:
const test = require('ava');
// Here be magic
require('./bootstrap-test-blackbox');
const { sp } = require('@pnp/sp-commonjs');
async function someExternalModule() {
const spItem = sp.web.getList('web/Lists/A').items.getById(137);
const item = await spItem.get();
await spItem.update({
Sum: item.Sum + 100
});
}
test('Summing!', async t => {
t.plan(1);
const spItem = sp.web.getList('web/Lists/A').items.getById(137);
spItem.get.thenReturn({ Sum: 600 });
spItem.update.thenCall(item => {
t.deepEqual({ Sum: 700 }, item);
});
// This part will be in another file, e.g., index.js in Azure Functions function
await someExternalModule();
});sinon already can do, except I don't know how
trying to install @pnp/sp through npm on a fresh directory. Keeps returning with file not found. @pnp/sp -> @pnp/.sp.DELETE
Full error:
npm ERR! code ENOENT
npm ERR! syscall rename
npm ERR! path /mnt/c/Users/michael.melton/Documents/_DevWork/DeployTool/node_modules/@pnp/sp
npm ERR! dest /mnt/c/Users/michael.melton/Documents/_DevWork/DeployTool/node_modules/@pnp/.sp.DELETE
npm ERR! errno -2
npm ERR! enoent ENOENT: no such file or directory, rename '/mnt/c/Users/michael.melton/Documents/_DevWork/DeployTool/node_modules/@pnp/sp' -> '/mnt/c/Users/michael.melton/Documents/_DevWork/DeployTool/node_modules/@pnp/.sp.DELETE'
npm ERR! enoent This is related to npm not being able to find a file.Windows 10 Linux Subsystem OS
ok I seem to be having some issue trying to make a batch request to multiple list. Below is my code and the error that i'm getting. All the list are within the same site collection so I'm not sure what I have done wrong. it seems to work fine if you change the request to add an item but not a get
import { sp } from "@pnp/sp";
import "@pnp/sp/webs";
import "@pnp/sp/lists";
import "@pnp/sp/items";
export const fetchInitialData = (): any => {
return async dispatch => {
try {
let batch = sp.createBatch();
sp.web.lists
.getByTitle("BusinessUnits")
.items.inBatch(batch)
.orderBy("Title")
.get().then(r => console.log(r))
await batch.execute();
}
catch(error) { console.log(error)}
Error: Error making HttpClient request in queryable [400] Bad Request ::> {"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"Invalid request."}}}
at new HttpRequestError (parsers.js:130)
at Function.<anonymous> (parsers.js:145)
at step (tslib.es6.js:99)
at Object.next (tslib.es6.js:80)
at fulfilled (tslib.es6.js:70)
// CTRL/CMD + D to execute the code
import { sp } from "@pnp/sp";
import "@pnp/sp/webs";
import "@pnp/sp/lists";
import "@pnp/sp/items";
(async () => {
let batch = sp.web.createBatch();
let list = sp.web.lists.getByTitle("Documents").items.inBatch(batch)();
let list2 = sp.web.lists.getByTitle("Images").items.inBatch(batch)()
await batch.execute();
const l = await list;
console.log(l)
const l2 = await list2;
console.log(l2)
})().catch(console.log)
So if you know how it's done in the REST you can easily apply the same to PnPjs's helper.
With empty values and filter:
FieldName eq null would work. But some nuances might emerge, none related to the library but SharePoint version (e.g. in old SP versions null comparing didn't work for example, or it could work but with not any field data type).
