I have data in datastore, data types match, but datastore search records for some reason does not search for this data and does not display any results. As a result, a lot of duplicate data is created.
What can be the problem and how to solve it?
Hi @Alex23 , You’re searching for column data other than columns {a,b,o}, right ? it’s still weird to me because your filter condition is {user_id AND ticket_id} and it returns the value like it was OR condition… What does your database look like ?
Please open your data store with the Browse button and take a screenshot to post here. It helps with diagnosing a lot
- attached a screenshot of the database
- How do I need to write conditions to get search results on datastore? Please write more details
What happens if you manually type in the user id and ticket id when you run the module by itself? If it gets the record, check there’s no extra spaces at the start or end of your data or the fields in your filters
thanks for the tip, when I manually entered the data into the database, then the search worked and found the record. How do I understand why the data is being entered incorrectly and what should I do?
@Alex23 Try trim() function if the problem is in whitespaces.
You can also try changing the filters to “contains” instead of “equal to”
thanks that helped, although no extra spaces were visible
Thank you for your help too, I’ll keep you in mind!