Need to grab address column and pass it to an array

Question

My script uses an array like this:

var locations = [
    ['Location 1 Name', 'New York, NY', 'Location 1 URL'],
    ['Location 2 Name', 'Newark, NJ', 'Location 2 URL'],
    ['Location 3 Name', 'Philadelphia, PA', 'Location 3 URL'],
];

I have a page with two list webparts (A and B). webpart A/List A has two columns

Title and Address

Using javascript, i need to be able to grab the data from Address column and pass that to my array.

I've tried ANYTHING javscript related for sharepoint, but nothing seems to run.

i have script.js in my SiteAssets folder and in a CONTENT EDITOR webpart i added the call for the script <script src=pathToMyScript> </script>

I tried running a alert("hello"); to confirm that its working and the alert works fine, but as soon as i add javascript that i've seen anywhere in this page or other pages, nothing seems to be working as nothing shows or loads.

Things to note: Treat me as if i knew nothing about javascript and sharepoint. However, i do know how to program in javascript. I never used sp.js libraries.

Answer 1

Answering to question at below link, putting answer here as below is marked as duplicate. Passing List Items to Array

If I understood correctly, you need 2D javascript array...I have not tested below but to give you idea, it should work.

function onQuerySucceeded(sender, args) {
    var locations = new Array(collListItem.get_count());
    var listItemInfo = '';

    var listItemEnumerator = collListItem.getEnumerator();

    while (listItemEnumerator.moveNext()) {
        var oListItem = listItemEnumerator.get_current();

        eventName = oListItem.get_item('Title');
        eventAddress = oListItem.get_item('WorkAddress');
        eventURL = website.get_url() + '/' + 'Lists/North East Reports/DispForm.aspx?ID=' + oListItem.get_id();
        var newLocation = [eventName, eventAddress, eventURL];
        locations.push(newLocation);

         listItemInfo += 
               //'\nID: ' + oListItem.get_id() +
               '\nEvent Name: ' +  eventName +//oListItem.get_item('Title') + 
            '\nAddress: ' + eventAddress +//oListItem.get_item('WorkAddress') +
            '\nURL: ' + eventURL;//website.get_url() + '/' + 'Lists/North East Reports/DispForm.aspx?ID=' + oListItem.get_id(); 
    }

    //alert(listItemInfo.toString());
}

Answer 2

You need to create locations array and then push location with properties. like this.

// Create Array 
var locations = [];
// Push items into array
locations.push(eventName, eventAddress, eventURL);

Here is complete code.

function onQuerySucceeded(sender, args) {

var listItemInfo = '';
var listItemEnumerator = collListItem.getEnumerator();
var locations = [];
while (listItemEnumerator.moveNext()) {

        var oListItem = listItemEnumerator.get_current();
        eventName = oListItem.get_item('Title');
        eventAddress = oListItem.get_item('WorkAddress');
        eventURL = website.get_url() + '/' + 'Lists/North East Reports/DispForm.aspx?ID=' + oListItem.get_id();

        locations.push(eventName, eventAddress, eventURL);
        listItemInfo += 
               //'\nID: ' + oListItem.get_id() +
               '\nEvent Name: ' +  eventName +//oListItem.get_item('Title') + 
            '\nAddress: ' + eventAddress +//oListItem.get_item('WorkAddress') +
            '\nURL: ' + eventURL;//website.get_url() + '/' + 'Lists/North East Reports/DispForm.aspx?ID=' + oListItem.get_id(); 
    }
//alert(listItemInfo.toString());
}