Skip to Content
avatar image
Former Member

Using BT and CP together in same ranges.

I have a requirement to use select options and user can enter wild card entries in that like

capture1.jpg . Now, the low and high values entered by the user are substrings of another string type column in one of my tables. So, to fetch the values I am using ranges. But the idea is at the same time I need to check for the pattern since it is a substring and also I need to check for the range entered by the user. So, how to accomplish this.

capture1.jpg (16.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 29, 2016 at 12:55 PM

    No, the low value is considered as a search pattern only with OPTION = 'CP' or 'NP'. With 'BT' it will be considered as a single value. If you want to combine some ranges and pattern use two select-options/range table and use a AND to merge both, WHERE field IN range1 AND field IN range2. You could use a FM like SELECT_OPTIONS_RESTRICT so user can only enter list of values and range in first select-options and pattern in the second one.

    Regards,
    Raymond


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Can you please explain with detail...I am fetching from TPLOG table, and I am using select options for the attribute CMDSTRING, I want to know, how can we use ranges for comparing the transport requests and fetching them?