Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Using BT and CP together in same ranges.

Former Member

‎11-29-2016 11:46 AM

0 Kudos

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.

Preview file
16 KB
2 REPLIES 2

raymond_giuseppi
Active Contributor

‎11-29-2016 12:55 PM

0 Kudos

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


Former Member
In response to raymond_giuseppi

‎11-30-2016 5:40 AM

0 Kudos

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?