AnsweredAssumed Answered

How does one specify a string value in a SQL query for SWE? My query works in server management studio using ' to specify a string but it will not take in SWE

Question asked by Justin Lanfell on Oct 26, 2018
Latest reply on Oct 30, 2018 by Justin Lanfell

How does one specify a string value in a SQL query for SWE? My query works in server management studio using ' to specify a string but it will not take in SWE. See my query below

 

SELECT DISTINCT

    tew_component.com_id AS id

    ,  tew_component.com_type  AS type

    ,  tew_component.com_tagmanual  AS tagtype

    ,  tew_component_parent.com_tag AS TagParent

    ,  tew_component.com_tag AS TagText

    ,  tew_component.com_tagroot AS TagRoot

    ,  tew_component.com_tagorderno AS TagOrderNo

    ,  tew_componentelement.cel_group AS Deck

       ,  tew_componentelement.cel_orderno AS CelOrderNo

    , 1 AS  %ELEMENT_COUNT%

    , tew_component.com_tagpath AS com_fulltagpath

    , tew_component.com_parenttagpath AS com_tagpath

    , tew_compbom.bom_articlename AS JDE_part

FROM ((tew_component LEFT JOIN tew_component AS tew_component_parent ON tew_component.com_com_id=tew_component_parent.com_id)

LEFT JOIN tew_componentelement ON tew_component.com_id=tew_componentelement.cel_com_id)

LEFT JOIN tew_location AS tew_comploc ON tew_component.com_loc_id = tew_comploc.loc_id

LEFT JOIN tew_buildofmaterial AS tew_compbom on tew_component.com_id = tew_compbom.bom_objectid

WHERE (tew_component.com_type = 3 OR  tew_component.com_type = 4) AND (tew_comploc.loc_bun_id = %CUR_BUNDLE_ID%) AND (tew_component_parent.com_tag IS NOT NULL) AND (tew_compbom.bom_articlename IS NOT NULL AND tew_compbom.bom_articlename = 'PNNTT' OR tew_compbom.bom_articlename = '31991' OR tew_compbom.bom_articlename = 'PNDPT')

     ORDER BY type,TagParent, TagOrderNo

Outcomes