Topic
  • 1 reply
  • Latest Post - ‏2013-11-29T12:54:01Z by AndrewatFindel
AndrewatFindel
AndrewatFindel
43 Posts

Pinned topic WQL and lookup keys

‏2013-11-29T12:09:56Z |

I have a lookup table with an Integer for a key.

if i use SELECT item FROM collaboration_area('Product Web Enrichment Collaboration Area') WHERE item['Product Spec/Catalogue Details/Catalogue Number'] = '1' the query runs but does not return values.

if i use SELECT item FROM collaboration_area('Product Web Enrichment Collaboration Area') WHERE item['Product Spec/Catalogue Details/Catalogue Number'] = 1 the query fails with:

Caused by: CWPSE0023E:Incompatible types for predicate '{Product Spec/Catalogue Details/Catalogue Number} = ConstAttribute{1.0, m_type=Number, m_obj=1, m_isList=false, m_processingObject=1}', iExprType = 46, iAttrType = 46
 at com.ibm.ccd.search.javaquery.PosPathBinOpPredicate.<init>(Unknown Source)

On the Product Spec the attribute Catalogue Number is type LOOKUP.

Are there restrictions on using the query language on lookup attributes? 


 


 

 

  • AndrewatFindel
    AndrewatFindel
    43 Posts

    Re: WQL and lookup keys

    ‏2013-11-29T12:54:01Z  

    No worries, forget that, it is working now.