I am trying to use a secondary sharepoint list as another data source for one of my charts and used (this post on the documentation site.
However I have a slightly different scenario than described in the post.
Namely my oData query does not work of the ID field but rather uses another shared field based on SAP groups. The reason for this is that one list contains more entries than the other so the ID's wouldn't be identical.
However the query doesn't seem to work as the custom html I wrote for the boxes doesn't get populated an none of onBoxRendered events trigger. There seems to be an error with how i set it up because all other custom render events i made also stop functioning when trying to implement this.
Appreciate any help and constructive feedback!
Thank you
Hi @Nick_B
I believe your code is almost there!
Here's the problem: in the OData filter query the string values should be put inside the quotation marks. So, this line:
Thanks a lot for helping with my second question today
Sadly this time your suggestion does not seem to be solving my issue. I tried your fix with the added ' but when trying to show the information in my box using
Also just a thing to confirmed in the first part of my oData query (the part containing eq) this references my second list, while the itemData['info'] refers to the column in my current list, correct?
Maybe you could let the admins know that there's an error in their documentation article as well? It's a bit confusing for newbies like myself when RTFM doesn't work.
Thanks again for being so kind to help me twice today!
This is the additional list, I added some additional info for some of the Job titles in the main list. The internal column name here is the same ("JobTitle"), but it may not be.
Here pochContext.listData.Description token takes data from the "Description" column in the additional list.
Here's the result:
I believe that you might want to debug a bit. I would suggest o start with the following:
Make sure you use the correct names for the itemData object and the correct column name for the additional list. This should be the internal column name! You can copy it from the URL of the Column settings: