Skip to main content

Big page with lots of queries. I thought this was fixed with 7.31?

Looks like the soql isn’t reflecting my conditions.


model.soql = “SELECT Name,Id FROM Patient_Case__c WHERE (Patient__r.DefaultCenter__r.Name = ‘CompassCare’)”


Conditions:


Does it matter that First_Complete_Interaction_Date__c is a formula field?


Obviously as it’s written it shouldn’t return anything. I’m not loading the model on pageload, I’m running a script to initialize the date conditions based on the current date, so that the StartDate condition looks like this when the query is run:


Tried to resolve by forcing model to build client-side. Seemed to get farther in the process, but now getting this:



And even when processed client side, the model’s soql is still just reflecting the first condition, not all of the conditions.


bump


“Cannot read property tid of undefined” — your session has expired. Refresh the page.


Matt, I think this is a separate issue, for which you have another Community post already, so to keep the waters from getting muddied, let’s keep discussion of your Models’ Conditions being removed isolated to that post.


Matt, is this occurring when you save Models, or when your Models are queried?


Regardless, here’s what would be helpful: open Chrome’s JavaScript Console, and go to the Network tab, and click on XHR. Then, do whatever causes this error to occur. When it happens, you should get an “apexremote” entry in the Network Requests logger. Click on this, and then under Headers > Request Payload, click through the payload to open “data”, and then double-click on what’s next to 0, and then paste this into a text editor, and then email support with that text file. Or, if it says “”, let us know that as well.


Zach,

Since I fixed the issue with the conditions not making it into the soql, I’m not getting the Input too long error. It was happening on query.

Issue was that I had about two dozen aggregate models with “Id in any row of another model” conditions, all pointing to the model where the conditions weren’t being added. Without the date limitation, that model was returning almost 4000 rows. So, two dozen queries each looking through 4000 rows for matching ids was causing ‘input too long’.


Reply