Method:Classic General Q&A

Re: Grid filter not working on SQL overridden field

russg00 — Thu, 19 Oct 2017 12:40:05 GMT

Still have not found a solution to this, anyone have any suggestions?

Re: Grid filter not working on SQL overridden field

russg00 — Wed, 27 Sep 2017 12:51:48 GMT

Hey Sammy,

Thanks for the reply.

The query is actually working just fine, it was in place before I started working on Method. It returns an integer which is the difference of days between our SoldDate and the current date.

The real issue is that we cannot filter on the field in the grid. I can see that there are rows in the grid with a value of 2, but if I filter for 2, the grid returns 0 results.

Let me know what you think.

Re: Grid filter not working on SQL overridden field

Method_Sammy — Tue, 26 Sep 2017 21:41:44 GMT

Hey,

Have you tried altering the query to check for the current UTC date ( GETUTCDATE() instead of GETDATE() )?

What kind of values are you expecting for this query? Is there typically meant to be more than a days variance between "SoldDate" and todays date? Let me know what you are trying to accomplish here and we can come up with a solution

best,

Grid filter not working on SQL overridden field

russg00 — Tue, 26 Sep 2017 14:32:39 GMT

Hi,

I recently took over modifying our CRM and have run into an issue when trying to do a grid filter on a field that has been overridden with SQL.

SELECT DATEDIFF(DAY, viewPartsRequest.SoldDate, GETDATE())

This seems to return a simple integer like value, but when filtering on any value other than 0 or 1 (which does not return accurate results), the grid returns 0 records.

Any recommendations?

Thank you!