An Oracle White Paper

April 2012

Introduced in Release 6.0

E29312-01

Custom Section Quick Search

# Overview

Custom Section Quick search has been added. This allows users to search for custom sections based on the extended attribute name and value.

# The Problem

The user who was searching for custom data had to always specify the custom section/row/column pairing to find a particular custom data value, even if that attribute was distinct. This was time consuming and difficult for the user to understand.

This technique also did not allow the user to search across custom sections, some use cases call for a different custom section to be created for specifications in different categories or regions. For example, when using custom sections to display and calculate regional fact panels, if you wanted to find all Nutrient Profiles that contain the attribute Fiber greater than 5g, you would have to perform a separate search for each possible section the attribute could be in. This could be extremely time-consuming depending on how many regions you support.

While the extended attribute search was available, this control performed a search across the simple extended attributes grid and all custom section attributes. The extended attributes also had to be classed as simple, allowing users to potentially add attributes to the simple grid on specifications.

# The Solution

Create a tool that searches extended attributes existing only in custom sections; across all custom sections

# The Basics

A new section has been added to the additional attributes search popup, Custom Sections (Quick).

#

Figure 1. Custom Sections search

This search will find all specifications that contain the “Adhesives” attribute = “Glue” within any custom section.

New search criteria is added using the standard Add New button, but instead of having to give the section/row/column name, the user only needs to select the Extended Attribute they wish to search for. This new search ability places even more importance on the name chosen for the extended attribute. All extended attributes should be named with a descriptive name users will recognize or understand.

Custom Section Quick Search April 2012 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. Worldwide Inquiries: Phone: +1.650.506.7000 Fax: +1.650.506.7200 oracle.com | Copyright © 2012, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. UNIX is a registered trademark licensed through X/Open Company, Ltd. 1010