30.8. Reports with additional filters Variables search | Topology search | Preferred rows

In Duplicates Report, Make or Buy report, Cost mockup report and Supplier search, as of PARTsolutions version 9.08 there is an additional section Filter for results where you can restrict the results:[163]

  • Variables search

  • Topology search

  • Filter (Show only preferred rows)

[Note]Note

The filter concerns result parts not search parts.

The functionality is according to the standard search functions:

  • Variables search: You can filter for a certain ERP number group or a certain material for example. In the dialog box all ERP variables visible in the table are displayed.

    Example Variables search: The ERP number has to begin with "DEM1".

    Example Variables search: The ERP number has to begin with "DEM1".

    Result:

    All result parts (right side) begin with the ERP number "DEM1".

    All result parts (right side) begin with the ERP number "DEM1".

    Details on this are found under Section 3.1.6.4.5, “ Variables search ” in PARTsolutions - User manual.

  • Topology search: You can filter for the longest extension for example.

    Topology search

    Topology search

    Details on this are found under Section 3.1.6.4.12, “ Topology search ” in PARTsolutions - User manual.

  • Filter:

    • Show only preferred rows activated:

      Characteristics, which do not match the preferred rows condition are not displayed.

    Details on this are found under Section 3.1.11.2.2, “ Use preferred rows filter ” in PARTsolutions - User manual.

The filter can also be realized via scripting:

dim manager
set manager = CreateObject("analysis.reportmanager")
dim generator
set generator = manager.CreateReportGenerator("Duplicates")

generator.Options.IndexPath = "cat/norm/din/schrauben"
generator.Options.SearchTemplate = "SystemTemplate11"
generator.Options.ReportName = "Dublettenreport mit Filter"
generator.Options.Threshold = 90
generator.Options.MaxResults = 10

dim indexSearch
set indexSearch = application.ViewIndexTree.CreateObject("IndexSearch")
dim filter
set filter = indexSearch.AddSearchObject("filter")
filter.filterLines = true
set generator.Options.SearchFilter = indexSearch

dim report
set report = generator.GenerateReport()




[163] #36853