Root Container Error but no Message

[paulm1]

I figured this one out. My Named query was using a custom property that gets its value from the selected cell on a table component. My property binding was this -

try({Root Container.Table.data}[{Root Container.Table.selectedRow}, 1], 0)

When nothing was selected the 0 was throwing an error when no rows / cells were selected.
I changed it to a generic value and now it works

{Root Container.Table.data}[{Root Container.Table.selectedRow}, 1], 200)

Now I would like to learn how to include a "Fall Back" into Named Queries.
See this post -

Named Query - SELECT COALESCE issue

For a SQL Query Binding I have used the following successfully. SELECT COALESCE(Disch, 0) FROM table WHERE t_stamp BETWEEN startTime and EndTime I cannot get this to work inside a Named Query. What am I doing wrong?