Database Query

Plus d'informations
il y a 5 mois 1 semaine #190148 par rbernhardthki
Database Query a été créé par 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?

Connexion ou Créer un compte pour participer à la conversation.

LimeSurvey Partners
Plus d'informations
il y a 5 mois 1 semaine #190165 par DenisChenu
Réponse de DenisChenu sur le sujet 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 .
An error happen ? Before make a new topic : remind the Debug mode .

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 5 mois 1 semaine #190187 par rbernhardthki
Réponse de rbernhardthki sur le sujet 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.

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 1 mois 2 semaines #194003 par christianlangkamp
Réponse de christianlangkamp sur le sujet 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 ?

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 1 mois 2 semaines #194007 par rbernhardthki
Réponse de rbernhardthki sur le sujet 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.

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 1 mois 2 semaines #194035 par christianlangkamp
Réponse de christianlangkamp sur le sujet 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.

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 1 mois 2 semaines #194036 par jelo
Réponse de jelo sur le sujet Database Query

christianlangkamp écrit: 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

Connexion ou Créer un compte pour participer à la conversation.

Commencez dès maintenant !

Créez simplement un compte et commencez à utiliser LimeSurvey dès aujourd'hui.

Inscrivez-vous maintenant

Inscrivez-vous à notre Newsletter!