In report show only entity that link to other module - Printable Version +- CoreBOSBB (https://discussions.corebos.org) +-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17) +--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8) +--- Thread: In report show only entity that link to other module (/showthread.php?tid=1598) |
In report show only entity that link to other module - addady2 - 09-24-2019 Hi, I added a link field from "Purchase Order" order to Opportunity. Now I want to create from "Inventory Details" module item report of all the items in "Purchase Order" that link to specific Opportunity. How to identify the Opportunity. It not allow to put text, the popup error is: "Invalid my-opportunity-field-name (Integer Criteria)0" I guess I should enter the number on the Opportunity in the system. In this example 8547 Code: index.php?module=Potentials&parenttab=ptab&action=DetailView&record=8547 But when I enter any Opportunity number it fail to bring any result always empty report. Is it a bug or I'm doing something wrong? RE: In report show only entity that link to other module - joebordes - 09-25-2019 find the field you have created in the vtiger_field table and change the column typeofdata from I~O to V~O and let me know if it works RE: In report show only entity that link to other module - addady2 - 09-30-2019 It solve the problem ! Thank you RE: In report show only entity that link to other module - joebordes - 09-30-2019 :-) |