I have the following query that I use in a FMS to populate a column named location (names of cities).
It works well until the city '015' is selected, then nothing is populated in the columns. I want to force '010' to be populated when '015' is selected in the header. For all other values, the column populates well.
What could be the problem?
SELECT (CASE T0."U_Location" WHEN '015' THEN '010' ELSE T0."U_Location" END) AS "Location"FROM OINV T0 WHERE T0."U_Location" = $[OINV."U_Location"]