dingjing

(function(){
  var msgdiv = document.querySelector('table.message table div');
  msgdiv.parentNode.removeChild(msgdiv);
  var body = document.querySelector('body');
  body.removeChild(document.querySelector('div.bodycontainer'));
  body.appendChild(msgdiv);
})();

dingjing

SELECT 
  s1.StartTime,
  MIN(t1.EndTime) AS EndTime
FROM Event_Demo s1 
INNER JOIN Event_Demo t1 ON s1.StartTime <= t1.EndTime
  AND NOT EXISTS(SELECT * FROM Event_Demo t2 
                 WHERE t1.EndTime >= t2.StartTime AND t1.EndTime < t2.EndTime) 
WHERE NOT EXISTS(SELECT * FROM Event_Demo s2 
                 WHERE s1.StartTime > s2.StartTime AND s1.StartTime <= s2.EndTime) 
GROUP BY s1.StartTime 

dingjing

with detect_group_boundary as (
select
  EventID,
  StartTime,
  EndTime,
  max(EndTime) over (order by StartTime, EndTime rows between unbounded preceding and 1 preceding) as prev_max_end,
  case when StartTime > isnull(max(EndTime) over (order by StartTime, EndTime rows between unbounded preceding and 1 preceding), StartTime - 1) then 'Y' end as new_group
from Event_Demo
), count_running_group_boundary as (
select

dingjing

with course_bitmap as (
select
  Course_ID,
  power(2, row_number() over (order by course_id) - 1) as course_bit
from Course
)
select
  sum(cb.course_bit) over (partition by sc.Student_id) as Group_id,
  sc.Student_id,
  sc.Course_id

dingjing

#Requires -Version 5.0
using namespace Neo4j.Driver.V1

Import-Module "$PSScriptRoot\Neo4j.Driver.1.4.0\lib\net46\Neo4j.Driver.dll"
Import-Module "$PSScriptRoot\System.Net.Sockets.4.1.0\lib\net46\System.Net.Sockets.dll"
Import-Module "$PSScriptRoot\System.Net.Security.4.0.0\lib\net46\System.Net.Security.dll"
Import-Module "$PSScriptRoot\System.Security.Cryptography.X509Certificates.4.1.0\lib\net46\System.Security.Cryptography.X509Certificates.dll"
Import-Module "$PSScriptRoot\System.Net.NameResolution.4.0.0\lib\net46\System.Net.NameResolution.dll"

$authToken = [AuthTokens]::Basic('neo4j', 'password')

dingjing

javascript:(function(){
  window.showObieeMsg = window.showObieeMsg || function(msg){
    var msgDiv = document.querySelector('td#idStatusIndicator div');
    if(!msgDiv){
      msgDiv = document.querySelector('td#idStatusIndicator');
      msgDiv.innerHTML = '<div class=\'StatusIndicatorDiv\'></div>';
      msgDiv = document.querySelector('td#idStatusIndicator div');
    }
    msgDiv.innerHTML = msg;
    setTimeout(function(){msgDiv.innerHTML=''}, 5000);

dingjing

javascript:(function(){
  window.showObieeMsg = window.showObieeMsg || function(msg){
    var msgDiv = document.querySelector('td#idStatusIndicator div');
    if(!msgDiv){
      msgDiv = document.querySelector('td#idStatusIndicator');
      msgDiv.innerHTML = '<div class=\'StatusIndicatorDiv\'></div>';
      msgDiv = document.querySelector('td#idStatusIndicator div');
    }
    msgDiv.innerHTML = msg;
    setTimeout(function(){msgDiv.innerHTML=''}, 5000);

dingjing

javascript:(function(){
  window.showObieeMsg = window.showObieeMsg || function(msg){
    var msgDiv = document.querySelector('td#idStatusIndicator div');
    if(!msgDiv){
      msgDiv = document.querySelector('td#idStatusIndicator');
      msgDiv.innerHTML = '<div class="StatusIndicatorDiv"></div>';
      msgDiv = document.querySelector('td#idStatusIndicator div');
    }
    msgDiv.innerHTML = msg;
    setTimeout(function(){msgDiv.innerHTML=''}, 5000);

dingjing

javascript:(function(){
  var host = window.location.host;
  var path = (new URLSearchParams(window.location.search.toUpperCase())).get('PATH');
  if(!path){
    alert('Cannot read report path from URL. Please open the report directly in Edit mode.');
    return false;
  };
  var rpt = XUIPanel.getEditor('idReport').report.outerHTML;
  var data = JSON.stringify({'host':host,'path':path,'rpt':rpt});
  var xhr = new XMLHttpRequest();

dingjing

$myArray = $null

# No loop
ForEach($i in $myArray){
  'In ForEach'
  $i
}

# Loop once with $null value
$myArray |  ForEach-Object {