The + buttons can be used to expand a Gap Detection object before exporting the detailed object to Excel.
working in a Script mode The summarized object can be exported from within a script (by creating a GapDetection database first ), but I could not find a way to expand a Gap Detection object from within a script before exporting it.
This is a bit of a problem and unfortunately IDEA and IDEAScript doesn't really have a good solution for this. In the past I have used two options, one is you create a new file in IDEAScript that lists all the JE Number entries, you summarize the file you are looking for gaps the gaps and then do a join with the summary file as primary, the new file as secondary and then extract all non-secondary matches to have your missing items file.
The other way is you will also have to create a new file but you can loop through all the JE NO looking for missing items and create the file directly that way.
Unfortunately I haven't figure out an easy way to get around this.
IDEA is a trademark of CaseWare International Inc., used by permission.
All material provided on the IDEAScripting website is presented as is without any warranty or guarantee. Anybody using any solution provided on this pages is encouraged to validate the effectiveness and reliability on their own.
IDEA Help Videos
IDEA Related Videos
IDEA Success Stories