Back to limesurvey.org

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?

  • blocka
  • blocka's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
8 years 1 month 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.
  • blocka
  • blocka's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
8 years 1 month 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.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
8 years 1 month ago - 8 years 1 month 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 support - Plugins, theme and development .
I don't answer to private message.
Last edit: 8 years 1 month ago by DenisChenu.
The topic has been locked.
Moderators: holch, tpartner

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source