Sage CRM

Welcome to the Sage CRM Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Compound filterWhere possible?

Posted By bradd_1 over 10 years ago

Is it possible to perform compound filtering statements on grid rows? I've been trying without success. I want something like... crm.grids().rows().filterWhere('field_one', "le", new Date).filterWhere("field_two", "gt", 0).highlightRow("pink"); Perhaps I'm just missing some obvious documentation..

0 Sage CRM over 10 years ago

Sorry what are you trying to do?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 bradd_1 over 10 years ago

In the order items grid. I want to color code rows based on situations.

So I want to highlight a row as pink if a datefield is less than today AND an integer field is greater than 0

It's the AND, that I don't see any documentation for.

crm.grids().rows().filterWhere('datefield', 'le', new Date).highlightRow('pink'); -- works fine

but I only want to highlight rows that also meet another criteria.

where('integerfield', 'gt', 0)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage CRM

Compound filterWhere possible?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING