You are viewing limited content. For full access, please sign in.

Question

QF custom query limitations

Quick Fields Version 8

Updated November 21, 2014

asked on November 20, 2014 • Show version history

Will the custom query in QF allow me to do a case statement within my select? we are using version 8.0.1. I am looking for a way to determine the day of the week from a date read into the template. I also need to pull other information back from the database and populate the template but, it seems to ignore my case statement and returns all the other data.

0 0

Replies

replied on November 21, 2014

Carrie,

What you are doing should work assuming it is returning only a single row and whatever connection driver allows you to use your case statements in the query. You might also try turning your query into a view and having Quickfields just query the view if the former does not work.

I however would recommend fully to upgrade to Quickfields 9 if you could. In 9 you can actually return day of the week without doing any weird workarounds just by using the date formatting.

1 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked November 20, 2014
Updated November 21, 2014
323 views