compare xml files

You can make the job a little easier by using API_GenResultsTable&jsa=1 to return arrays instead of XML. The compare the two responses using Underscore's difference() method like this:

var url1 = "https://login.quickbase.com/db/6ewwzuuj?act=API_GenResultsTable&qid=6&clist=3&jsa=1"; var url2 = "https://login.quickbase.com/db/6ewwzuuj?act=API_GenResultsTable&qid=7&clist=3&jsa=1";  $.getScript(url1)   .then(function() {     var data1 = qdb_data;      $.getScript(url2)       .then(function() {         var data2 = qdb_data;         console.table(_.difference(data1, data2));       });    });

This example can be executed from the console of the Formula Functions Reference table and returns the rids of those records in the first query but not the second:

Formula Functions Reference Home
https://login.quickbase.com/db/6ewwzuuj?a=td

You can further modify the reporting logic to identify those specific records with specific combinations of [PatiendId], field values that you are interested in seeing in the report.

See also Underscore's union() and intersection() methods.