Get Value of Target Field in sys_email table

[thisisauniqueus]

Hi

i am trying to get the value of Target field in sys_email tabe in Business Rule (after insert) but every time i access the DisplayValue its gives me empty. Any idea how can i access the value?

or how can i check if target is not empty access the related record in sys_data_source table?

Regards.

[surendarm]

Hi John,

Can you try creating a new business rule in sys_email table for testing purpose, with the below specifications?

Specifications:

- When to Run : After - Both on Insert and Update

- Condition: Target field is not Empty

Check if you able to get the 'Target Field' value based on the above test business rule.

The reason behind the conditions: Sometimes it takes some few millisecs to fill the 'Target field' value in the sys_email table, when a new record is created.

[thisisauniqueus]

Thanks Surendar i will test, how to specify not empty in filter condition for example

like ?

[thisisauniqueus]

sry is not

[Chuck Tomasi]

You should see "is not empty" as a condition in the middle drop down.

Example:

[surendarm]

Thanks Chuck Tomasi, but just now i found we cant specify such kinda condition for this 'Target' field.

Hi John,

My Badd !!

Can you try checking the 'Advanced' check box in the business rule and specify the condition (Target field is not empty) in a scripted way, in the 'Condition' script box under the Advanced tab?