Using the flex query view

Use the flex query view tool to create queries on style data. You can build queries using available fields on each tab of the Style and Material modules, then show the results in a single view that you also define.

You can use the Style Overview and Material Overview extended fields in the column chooser, query grid view, advanced filters, report XML, generate reports, and export to Excel. Additionally, all five extended field types are also supported: text, generic lookup, number, date, and checkbox.

The flex query view shows the label of the extended field and not its name.

A validation is in place in case an extended field is already part of a flex query view and you updated its label from the Extended Field library. This validation is triggered when you open or refresh the flex query view record. You must remove the old extended field from the grid and in the advanced filters and add them again using the updated extended field label. Ensure that the step is completed to prevent the query from not returning.

The styles and materials that are included in the result set depend on the data hierarchy. You can only view items that you have access to.

See Hierarchy.

You can also generate an XML file based on your query view, then use the XML file as content source input when creating a report layout using a Word document with Infor Document Management extension. You can create a report template and import this Word document and the XML file. Using the template, you can generate a report in flex query view, style, or material list.

Based on the result set, you can generate reports and export to Excel.