Query relation error in Tasks searchs

**delonix** · 2008-02-06, 04:21 PM

My Sugar CE 5.0 is not quering Tasks properly, when I use the field "Relatade to". I have noticed the resulting query uses the following filter:

"where ((tasks.parent_type like 'teste%')) AND tasks.deleted=0"

Since parent_type is recorded with the value "Project" on my TASKS table, I think the relation between tables is not correct in the query. Maybe a JOIN on PROJECT table is missing, on fields parent_type and parent_id.

My system is running with Sugar CE 5.0.0, Windows 2003, PHP 5.2.0 and MySQL 5.

Is this a known issue?

**delonix** · 2008-02-12, 11:00 AM

Nobody knows this weird situation?
I will try to illustrate my doubt:

As you can see, I have the field "Related to" on my basic search form. The task list shows a column called "Related to", too. So, if you take a look at this form, you can infer a relation between the form field and the list, and you can suppose you could to type, in field "Related to", some name listed on column "Related to". But that is not true. In the screen example above, a search for the string "EEE" returns none results. For a valid result, the user need to search for "Accounts", since this is the parent_type of the respective "Related to" listed.

I want to know two things: I am missing or doing something wrong? (my poor english not included, please)
Is there a simple way to fix this search behaviour? (I can do the needed SQL join for a perfect search, but I don´t know how to replace the original code).