Expanding an Object before Exporting it
Forums
Hi Avi,
Hi Avi,
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.
Brian
I uploaded the JPEG
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.