IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

"or" condition is not working in this Sql query while using string split

  • 1.  "or" condition is not working in this Sql query while using string split

    Posted Tue November 29, 2022 06:42 AM

    Actually i want to take any one condition in this while passing serviceID in SP. but this query giving me combining of this 2 stringSplit conditions
    select * from end_points where service_id in (select value from string_split(‘,999’,‘,’)) or
    service_id in (select value from string_split(‘125,101,102,106,107,119’,‘,’))

    Screenshot 2022-11-29 170947https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/66aa598668b72d94ab47465f7193cae84b354c08_2_1035x457.jpeg 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/66aa598668b72d94ab47465f7193cae84b354c08_2_1380x610.jpeg 2x" data-dominant-color="E1E5E2">
    Screenshot 2022-11-29 1709471723×763 113 KB


    #SQL
    #webMethods


Related Content