Problem Using Search while Adding a New Task

[aubergine1204]

Hi,

When using the Add Task button, the Add popup appears with the option to 'Add In' with a dropdown list of available projects.
A text box appears below this so that the available list can be searched while typing.

When typing a project name, no results are found unless the text exists in a project field such as Description.
The issue is that the projects are set up as a global list and I don't think this is being searched, though it is being read to generate the dropdown list.

I was having the same problem using Global Search, but resolved this by adding a Tag field to each project that uses the same text from the project title (and then allowing Tags to be searched).
Unfortunately this didn't resolve the search problem when adding a new task.

The project list is quite long and it's not easy to scroll to the needed project name to add. Is there any way to resolve this?

I hope I've explained the problem clearly.

Thanks.

[Didou12]

Hi

Did you check the box, in the specific field, "use for search" ?

[aubergine1204]

Hi.

I couldn't see a checkbox but there is a dropdown with the option and this has always been set to 'yes'. Thanks.

[support]

Dropdown allows search by name only.
Entity field type allow search by any fields in entity.

[aubergine1204]

Ok. If I change the Type from List to Entity, there no longer appears to be an option to use the Global List to populate the Project names. Is it still possible to do this?

Thanks.

[Didou12]

why you don't use entity and records instead of global list ?

[aubergine1204]

If I'd known global lists were going to be an issue, I wouldn't have set it up that way and would have used the standard list.

I managed to transfer the project name and bg_color for each to a lists table and they all show up in the Name list dropdown. Now the issue is that all the pre-existing tasks that referenced the global list have lost their project associations.

I'm not sure how the app_entity_22 table references the global list choices and how to map from global list to standard entities list within the database.

Thanks.