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 module, then display the results in a single view that you also define.

You can use Style Overview extended fields in the column chooser, advanced filters, and report XML. All five extended field types are supported: text, generic lookup, number, date, and checkbox.

The flex query view displays 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/or in advanced filters and add them again using the updated extended field label. The query will not return data if you fail to do this.

The styles 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 or style list.

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