import("system.result");
import("system.neon");
import("system.vars");
import("Sql_lib");

if(vars.get("$sys.operatingstate") == neon.OPERATINGSTATE_NEW)
{
    if(vars.get("$this.value") == null)
    {
        result.string("0");
    }
}
else if(vars.get("$field.ACTIVITYID"))
{ 
    var count = new SqlBuilder().selectCount()
                .from("ADVERTISING")
                .where("ADVERTISING.OBJECT_ROWID", "ACTIVITY.ACTIVITYID")
                .toString()

    result.string(count);
}