RQL - How to add JSON field conditionally

JPReis — Sun, 24 Dec 2023 17:38:50 GMT

I'm trying to addcolumn with a field from a JSON configuration, but only if certain condition of another field is satisfied.

Something like this:

config from cloud.resource where api.name = 'aws-api-xyzl' CONDITIONS addcolumn $.list[ if CONDITIION_FIELD equals 12345)].FIELD_OF_INTEREST

I already tryed the filter syntax used in JSON.RULES assertion, but it didn't work:

config from cloud.resource where api.name = 'aws-api-xzyl' CONDITION addcolumn $.list[?any(FIELD_FOR_CONDITION == CONDITION)].FIELD_OF_INTERERST

Re: RQL - How to add JSON field conditionally

MLabadie — Thu, 28 Dec 2023 17:41:59 GMT

Conditional statements are not supported in RQL.