Custom View

[ethoemmes]

Hi

I am trying to create a view to select only email messages from a particular domain.

I.e. Select all notes received from *@aaa.com.

I have the following formula which is not working.

SELECT @Select(from="*@accenture.com>" )

Could someone help with the correct syntax?

TIA

 

[pmonett]

The star character as placeholder is not available in formula language.
Your formula is in effect trying to select every doc where the From field is equal to "*@accenture.com>" - of which, of course, there are none.

What you need to do is to break down the data yourself. Something like this should work :

wkDomain:=@uppercase(@right(from;"@"));
SELECT wkDomain="ACCENTURE.COM>"

Pascal.