Please be respectful of all AppDragers! Keep it really civil so that we can make the AppDrag community of builders as embracing, positive and inspiring as possible.

api sql question...

  • How do I call a empty column? I have tried all SQL statement possibles and it does not work...

  • 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 = ""

  • Thanks Daniel for you response.

    my question it's about the API call on appdrag.

    for example I use

    column_name != VALUE '' <<< this is not working
    column_name != VALUE <<< this is not working
    column_name != VALUE "" <<< this is not working
    column_name is VALUE NOT NULL <<< this is not working

    column name is a text field

    also i tried with another column that is a boolean this

    another_column_name is VALUE FALSE <<< this is not working

    I have tried all SQL statements possibles but on the API do not work

  • @Pablo-Garcia here could you provide your full SQL query and code? probably your code is calling an SQL query ... but since you didn't provided anything we can only guess 😉

    also your partial syntax seems wrong

    It should be:

    SELECT * FROM Table WHERE column_name != 'YOUR_VALUE' AND column_name IS NOT NULL;

  • @Pablo-Garcia

    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 🙂

Log in to reply