I have the expression below in my Starting View. The count expression is currently false (there are no records available) and so I'm expecting view "system_message_no_routes" but I keep getting view: "route_for_the_day"
IF(
COUNT(app_v_routesfortheday[route_schd_id])>0,
route_for_the_day,
system_message_no_routes
)
- I've run the count expression separately to see how it returns and it returns "N" or False in the test view
- I've used isbank instead of count
- I've Used a SELECT statement with COUNT
- I've placed quotes around the view names
- I've moved the expression to USERSETTINGS(route_display) and then called the USERSETTINGS(route_display) from the Starting View
- Note: app_v_routesfortheday does have a security filter and considering there may be a timing issue for when the system evalulates expression and so I relocated the security filter to the Starting View expression but no luck
Can someone assist with the correct expression? A million thank you's
LinkedIn
Twitter
