On Wed, Jun 18, 2008 at 11:46 AM, Ed Leafe <[EMAIL PROTECTED]> wrote: > On Jun 18, 2008, at 1:32 PM, Nate Lowrie wrote: > >> I need to be able to search by this metadata for a part that matches >> values in 1 or more of these fields (i.e. a resistor with a 0603 >> package and a resistance of 330 ohms). Yet, the only way I could >> think of doing it is searching the metadata table separately for each >> field value and then seeing which partIDs are on both lists. Anyone >> got a better way? > > > SELECT Part.ID, Part.SKU > FROM Part > WHERE Part.ID IN > (SELECT ID from MetaData > WHERE ParameterName = "Package" > AND ParameterValue = "0603" > ) > AND Part.ID IN > (SELECT ID from MetaData > WHERE ParameterName = "Resistance" > AND ParameterValue = 330 > ) > > Don't know if that helps, but that should give you a start.
It does give me a start. It looks like I should be able to put this into a BizObj where clause pretty easily. Thanks Ed. Nate L. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
