I am filtering data with many fields and date is one of them. I have added date criteria which is filtering data accurately. My problem is this , I am using calculating fields on results page and using this criteria on that as shown below in sql code. But it is not working. Please check the code and send me solution if any
I am receiving DateFrom in calcfields3 and DateTo in Calfield4 on results page and then use them in the code
ISNULL(((SELECT COUNT (Master_Data_Auto_Condition_Validation) FROM _v_Master_Data_Auto_102522
WHERE Master_Data_Auto_Category=Target.[@field:Master_Data_Auto_Category] AND Master_Data_Auto_Condition_Validation>=0 AND Master_Data_Auto_Indice=target.[@field:Master_Data_Auto_Indice] AND Master_Data_Auto_Condition_Description=target.[@field:Master_Data_Auto_Condition_Description] and Master_Data_Auto_Date>=[@calcfield:3] and Master_Data_Auto_Date<=[@calcfield:4] )),0)
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Mushigee2266
I am filtering data with many fields and date is one of them. I have added date criteria which is filtering data accurately. My problem is this , I am using calculating fields on results page and using this criteria on that as shown below in sql code. But it is not working. Please check the code and send me solution if any
I am receiving DateFrom in calcfields3 and DateTo in Calfield4 on results page and then use them in the code
ISNULL(((SELECT COUNT (Master_Data_Auto_Condition_Validation) FROM _v_Master_Data_Auto_102522
WHERE Master_Data_Auto_Category=Target.[@field:Master_Data_Auto_Category] AND Master_Data_Auto_Condition_Validation>=0 AND Master_Data_Auto_Indice=target.[@field:Master_Data_Auto_Indice] AND Master_Data_Auto_Condition_Description=target.[@field:Master_Data_Auto_Condition_Description] and Master_Data_Auto_Date>=[@calcfield:3] and Master_Data_Auto_Date<=[@calcfield:4] )),0)
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.