Custom Query Prepopulation: SELECT CASE

  • Resolved a608237

    (@a608237)


    7 years, 3 months ago

    I am trying to get a dropdown field to dynamically prepopulate options using different queries depending on the value of another field (fieldname7).

    I was able to get CFF to return simple text values ala:

    SELECT CASE WHEN (<%fieldname7%> = 1) THEN (“YES”) ELSE (“NO”) END as text

    I want to replace the “YES” and the “NO” with a select query instead, like SELECT name FROM employees;, but doing this substitution yields blank. Similar queries not based on fieldnames work directly in mysql.

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    7 years, 3 months ago

    Hello @a608237

    If the query works in mysql, it works with the plugin too, because the plugin simply replaces the special tag <%fieldname7%> with the corresponding field’s value, and runs the query. If you need additional support about features in the Developer version of the plugin, you should contact me from my private website:

    https://cff.dwbooster.com/contact-us

    Best regards.

Viewing 1 replies (of 1 total)

The topic ‘Custom Query Prepopulation: SELECT CASE’ is closed to new replies.