I have a record type that's based on a data type which has a nested CDT as o

John Stretton over 8 years ago

I have a record type that's based on a data type which has a nested CDT as one of its fields, and I'd like to allow users to search this record list based on a field of the nested CDT. For example, let's say that my entity-backed record type is based on a CDT called Car, and one of the fields of the Car CDT is "owner", which is of the type Person. The CDT Person has a text field called "name".

How can I configure the list view item for the Car record type so that the user is able to use the search box to search based on the field rf!owner.name? Is this even possible?

Discussion posts and replies are publicly visible

Parents

0 John Stretton over 8 years ago

I think I've found the issue. The title parameter of my listViewItem currently reads as follows:

title: "#" & rf!ID & " " & char(10148) & " " & rf!incidentType & if(isnull(rf!Project),""," " & char(10148) & " ") & rf!Project.projectName & if(isnull(trim(rf!incidentTitle)),"",": ") & rf!incidentTitle

Any fields that are referenced AFTER if(isnull(rf!Project)...) are not searchable. If I write left(rf!Project.projectName,0) BEFORE the isnull() call, then Project.projectName becomes searchable. How strange.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 John Stretton over 8 years ago

I think I've found the issue. The title parameter of my listViewItem currently reads as follows:

title: "#" & rf!ID & " " & char(10148) & " " & rf!incidentType & if(isnull(rf!Project),""," " & char(10148) & " ") & rf!Project.projectName & if(isnull(trim(rf!incidentTitle)),"",": ") & rf!incidentTitle

Any fields that are referenced AFTER if(isnull(rf!Project)...) are not searchable. If I write left(rf!Project.projectName,0) BEFORE the isnull() call, then Project.projectName becomes searchable. How strange.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data