Dan,
What happens when you use the syntax with WHERE clause as follows:
-- Example 01
SELECT ID,Cust_State,Unit_Type,InquiryDate +
FROM Inquiry +
WHERE InquiryDate > (ADDDAY(.#DATE,-15))
RETURN
-- Example 02
SET VAR vDate DATE = (ADDDAY(.#DATE,-15))
SELECT ID,Cust_State,Unit_Type,InquiryDate +
FROM Inquiry +
WHERE InquiryDate > .vDate
CLEAR VARIABLE vDate
RETURN
Very Best R:egards,
Razzak
At 06:13 PM 2/26/2018, Dan Goldberg wrote:
I want to get data from the last 14 days to current.
I have a view with the following syntax:
SELECT T1.ID,T1.cust_state,T1.Unit_Type,T1.InquiryDate
FROM Inquiry T1
WHERE T1.InquiryDate > (.#date – 15)
It is very slow and takes a long time to process
But if I do:
SELECT T1.ID,T1.cust_state,T1.Unit_Type,T1.InquiryDate
FROM Inquiry T1
WHERE T1.InquiryDate > 2/10/2018
It opens right away.
I know that it is processing row by row when you
have the date like (.#date – 15)
but
is there a way to force it to process like the static. I cannot use variables
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
