Almost everything you wanted to know about Search Select Advanced Fields (A round up about lookups)

There's one question left for me. After you choose a - f.e. - Company from an advanced search field (like in a new communication) there's always their full phone number under the advanced search field.

How can i change the shown data when i select a company? Like, i additionally want it to show e-mail etc.! Where can i change that?

Thanks for any hints and informations!

Hi Jeff,

We have a problem when updating SSA field in ASP page. Like:

txCourseRun = eWare.CreateRecord("CourseRun");

...

txCourseRun.corrun_runcode = "ABC";

...

txCourseRun.SaveChanges();

corrun_runcode is the SSA field.

The "ABC" exists in the source table.

It seems that the system stopped on the line code and then throw error page 500.

I've searched from the article collection about this, but I couldn't find it.

Please help.

Thank you.

Hi Jeff,

I found the solution.

It was a mistake on my side.

The SSA field only accept a field id (numeric).

Thank you.

I would like to get the selected value from a screen field defined as Advanced Search when i run a On change script so as to perform an other action but i get no value.

At which point can I intercept the sql of the view that is executed by the search function of a custom ssa field ? I changed the dotnet code in the EntitySearchPage by filling: ResultsGrid.SelectSQL="...". That works when I call this method from the system menu "find". But this is not the code that is executed when I use the popup search window from the SSA field. Is this possible?

Thanks in advance!

Has this article moved?  The link seems to be broken:

community.sagecrm.com/.../dynamically-change-searchsql-for-an-ssa-field-client-side.aspx