https://discord.gg/botpress logo
Join Discord
Powered by
SOS findrecords on table with MongoDB style filter...
# 🤝help
g
report_01HZ4SCHMECNAZPTJ6ATZH9XZ6 findRecords Function on Tabe is failing when using MongoDB style filter. Ths used to work just fine now customer reported the problem. Please help! @rich-battery-69172 @crooked-van-25152 The filter is made from the natural language query that customer says. 18:25:51 error ProductsTable table Execute operation findRecords({"filter":{"producttype":"Wine","varietal":{"$in":["PINOTNOIR"]},"subregion":"ALSACE"},"limit":500,"offset":0}) failed: An unexpected error occurred when trying to process your request. (Error ID: err_20240530125553x078486C9) Execute operation findRecords({"filter":{"producttype":"Wine","varietal":{"$in":["PINOTNOIR"]},"subregion":"ALSACE"},"limit":500,"offset":0}) failed: An unexpected error occurred when trying to process your request. (Error ID: err_20240530125553x078486C9) [Error, An unexpected error occurred when trying to process your request. (Error ID: err_20240530125553x078486C9)] {"scope":"table","tableName":"ProductsTable"}
a
Hey @green-policeman-96580 , instead of
Copy code
{
  "filter": {
    "producttype": "Wine",
    "varietal": {
      "$in": [
        "PINOTNOIR"
      ]
    },
    "subregion": "ALSACE"
  },
  "limit": 500,
  "offset": 0
}
try
Copy code
filter: {
    producttype: { $eq: 'Wine' },
    subregion: { $eq: 'ALSACE' },
    varietal: { $in: ['PINOTNOIR'] }
  },
g
Ty for help but still the same error persists, Execute operation findRecords({"filter":{"producttype":{"$eq":"Wine"},"varietal":{"$in":["PINOTNOIR"]},"subregion":{"$eq":"ALSACE"}},"limit":500,"offset":0}) failed: An unexpected error occurred when trying to process your request. (Error ID: err_20240530200408xA505A6AB) [Error, An unexpected error occurred when trying to process your request. (Error ID: err_20240530200408xA505A6AB)] {"scope":"table","tableName":"ProductsTable"}
The first code was working before with no probblems ...
@cold-motherboard-82208 Please resolve working bot has started giving this error now
a
@green-policeman-96580 We're currently working on this issue and will provide an update as soon as we have more information to share.
g
Ty @aloof-traffic-22451 awaiting
@aloof-traffic-22451 Can you please update? Live customer is stuck and our offering
TY
a
@green-policeman-96580 We have filed an internal ticket and we will paste updates when we get them.
g
@aloof-traffic-22451 Ty for update let me know if more details are needed.
@aloof-traffic-22451 Please provide update..
@aloof-traffic-22451 @crooked-van-25152 @cold-motherboard-82208 Anyone this is a severe bug. Atleast provide an update. This MongoDb style queries on tables used to work. If this won't be fixed please let me know, so that we can try to do a major change and achieve the same functionality using our own server side query moving away from tables usage and changing arch of our bot.
r
@green-policeman-96580 The issue has been fixed and the patch will be in production by tomorrow
g
Ty @rich-battery-69172 it is working now
3 Views
PreviousNext
Powered by