sql case/if..then statement in arangodb aql

[Kenneth McMillion]

Hi is there a way to do a case statement in arangodb from the http api

[Frank Celler]

Does this Issue https://github.com/triAGENS/ArangoDB/issues/468 address your problem or do have something else in mind?

[Kenneth McMillion]

I think it will I will have to read further.into your link but what I was trying to do was convert  the pseudo  sql below to aql - I have a clients collection  that looks like this

{

    "client":"Mr Green",

    "mailing_address": {

    "line2": "",

    "line3": "",

    "state": "FL",

    "zip": "32810",

    "line1": "3225 efg AVE",

    "city": "ORLANDO"

  },

  "physical_address": {

    "line2": "",

    "line3": "",

    "state": "FL",

    "zip": "32815",

    "line1": "4567 abc AVE",

    "city": "ORLANDO"

  },

  

    }

{

    "client":"Mr Pink",

    "physical_address": {

    "line2": "",

    "line3": "",

    "state": "FL",

    "zip": "32810",

    "line1": "2378 eieio AVE",

    "city": "ORLANDO"

  }

}

in sql I could do something similar to this:

select client, address =

   case

      when mailing_address is null then physical_address

      else  mailing_address

from clients

[Jan Steemann]

Hi Kenneth,

I think you can use the ternary operator for this in AQL:

FOR c IN clients
RETURN {
client: c.client,
c.address: IS_NULL(c.mailing_address) ? c.physical_address :
c.mailing_address
}

Best regards
Jan

> --
> You received this message because you are subscribed to the Google
> Groups "ArangoDB" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to arangodb+u...@googlegroups.com
> <mailto:arangodb+u...@googlegroups.com>.
> For more options, visit https://groups.google.com/d/optout.

[Kenneth McMillion]

Thank you I will give that a try