How to use IN operator in Like operator using actuate birt
Sai krishna
Member
Hello Team,
Good day!
Can anyone please tell me how to use IN operator in LIKE. Thanks in advance.
Regards,
Sai
Good day!
Can anyone please tell me how to use IN operator in LIKE. Thanks in advance.
Regards,
Sai
Warning
No formatter is installed for the format ipb
0
Comments
-
Hello Jeff,
Good day!
I will try to explain you with an example:-
Consider there was a text box, where user can enter multi-value by separating them using 'commas'. In the script section I have given IN operator for that textbox to filter the query by giving the user entered values.
If the value is 123456 we can get the value. But here the issue comes, the user may also enter the half value say, 123 but he must get all values starting with '123' so here I have to use LIKE operator. But he may enter multi-values with half values so I need to use LIKE operator along with IN operator.
Hope you got my point. Could you please suggest me how to use both the LIKE and IN operators in sql/mysql.
Thanks in advance.
Regards,
Sai
Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 118 Developer Announcements
- 52 Articles
- 150 General Questions
- 137 Services
- 56 OpenText Hackathon
- 35 Developer Tools
- 20.6K Analytics
- 4.2K AppWorks
- 9K Extended ECM
- 912 Cloud Fax and Notifications
- 82 Digital Asset Management
- 9.3K Documentum
- 30 eDOCS
- 175 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 6 XM Fax