The issue i face up is once i run the nodes, not output return, meanwhile in my prod db, it have values. why is this so?
@Amnan_Sani The reason your SQL ends up with no rows is that the
date(u.premium_start_at) = CURRENT_DATE
condition is very strict and excludes everything. Therefore, n8n displays No output data.
1 Like
Does it return your product data now?
it doesnt return the prod data. just return no output. i can only fetch data from last 3 days backward. then everything return no output only even the data exist in my db. what my needs for that node is, i want to fetch user data that subscribe to premium from yesterday record.
@Amnan_Sani Change your SQL query to date(u.premium_start_at) = DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY) to fetch yesterday’s premium subscribers.
1 Like
thank you so much!!
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.