My knowledge base is very buggy
# 🤝help
r
hi
f
Hey there👋 You might want to look into using a table instead of a document for your structured data. I hope this video can help you decide

https://youtu.be/eWKnezZp9qk?si=WvRjvraTVdSh7K26

b
Okay, thank you very much. I transferred it to the table and it seems to have worked
f
That is amazing to hear!
b
Could someone please help me understand why the knowledge base is not consistently returning all items from the table? Each time I make a query, the results seem to vary, even after organizing all the data in the table. I greatly appreciate any help with this matter https://cdn.discordapp.com/attachments/1227716828705587222/1228058793800372254/image.png?ex=662aa9e0&is=661834e0&hm=e9eb14bb267a22d72f3dd96d68d3e8d37916a15aad6157bd7d51fd5f7a448354& https://cdn.discordapp.com/attachments/1227716828705587222/1228058794345369640/image.png?ex=662aa9e0&is=661834e0&hm=452d0a98363aca26ee608c3e2d32ab70335e53a7bb530a3956afc77967a1bbd8&
The table has 37 items
f
Just to make sure, you have included the table as a source right?
b
Yes, i included
f
I honestly haven't used tables that much as a KB source. I would think that its not really meant for finding everything, but rather finding specific things. Maybe another @User can help us out here?
c
are you getting the right answer if you "ask a question" on your KB directly ? if so than it most likely the way your query is structured. Are yo using the KB card or execute code ?
b
I'm not getting the right response from the KB when asking it directly. I ask it to list all items from the table, and it's returning 22 items sometimes 23, it varies. My table has 37 items; it never returns exactly the 37. I'm not running any code.
f
What if you ask it for the price of one of the products? What does it respond with?
b
It responds correctly.
But I need it to return all the items to me because I'm saving this in a variable.
f
I would then recommend you to use the find records card.
So something like this:
Copy code
javascript
workflow.variableForEverything = await Data1Table.findRecords({
  filter: AI`everything`
})
In an execute code card
b
I'll check if the way I'm creating it will work. Thank you for being helpful.
f
You are very welcome 🙂
And let us know how it goes
2 Views