- Posts: 29
- Thank you received: 1
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Database Query
- rbernhardthki
- Topic Author
- Offline
- Junior Member
Less
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?
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
4 years 5 months ago #190165
by DenisChenu
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.
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 …
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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 29
- Thank you received: 1
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.
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
- Offline
- Junior Member
Less
More
- Posts: 32
- Thank you received: 0
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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 29
- Thank you received: 1
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.
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
- Offline
- Junior Member
Less
More
- Posts: 32
- Thank you received: 0
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.
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.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5070
- Thank you received: 1263
4 years 1 month ago #194036
by jelo
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
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.