I have a web part page displaying four “provider” web parts, each containing the Title column from one of four lists: Efforts, Phases, CapturePoints, Functions.
These lists are lookup sources for lookup columns (Effort, Phase, CapturePoint, Function) in my consumer list.
Now, though, I have a further requirement: In the provider web parts, display the number of items in the consumer list that contain the filter values in each of the provider web parts, next to the provider list view value.
So, it would look like this:
Efforts web part:
Accordingly, the consumer list would display 4 items with Effort values of ‘AAA’, and so on.
After a lot of googling, I was able to come up with this list service call that tells me how many items have a given ‘Effort’ value:
[URL]/_vti_bin/listdata.svc/[consumer list]/$count?&$filter=Effort/Title eq ‘AAA’
Finally, the purpose of this question…
I’m struggling with figuring out how to string this all together in my script:
- Iterate through all of the Title values
- query the consumer list for the number of items with that value as the relevant lookup column
- append that number to the value in the provider web part.
I just realized that I’ll have to modify my (working) script to make it ignore the string appended to the original value. Ugh!
I will be eternally grateful for any assistance.