How to count row with a specific value in Editor ?

dgillier

Hello,

I'm trying a send to datatable/editor a pseudo field (not present in the DB) with the count of occurence in a joint table .
Seems that we cannot using SQL query ?
Anyway to do that ?

colin

Hi @dgillier,

Provided the returned data is in the format expect by Editor, you can get fields from any source. There's some example that may be helpful for you, this one and perhaps this one.

Hope that helps,

Cheers,

Colin

allan

Just to add to what Colin has said - it is possible to use an SQL function in the PHP, .NET and Node libraries for Editor, but I'm not clear if that is what you need or not. Perhaps you can explain more fully what you are looking to do please?

Allan