Hello Appdrag team,
It's been months that I've noticed it feels like I'm logged out of Appdrag very often - at least once per week, if not twice.
Did you change how the login authentication storage is handled? Is it related to restarting the browser/computer? Or something else?
I do use it on multiple computers... does that 'reset' the token and invalidate the other computer? It didn't do that before.
Hello team,
Bug:
When adding a column to a table with a time field that has an existing default value, the alteration fails.
Expected behavior:
It should work 
Problem:
When rendering the default value for the time field, the number is formatted for humans. I.e. 110000 becomes 11:00:00 in the UI.
However, when altering the table, your code is performing an UPDATE query that tries to set 11:00:00 as the default value for a TIME type column, which fails.
Workaround:
Manually editing 11:00:00 to 110000 before saving your changes to the table causes the update to succeed.
I've seen the "connect an external database" feature in Cloud Backend.
I do have a question (I suspect the answer is "yes" though...):
Does the 1k API calls per minute apply?
The reason I suspect yes is that we are still going through your endpoint... but I wanted to check
It's the dropdown menu found by clicking the "filter" button on CloudDB
Hello team,
I have a site where I've migrated the 'web' portion to another platform.
However, I need to keep the CloudBackend.
Can I cancel the front-end plan and still redirect web traffic to the new URL, without affecting API calls and files stored in the filesystem?
Hello, we're using the following settings to try to build a view of items in our DB that have been published in the last 30 days (according to a field we set ourselves), and it doesn't seem to work.
We've tried the option "Number of days ago" and "Number of days from now", (which I'm not sure what the difference is but neither work.
The field type is "Date" in CloudDB :
And we do have an episode which should 'match' :
Hello team,
I've exported my project using the appdrag cli tool, but the appdrag.js file is failing to run as part of the exported project, with the following error:
Uncaught SyntaxError: Identifier 'isInIframe' has already been declared
Any ideas?
Solved... and I think I know why, very edge case
I had a callback at the very end of my function handler, after a bunch of async/await stuff.
Lambda has a context object:
"callbackWaitsForEmptyEventLoop"
From their docs:
"Set to false to send the response right away when the callback runs, instead of waiting for the Node.js event loop to be empty. If this is false, any outstanding events continue to run during the next invocation."
Anyway, removing the callback at the end of the function worked. I think lambda was executing the callback without waiting for the inner await'd functions to finish, which killed the running processes and prevented the updates from happening.
Does "Try" run with a different context object than a scheduled function?
@jbenguira Sorry to report, I have removed "Require API Key" and set the recurrence to every 5 minutes, it is still not working.
It says there are 172 executions today, which means it is probably running every 5 minutes... but the result of the function is not happening.
Is there any difference in the execution environment between clicking "try" and running via Scheduler?
Interesting. I have changed it to run at 2:05 AM, but here was the previous configuration, FYI. We will see if it starts working again Thanks!
Hello team,
The scheduled function FUNCTION_161968 of my project goodvibes-474a9a works perfectly when I run it with "Try", but only works intermittently as a scheduled function. I can't seem to understand/predict when / how / why it works sometimes or not.
It's something I need to run reliably every day at 1 AM. @App-Drag @Joseph-Benguira can someone help me understand why it might not be working?
Hi @Wassim, while we were waiting for the fix, I switched one of the fields back to linked 'field' (singular), but unfortunately, now that column is blank in CloudDB (but not in CB).
The data in each field is just an integer, no brackets, etc., and it shows up correctly in CloudBackend.
Thanks Wassim ! I will check it out and hopefully I can make everything work now for my scripts
Hi Olivier,
If you share the link to the page I'll be able to better investigate.
My first instinct is to add padding/margin to the search box, or revisit its position in the page - something is forcing it to be that small.
Thanks for trying it out!
I'm confused by the word VALUE in your query. I am pretty sure that is causing the issue.
If you're coming from a different SQL platform, you should be aware that CloubBackend uses MySQL 5.8 via AWS Aurora, so your queries have to adhere to that syntax.
I think if you simply removed "VALUE" from most of your queries above things might start working
Hi Pablo, I'm not sure what you mean. Are you trying to find rows where a certain column is empty?
I usually use:
SELECT * FROM Table WHERE Column IS NULL OR = ""
Perhaps related to the other dropdown issue
It seems Cloud Backend's UI and CloudUI treat the multi-select fields differently.
CloudBackend escapes the integer Primary Keys, but the CloudDB UI does not. I ended up with something like this if you use both on a single row:
Also, because the dataType in SQL is medium text, not JSON, it's very difficult to parse.
Can you please make it consistent (integers alone, without quotes, is preferred but any consistency is better than this) and also can you tell us if it's possible to add a JSON data field type? Aurora SQL supports MySQL 5.7+ now including JSON field types
Hi @Joseph-Benguira and @Wassim-Samad thank you very much.
Can you please update the prettier/magic wand function to support the new Syntax ? It broke my code when I tried to use it
Thanks!
While you're at it, I have a second (perhaps related) bug:
When using the "Linked fields by reference" column type, no data shows up ?
Hello,
When creating a table with "Dropdown Multi" type selected, it works fine in the regular CB table view, but in CloudDB I can't input anything. Is this a bug?
https://prod.appdrag.com/Database/database.html?shared=b3a2521d-686a-4eac-96de-1ade6cfab274