QueryEntity Difference between = and includes

saravanarajanj

Certified Senior Developer

over 8 years ago

Hi,
We are experiencing the below behavior while using queryEntity.
The queryFilter with "=" operator is returning zero records whereas the filter with "includes" operator returns more records. We are using Oracle database, I ran the query with "=" and "like" operator and able to fetch records in both case.
a!queryFilter(
field:"department",
operator:"=",
value:"Engineering"
)

a!queryFilter(
field:"department",
operator:"includes",
value:"Engineering"
)
Any suggestions/comments are appreciated on this. Thanks!

Discussion posts and replies are publicly visible

Parents

0 rodgraham
Certified Lead Developer
over 8 years ago

Never seen an issue with this before. Might be worth checking that Appian is connecting to the database you are running the query against and that the data entity is mapped to the correct table and column.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 rodgraham
Certified Lead Developer
over 8 years ago

Never seen an issue with this before. Might be worth checking that Appian is connecting to the database you are running the query against and that the data entity is mapped to the correct table and column.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data