SSS_INVALID_SRCH_FILTER_JOIN when using a filter expression in a federated custom field

Question

SuiteScript v1.

Search by item record type.

customrecord_sp_ecom_item_infoseo is a custom record type with the custrecord_sp_ecom_item_seo field that refers to an item record. It also has a custrecord_sp_ecom_description field, which has a text type.

I want to find items where the word “frozen” appears in custrecord_sp_ecom_description in the associated customrecord_sp_ecom_item_infoseo entry, and I want to use filter expressions.

Here is my expression:

[
    [
      "customrecord_sp_ecom_item_infoseo.custrecord_sp_ecom_description",
      "contains",
      "frozen"
    ]
]

And here is the error I get:

{ "error": { "code": "SSS_INVALID_SRCH_FILTER_JOIN", "message": "nlobjSearchFilter : custrecord_sp_ecom_description." }}

:

[
    [
        "isonline",
        "is",
        true
    ]
]

, . , , - .

?

Answer 1

- , , , ( , ).

, -, Sales Rep , :

[
  [ 'createdfrom.salesrep', 'anyof', salesReps]
]

, salesorder.salesrep, createdfrom.salesrep, createdfrom - , (-) , ( ). . - custrecord_fieldid.custrecord_sp_ecom_description .