Special Field - SQL

Category: Community Surveys 3 weeks ago

Hi ;

I am very excited to see a new special question type call SQL.

I know how to use the following except Conditions

Table Name*:
Label Column*:
Value Column*:
Conditions*:

Is there any documentation online for this question type , how do i use the conditions type is it in mysql query format ?

Thank you for all the awesome addin

Is it possible for future release to make the dropdown searchable , like when the user type a keyword it will auto select anything which matach. This is good for dropdown of a long list which exceed 50 or more data row

Like it on Facebook, Tweet it or share this topic on other bookmarking websites.
  • Re: Special Field - SQL

    by » 3 weeks ago


    I did not create the documentation yet, sorry about that. Will add it soon. Please find below the required info.

    Conditions: This is documented on the icon beside the label. Posting verbatim copy here:

    Enter comma seperated list of conditions. Supports the following operators: (eq),(ne),(lt),(gt),(le),(ge),(like). All conditions are gluid with AND operator. Eg. column1(eq)2,column2(eq)test,column3(ne)100,column4(ge)20,column5(like)test

    You can build "where" condition of the sql command using this option. the conditions are like this.

    • column1(eq)2 - this will produce "where column1 = 2"
    • column1(ne)2 - this will produce "where column1 != 2"
    • column1(lt)2 - this will produce "where column1 < 2"
    • column1(gt)2 - this will produce "where column1 > 2"
    • column1(le)2 - this will produce "where column1 <= 2"
    • column1(ge)2 - this will produce "where column1 >= 2"
    • column1(like)2 - this will produce "where column1 like '%2%' "

    You can combine multiple conditions with comma separated conditions. All are added up with AND, ex:

    column1(e1)2,column2(gt)3 will produce "where column1 = 2 AND column2 > 3"


    Follow me on twitter: https://twitter.com/corejoomla
    If you use our extensions, please post a rating and a review at the Joomla! Extensions Directory.
    CjFitCjForum | Polls | Answers | Quizzes | Quotes | Surveys | GPS Tools | CjBlog


  • Re: Special Field - SQL

    by » 3 weeks ago


    Thank you for your quick reply it is so interesting.

    Can the condition be based on one of the survey field like if i have the employee number at the start of the survey form.

    Can the condition include the survery field employee number , so i have like where sapno=employee number

    Thank you , it will be so awesome if this is possible


  • Re: Special Field - SQL

    by » 3 weeks ago


    You can fetch a field from any one table but joining with another table is not possible at this time.

    Follow me on twitter: https://twitter.com/corejoomla
    If you use our extensions, please post a rating and a review at the Joomla! Extensions Directory.
    CjFitCjForum | Polls | Answers | Quizzes | Quotes | Surveys | GPS Tools | CjBlog


  • Re: Special Field - SQL

    by » 2 weeks ago


    What i mean is that can the sql query be base on the user input in the survey form itself ?


  • Re: Special Field - SQL

    by » 2 weeks ago


    I would suggest conditional rules which do exactly the same thing.

    Querying another table based on the current user id is not possible as the question does not have any such facility to read the user id as input.


    Follow me on twitter: https://twitter.com/corejoomla
    If you use our extensions, please post a rating and a review at the Joomla! Extensions Directory.
    CjFitCjForum | Polls | Answers | Quizzes | Quotes | Surveys | GPS Tools | CjBlog


You do not have permissions to reply to this topic.

Powered by CjForum

Site Search

Trending Topics

Link to Post in Email now working
  • 1 reply
What version you are using?

Social User Points
  • 1 reply
Hi I did a search and didn't come up with anything but Jomsocial...

Unregistered Users
  • 1 reply
Hi. My Answer forum is completely guest user (unregistered) driven....

best answer
  • 3 replies
Hi I would like to make the best answer more prominent, such as...

Can't sumbit a question
  • 1 reply
Hi i recently purchased and installed Community answer.When i try to...

Subscribe Newsletter