Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

How to check for total # of surveys in an LS Instance?

More
5 years 11 months ago #151280 by blocka
How to check for total # of surveys in an LS Instance? was created by blocka
I want to be able to show all LS users the total # of surveys currently in an LS instance.

I would have figured that this would return that value:
Code:
$currentSurveysQuery = "SELECT count(*) FROM {{surveys}}";
$currentSurveys = Yii::app()->db->createCommand($currentSurveysQuery)->queryAll();

But if I log in as a new user who can only create surveys (and not see all surveys), the above query returns "0" -- even if there are 50 surveys in the LS instance.

Can anyone point me to what I'm doing wrong?
The topic has been locked.
More
5 years 11 months ago #151281 by blocka
Replied by blocka on topic How to check for total # of surveys in an LS Instance?
Ah, figured it out, query needs to be:

$currentSurveys = Yii::app()->db->createCommand($currentSurveysQuery)->queryScalar();
The topic has been locked.
More
5 years 11 months ago - 5 years 11 months ago #151306 by DenisChenu
Replied by DenisChenu on topic How to check for total # of surveys in an LS Instance?
Did you try Survey::model()->count(); ?


[edit] www.yiiframework.com/doc/api/1.1/CActiveRecord#count-detail
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Last edit: 5 years 11 months ago by DenisChenu.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source