Skip to main content

Expanding an Object before Exporting it

avikerem Sun, 03/28/2021 - 03:44

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.

Brian Element Sun, 03/28/2021 - 11:05

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