Re: Relational Databases Examples

[Christoph Kappestein]

Hi,

so there are multiple options, you could i.e. use the SQL-Builder action s. https://docs.fusio-project.org/docs/backend/api/action/sql-builder/ which provides a JSON syntax to create complex results.

You can also create a custom action s. https://docs.fusio-project.org/docs/use_cases/develop_custom_action/ or https://docs.fusio-project.org/docs/backend/api/action/php-processor/ where you manually write all SQL queries

best regards

Christoph

jml...@gmail.com schrieb am Dienstag, 6. September 2022 um 07:55:07 UTC+2:

Supposed i have this generated

{ "totalResults": 4, "itemsPerPage": 16, "startIndex": 0, "entry":
[ 

 { "id": 4, "plan": 1 }, 

 { "id": 3, "plan": 2}, 

 { "id": 2, " plan": 1 }, 

 { "id": 1, " plan ": 3 }
 ]
}

But I want to generate something like this

{ "totalResults": 4, "itemsPerPage": 16, "startIndex": 0, "entry":
[ 

 { "id": 4, "plan": Gold}, 

 { "id": 3, "plan": Silver}, 

 { "id": 2, " plan": Gold}, 

 { "id": 1, " plan ": Bronze }
 ]
}

plan values: 1,2,3 should be substituted with values from a different table with the following:
1 == Gold
2 == Silver

3 == Bronze

Are there available examples using custom actions and/or using other means? Any links would be very much appreciated. Thank you very much.

[John Lirac]

Thanks, Christoph.