An Oracle White Paper

April 2012

Introduced in Release 6.0

E29310-01

Custom Data Searching Within a Row

# Overview

You now have the ability to search within a row when searching for custom data. For example, you can now find all ingredient specifications that contain the extended attribute “Flavor = Grape” and extended attribute “Flavor Value > 15g” in the same custom section row.

# The Basics

A new icon has been added to the Custom Sections Quick and Advanced search tools.

Figure 1. Custom Sections search

In Figure 1, this search will find all specifications that contain over 12 grams of Cherry and 2 grams of Fiber.

The first two rows of the table represent a within same row search. These rows will find all specifications that have the EA named “Flavor” that contain the value “Cherry” and the EA named “Flavor Value” that contains any value greater than 12g in one row of any custom section. The last row adds the search for EA Fiber in any section greater than 2g

Custom Data Search Within A Row 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