Welcome to the LimeSurvey Community Forum

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

Database Query

  • rbernhardthki
  • rbernhardthki's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 years 5 months ago #190148 by rbernhardthki
Database Query was created by rbernhardthki
Hi,

I have been trying to pull data direct from the database into an Excel and apply filter in M etc etc...

I am really struggling writing a query that uses the question title, instead of the SGQA identifier.

In table lime_questions, I can CONCAT the QID, PARENT_QID, SID and GID to get the SGQA, however for Array (Texts) there is also the SCALE_ID which makes it difficult to get the SGQA code.

Does anyone have a query for this?
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 5 months ago #190165 by DenisChenu
Replied by DenisChenu on topic Database Query
I never use direct SQL since there are API
api.limesurvey.org/classes/remotecontrol...hod_export_responses

Then when we update our system : you don't need to update yours …

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.
The topic has been locked.
  • rbernhardthki
  • rbernhardthki's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 years 5 months ago #190187 by rbernhardthki
Replied by rbernhardthki on topic Database Query
Hi Denis,

Thank you, the API is useful but not fit to purpose at the moment.

I am running reports from Limesurvey into Excel Power Queries and Power BI direct.
The topic has been locked.
  • christianlangkamp
  • christianlangkamp's Avatar
  • Offline
  • Junior Member
  • Junior Member
More
4 years 1 month ago #194003 by christianlangkamp
Replied by christianlangkamp on topic Database Query
So how do you connect directly from powerquery to Limesurvey ? Are you on the hosted version or do you have your own instance ?
The topic has been locked.
  • rbernhardthki
  • rbernhardthki's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 years 1 month ago #194007 by rbernhardthki
Replied by rbernhardthki on topic Database Query
Sorry, what do you mean by that?

We host a version of Limesurvey on www.limesurvey.Contoso.com .

To get reports, I connect directly to the SQL database either from Excel or Power BI.
The topic has been locked.
  • christianlangkamp
  • christianlangkamp's Avatar
  • Offline
  • Junior Member
  • Junior Member
More
4 years 1 month ago #194035 by christianlangkamp
Replied by christianlangkamp on topic Database Query
Was trying to have a look Contoso.com jumps directly to the main Microsoft website …

So my question is, I don't want to get into hosting myself, but it would be really sweet to be able to connect to the Limesurvey data like you would connect to an SQL Database.
The topic has been locked.
More
4 years 1 month ago #194036 by jelo
Replied by jelo on topic Database Query

christianlangkamp wrote: So my question is, I don't want to get into hosting myself, but it would be really sweet to be able to connect to the Limesurvey data like you would connect to an SQL Database.


Contoso.com is used in Microsoft Docs as a placeholder for your own domain.

rbernhardthki can connect directly to the database cause it's not a SaaS hosting via LimeSurvey.org.

It makes so sense to post in every thread here. No customers of LimeSurvey.org Hosting can access the database directly via SQL. The only interface is the RemoteControl API.

Focus on one thread:
www.limesurvey.org/forum/can-i-do-this-w...esurvey-sql-database

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose