appsmithorg / appsmithorg/appsmith
[Bug]-[45]:For an SQL query, can't make this regex work
Đang mở
Bug
Integrations Pod General
Integrations Product
Low
Medium effort
Postgres
Production
Query & JS Pod
Query Widgets & IDE Pod
- Ngôn ngữ chính
- TypeScript
- Star
- 40.9k
- Fork
- 4.8k
- Merge trung bình
- 1 ngày 22 giờ
- Pull request đã merge (30 ngày)
- 45
Mô tả
## Description
For an SQL query can't make this regex work: '{{Input1.text.replace(/'/, "")}}'
for example:
`SELECT * FROM users where gender = '{{Input1.text.replace(/'/, "")}}' ORDER BY id LIMIT 10;`
### Steps to reproduce the behaviour:
1. Add an input widget: enter text `male` within the input
2. Create a query on the test postgres DB: `SELECT * FROM users where gender = '{{Input1.text.replace(/'/, "")}}' ORDER BY id LIMIT 10;`
3. The query above doesn't run
### Workaround
https://github.com/appsmithorg/appsmith/issues/7484#issuecomment-1021190239
Hướng dẫn đóng góp
Đánh giá
Issue này chưa được đánh giá.