Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: SQL Condition

SQL Condition 5 years 7 months ago #59794

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.
The administrator has disabled public write access.

SQL Condition 5 years 7 months ago #59796

  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 1032
  • Thank you received: 135
  • Karma: 97
Sorry, not possible.
Best regards

Carsten Schmitz
LimeSurvey project leader
The administrator has disabled public write access.
The following user(s) said Thank You: armandotaffarel

SQL Condition 5 years 7 months ago #59797

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.
The administrator has disabled public write access.

SQL Condition 5 years 7 months ago #59807

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9555
  • Thank you received: 1373
  • Karma: 389
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 (Need support ?).
A bug not reported is a bug not corrected. | 2.61lts version improved | Need plugins for LimeSurvey ?
The administrator has disabled public write access.
The following user(s) said Thank You: armandotaffarel

SQL Condition 5 years 7 months ago #59827

I'll try. Thanks.
The administrator has disabled public write access.
Time to create page: 0.230 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form