Chartjs-How to detect the insertion of a new data?

0👍

Assuming that the source database table contains an ID column that is incremented by a SEQUENCE, you can repeatedly select new data as follows:

SELECT * from <table name> where ID > :lastSelectedID
ORDER BY ID ASC;

In case the source table contains a column that holds the insertion date/time (i.e. CREATED), the same could look as follows:

SELECT * from <table name> where CREATED > :lastSelectedCreated
ORDER BY CREATED ASC;;

Leave a comment