While this is a contrived example, I can see instances where Flex Reports will need to be filtered on computed columns.
Let's say I want to list all students whose Last Name starts with the letter "S". Here's SQL that lists the first name and first letter of last name for all students.
SELECT
Firstname
, LEFT(LastSurname, 1) AS LastnameFirstLetter
FROM edfi.Student
WHERE $filter
How would I create a filter that would allow the user to specify the first letter of the last name to match?
While this is a contrived example, I can see instances where Flex Reports will need to be filtered on computed columns.
Let's say I want to list all students whose Last Name starts with the letter "S". Here's SQL that lists the first name and first letter of last name for all students.
How would I create a filter that would allow the user to specify the first letter of the last name to match?
See http://easol-dev.azurewebsites.net/reports/view/58 and http://easol-dev.azurewebsites.net/reports/view/59 for two approaches that I tried.