Can I use extended operators with a conditions field?

[jordanwalsh]

I've implemented a conditions field on one of my tables, and I'm trying to evaluate another table that meets the criteria set up in the conditions field:

  gs.info("Querying " + scenario.reference_table + " for " + current.sys_id);

  gs.info("Quering using criteria: " + scenario.criteria);

  var entity = new GlideRecord(scenario.reference_table);

  entity.addQuery("sys_id",current.sys_id);

  entity.addEncodedQuery(scenario.criteria);

  entity.query();

This is currently returning a criteria that looks like:

Quering using criteria: priority=1^EQ

and this is working as expected.   however when I add the extended_operators attribute to my conditions field, then the criteria evaluation returns an error.

extended_operators=VALCHANGES;CHANGESFROM;CHANGESTO

I then update the criteria to use a 'CHANGESTO' and the following log is generated:

Quering using criteria: priorityCHANGESTO1^EQ

The following error is generated on the UI:

Syntax Error or Access Rule Violation detected by database (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHANGESTO 1' at line 1)

Based on this it would seem that the conditions field doesn't support this extended_operator, but I would like to have this confirmed.

Thanks

Jordan

[Satpal Singh1]

URGENT! Help!

I am facing same issue, I have scoped application and we are using Conditional field type and added attribute to do CHANGES. But, it's generating same issue.

Did someone know how to solve it? 

Thanks in advance!!

Regards,

Satpal Singh