Check out the LimeSurvey source code on GitHub!

SQL Condition

More
5 years 10 months ago #59794 by armandotaffarel
Hi.

It's possible to define SQL conditions for questions?

I have other tables on database, imported from another system, and I have to restrict some questions using my data.

It's possible? How?

Thanks.

Please Log in to join the conversation.

More
5 years 10 months ago #59796 by c_schmitz
Sorry, not possible.

Best regards

Carsten Schmitz
LimeSurvey project leader
The following user(s) said Thank You: armandotaffarel

Please Log in to join the conversation.

More
5 years 10 months ago #59797 by armandotaffarel
Well, I need this... then.... I will make ;)

I'm thinking to use the "constant condition", putting my SQL in that field with a prefix like "::SQL::".

After, edit the index.php and manage that condition with that prefix, executing the SQL.

Is this a good way?

Thanks.

Please Log in to join the conversation.

More
5 years 10 months ago #59807 by DenisChenu
I think it's best to use some jquery/ajax function.

remysharp.com/2007/01/20/auto-populating...s-using-jquery-ajax/

And again with jquery: add a select box: fill a text short question with this select box.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
The following user(s) said Thank You: armandotaffarel

Please Log in to join the conversation.

More
5 years 10 months ago #59827 by armandotaffarel
I'll try. Thanks.

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form