Skip to Content

Using BT and CP together in same ranges.

Nov 29, 2016 at 11:46 AM


avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Raymond Giuseppi
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.


Show 1 Share
10 |10000 characters needed characters left 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?