webMethods

 View Only
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