There is no specific function in Elgg 3 for it. I could help you if you explain exactly what you're trying to do.

Thanks a lot.

I use the _elgg_get_access_where_sql to get a where clause to retrieve the data that a user has permission to read.

My code for elgg 2.X looks  as followed.

public function pessek_count(array $options = []) {


$recipient_guid = elgg_extract('recipient_guid', $options);

$status = elgg_extract('status', $options);


$access_sql = _elgg_get_access_where_sql([

'table_alias' => 'pessek',

'owner_guid_column' => 'access_owner_guid',

'guid_column' => 'access_guid',

'use_enabled_clause' => false,

]);


switch ($status) {

default :

$status_sql = '1=1';

break;

case 'read' :

$status_sql = 'pessek.time_read IS NOT NULL';

break;

case 'unread' :

$status_sql = 'pessek.time_read IS NULL or pessek.time_read = 0';

break;

case 'seen' :

$status_sql = 'pessek.time_seen IS NOT NULL';

break;

case 'unseen' :

$status_sql = 'pessek.time_seen IS NULL or pessek.time_seen = 0';

break;

}


$query = "

SELECT COUNT(DISTINCT pessek.id) as total

FROM {$this->table} pessek

WHERE pessek.recipient_guid = :recipient_guid

AND ($status_sql)

AND $access_sql

";


$params = [':recipient_guid' => (int) $recipient_guid];


$row = get_data_row($query, null, $params);

if ($row) {

return (int) $row->total;

}

return 0;

}

You should use \Elgg\Database\Clauses\AccessWhereClause

Never tried but you can do it:

function (QueryBuilder $qb, $main_alias) use ('pessek') {
    $wheres = [];
    $wheres[] = $qb->compare("{$main_alias}.owner_guid", '=', 'access_owner_guid', ELGG_VALUE_GUID);
    $wheres[] = $qb->compare("{$main_alias}.guid", '=', 'access_guid', ELGG_VALUE_GUID);

    return $qb->merge($wheres, 'AND');
};

Try to check your logs again after this guide:

Advanced Settings -> Debugging and Logging -> Log level: Log all errors, warnings and notices -> Save

Thanks a lot

May I ask here, how do I change the widget background. Thanks!.

@jacintodavila CSS:

.elgg-module-widget > .elgg-body

I guess that if I want to change just one of them I have to do:

.elgg-module-widget > .elgg-body >. mywidget-body