Search records, does not return results even if the record exists

Questions & Answers
1

I have a problem when searching for records in a Data Store.
From a scenario I read a file and load a series of data in a Data Store. Later, from another scenario, I send an invoice, and I look for if the NIF of the supplier of the invoice exists in the Data Store.
The problem is that it only finds me results if I edit the field I want to find and save it. If I search for a field that I have not edited and saved, it does not return results even if the record exists.
Is there any explanation for this?

2

Hello @JoseLopez

Can you please send a screenshot with your Data Store module setup.

//Vlad

3

This image is part of my scenario, then I only parse data and generate a file in Drive.

As you can see in this run, I search the data store for ‘AccountNumber = 43000004’ and ‘NIF = 43496809Z’ that exist, but no results are returned.
If I edit said record, I simply delete and paste this data again, the next execution does return the correct results.

make-01
make-011374×667 58.6 KB

make-02
make-021134×580 23.7 KB

make-03
make-031431×618 58.7 KB

4

Sorry, the previous request was not entirely correct. In this image you can see the correct search data.

make-04
make-041159×613 46.4 KB

5

Hi again @JoseLopez

For me is working

image
image782×664 44.6 KB

1.Make sure you have chosen the right Data store in the module.

2.From what I see you have 2 conditions in Data Store module.
Above you said you wanted to search by this condition “if the NIF of the supplier of the invoice exists”. Try to put only this condition to see if it works .

Don’t hesitate to contact us if you require further assistance.

//Vlad

1 Like
6

Yes, I need several conditions to better fit the search.
Only with the NIF condition, it doesn’t work for me either.

make-06
make-06843×515 38.4 KB

I know it’s not easy to reproduce, and I can’t find if I’m doing something wrong, but simply by editing, deleting the data, pasting it again and saving, the scenario works for that data, it doesn’t work for the following ones.

Thanks for your answer

7

Hi, @JoseLopez, from what you commented, you could verify that the data does not have any space or strange characters.

1 Like
8

Thanks @Francisco_Fontes, that should be it, I added a trim before saving the data and now it works for me, even with 3 conditions in the search.
beginners mistake

2 Likes
9

@JoseLopez, In case it is the ultimate answer to your question, could you please :white_check_mark: mark the reply as a solution?

It helps keep the community space tidy :blush:

Thanks a lot!

1 Like