SearchBuilderOptions()/SearchPaneOptions() generated invalid code on SqlServer

Modify the sample to the following code

.Field(new Field("sites.name")
    .SearchBuilderOptions(new SearchBuilderOptions()
        .Value("sites.id")
        .Label("sites.name")
        .LeftJoin("sites", "sites.id", "=", "users.site")
    )
)

This works on SQLite not SqlServer/MSSQL.

With SqlServer, you will get "Column '[sites].[name]' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."

Finally, "fixing" this is:

.Field(new Field("sites.name")
    .SearchBuilderOptions(new SearchBuilderOptions()
        .Value("sites.id")
        .Label("MAX(sites.name)")
        .LeftJoin("sites", "sites.id", "=", "users.site")
    )
)

Not sure if that is the appropriate fix though...

Usa l’esempio SearchBuilderOptions fornito come riproduzione, quindi confronta l’SQL generato su SQLite e SQL Server, concentrandoti sulla gestione di SELECT e GROUP BY per il valore Label. Il lavoro è completato quando l’esempio genera SQL valido su SQL Server mantenendo il comportamento su SQLite; conferma se il workaround MAX(sites.name) è il comportamento previsto.