Return custom query as struct?

[Thorsten Eilers]

Hi,

I have a custom query, which is needed because of multiple joins to the same model.

To edit the dataset, wheels needs a structure.

Is it possible to return the query result as structure?

public function getPSALink(required string linkID) {   
        var queryService = new query();
          queryService.setName("qryPSALink");    
        queryService.setDatasource("myDatasource");
        queryService.setSQL("
                SELECT *

               FROM mytable

");           
        var result = queryService.execute();
        return result.getResult();                       
    }

Thanks in advance.

Thorsten

[Tom King]

Lucee allows for setting a struct as a return type 

https://docs.lucee.org/guides/cookbooks/Query_returntype.html

Not sure if you can do it via `new query()` though?

T

[Brandon Shea]

Ben Nadel has a gist for this, which will work with ACF if you're not on Lucee.

Ask Ben: Converting A Query To A Struct (github.com)