Custom Relate Field Search Customization

[niteshkunwar]

Hi All,

I have created one custom field SOW (sow_number_c) in opportunity.I have created a relate field SOW Number in project module which is link with opportunity. In the project search form I added SOW number. In search form when I am trying to search in project form it is searching by opportunity name.I want to modify the search and want to search based on custom sow field of opportunity. Can some one tell me where I can modify the search criteria and search based on sow number in place of opportunity name.


Regards
Nitesh

[eggsurplus]

Nitesh,

I've already created an add-on to do what you need and which will save you about 40+ hours of work to get working correctly. You can download the document here https://www.eggsurplus.com/store/ind...jm0b1es4c6bsm5 to see how it works.

Let me know if you have any questions,
Jason

[niteshkunwar]

Hi,

Thanks for the reply but I can not buy any add on. If you provide me documentation then I can do it by my own?Please let me know which file I need to modify.

Regards
Nitesh

[niteshkunwar]

Hi Jason,

Can you give me more details on how I can get this module and how it works.What is the price as my company will be interested in having this feature.

Please send me details at niteshkunwar@gmail.com

Regards
Nitesh

[eggsurplus]

Nitesh,

You've got mail. You can find RelatedData at www.eggsurplus.com.

[edg]

I posted a Developer Tutorial that explains how to create custom popups that modify and/or restrict the search method for relate fields. That may provide you answers you are seeking on how to accomplish this type of search with custom popup defs and a few minor modifications (detailed in the tutorial).

See http://www.sugarcrm.com/forums/showthread.php?t=47887.

[eddiechen]

Nitesh,

You've got mail. You can find RelatedData at www.eggsurplus.com.

the relatedate whether support the custom filed.

for example. in account, I add a field : type,

in contact, I need to search according to the account type,

[niteshkunwar]

Hi,

I have received the module from Jason (www.eggsurplus.com.) but I am not sure if it support custom field search.When I am trying to do the search it is executing following query with error.Let me know if you can help me to resolve the issue.

SELECT project.id ,project_cstm.opportunity_id_c,project_cstm.sow_te st_c,project_cstm.account_id_c,project_cstm.test_s earch_c, project.name , jt0.name opp_c , jt1.name account_c , project.estimated_start_date , project.estimated_end_date , project.status , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, project.priority , opportunities_cstm.sow_nunbertext_c sow_nunbertext_c, project.assigned_user_id FROM project LEFT JOIN project_cstm ON project.id = project_cstm.id_c LEFT JOIN opportunities jt0 ON project_cstm.opportunity_id_c = jt0.id AND jt0.deleted=0 LEFT JOIN accounts jt1 ON project_cstm.account_id_c = jt1.id AND jt1.deleted=0 LEFT JOIN users jt2 ON
jt2.id= project.assigned_user_id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN projects_opportunities jtl3 ON project.id=jtl3.project_id AND jtl3.deleted=0
LEFT JOIN opportunities opportunities ON opportunities.id=jtl3.opportunity_id AND opportunities.deleted=0
AND opportunities.deleted=0 where ((opportunities_cstm.sow_nunbertext_c like '10000012%')) AND project.deleted=0 ORDER BY project.name ASC LIMIT 0,21
05/19/09 19:50:31 [3864][1][INFO] Query Execution Time:0.00104594230652
05/19/09 19:50:31 [3864][1][ERROR] MySQL error 1054: Unknown column 'opportunities_cstm.sow_nunbertext_c' in 'field list'


The query that is getting formed is not correct.Please tell me what I can do.

Regards
Nitesh

[eggsurplus]

It definitely is meant for this. I've been working with you through email to determine the issue. There was a case where you did some order of install/uninstall with wrong versions that may be a contributing factor. The code that should handle this part that is failing for you is in SugarBean.php. Can you unzip the module and copy notupgradesafe/data/SugarBean.php to your data/SugarBean.php directory please and see if that helps?