I am trying to create multiple custom HTML widget in my Dashboard. Each of these widget will show the number of nodes that are up/down by region. The first widget I create shows the information correctly. as shown below.
<!DOCTYPE html>
function getEUValues() {
var swqlEU = "Select Count(n.status) AS Cnt,s.StatusName FROM Orion.Nodes n RIGHT Join Orion.StatusInfo s ON n.Status = s.StatusID WHERE n.NodeID IN (SELECT N.NodeID FROM Orion.Nodes AS N LEFT JOIN Orion.ContainerMemberSnapshots AS CMS ON N.NodeID=CMS.EntityID and CMS.EntityType='Orion.Nodes' LEFT JOIN Orion.Container AS C ON C.ContainerID=CMS.ContainerID Where C.Name LIKE 'Site EU%') AND s.StatusID IN (1,2,3,9) GROUP By n.Status,s.StatusName,s.StatusId ORDER By s.statusID ASC "
var params = JSON.stringify({
query: swqlEU,
parameters: {
}
});
$.ajax({
type: 'POST',
url: '/Orion/Services/Information.asmx/QueryWithParameters',
data: params,
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
document.getElementById("e").innerHTML = response.d.Rows[0][0];
document.getElementById("f").innerHTML = response.d.Rows[1][0];
document.getElementById("g").innerHTML = response.d.Rows[2][0];
document.getElementById("h").innerHTML = response.d.Rows[3][0];
}
});
}
#myHeader {
background-color: lightblue;
color: black;
padding: 40px;
text-align: center;
}
up
down
Once i create another custom html with different swql and changed javascript functions it doesn't show up until i delete the first widget. I have tried with different html and JavaScript, when i put more then 1 Custum HTM it fails to show.
<!DOCTYPE html>
function getAMValues() {
var swqlAM = "Select Count(n.status) AS Cnt,s.StatusName FROM Orion.Nodes n RIGHT Join Orion.StatusInfo s ON n.Status = s.StatusID WHERE n.NodeID IN (SELECT N.NodeID FROM Orion.Nodes AS N LEFT JOIN Orion.ContainerMemberSnapshots AS CMS ON N.NodeID=CMS.EntityID and CMS.EntityType='Orion.Nodes' LEFT JOIN Orion.Container AS C ON C.ContainerID=CMS.ContainerID Where C.Name LIKE 'Site AM%') AND s.StatusID IN (1,2,3,9) GROUP By n.Status,s.StatusName,s.StatusId ORDER By s.statusID ASC "
var params = JSON.stringify({
query: swqlAM,
parameters: {
}
});
$.ajax({
type: 'POST',
url: '/Orion/Services/Information.asmx/QueryWithParameters',
data: params,
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
document.getElementById("a").innerHTML = response.d.Rows[0][0];
document.getElementById("bt").innerHTML = response.d.Rows[1][0];
document.getElementById("c").innerHTML = response.d.Rows[2][0];
document.getElementById("d").innerHTML = response.d.Rows[3][0];
}
});
}
#myHeader {
background-color: lightblue;
color: black;
padding: 40px;
text-align: center;
}
up
Down
is there something that I'm missing? or is it not possible to Creating multiple Custom HTML widget in a Dashboard? i have shared both html, any help is appreciated. Thank you.
