If I summarize your requirement, Then It is

1. Get Items from a list using JavaScript
2. Redirect to some URL

Get Items Using JSOM

You can use CAML query for this as you need to filter Status=no. So the query should look like

<View>
   <Query>
      <Where>
        <Eq><FieldRef Name=\"Status\" />
           <Value Type=\"Text\">no</Value>
        </Eq>
      </Where>
    </Query>
</View>

Sample code

function retrieveListItems() {

    var clientContext = new SP.ClientContext('Site Url');
    var oList = clientContext.get_web().get_lists().getByTitle('List Name');

    var camlQuery = new SP.CamlQuery();
    camlQuery.set_viewXml('<View><Query><Where><Eq><FieldRef Name=\"Status\" /><Value Type=\"Text\">no</Value></Eq></Where></Query></View>');
    this.collListItem = oList.getItems(camlQuery);

    clientContext.load(collListItem);

    clientContext.executeQueryAsync(Function.createDelegate(this, this.onQuerySucceeded), Function.createDelegate(this, this.onQueryFailed));

}

function onQuerySucceeded(sender, args) {

    var listItemInfo = '';

    var listItemEnumerator = collListItem.getEnumerator();

    while (listItemEnumerator.moveNext()) {
        var oListItem = listItemEnumerator.get_current();
        listItemInfo += '\nID: ' + oListItem.get_id() +
            '\nTitle: ' + oListItem.get_item('Title') +
            '\nStatus: ' + oListItem.get_item('Status');
    }

    alert(listItemInfo.toString());
}

function onQueryFailed(sender, args) {

    alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());
}

For more explanation How to: Retrieve List Items Using JavaScript

Redirect to some URL

window.location.href = 'http://example.com/';