...
The SQL query used is stored in metabase (In our anayltics as “peninsular trainee details pilot”) and has two restrictions which should be modified if it is rerun. These are the date, which determines which placements are selected and the trusts which are applicable. This query was run and saved as a csv file before and after the file was loaded. With the before files saved a preload.csv and the after file being saved as postload.csv. The audit system was then accessed through the page (insert link here10.160.0.137/esraudit/search [This needs an SSH connection if outside of the office currently]) . We searched for the RMF file name and the outputted csv was saved as combinedAuditMessage.csv. these files were then put in the the import folder in neo4j and the following scripts were run in neo4j’s ui:
...
| View file | ||
|---|---|---|
|
Data Query and pattern matching
...