Welcome, Guest |
You have to register before you can post on our site.
|
Online Users |
There are currently 499 online users. » 1 Member(s) | 498 Guest(s)
|
Latest Threads |
Workflow send email - mor...
Forum: Open Discussions
Last Post: abuislam
Yesterday, 12:21 PM
» Replies: 5
» Views: 9,363
|
Tips and Tricks : When Lo...
Forum: Open Discussions
Last Post: abuislam
04-18-2024, 08:16 AM
» Replies: 3
» Views: 6,326
|
como manejar github en un...
Forum: International
Last Post: ntermacabre
04-10-2024, 03:52 AM
» Replies: 2
» Views: 1,129
|
whatsapp
Forum: User Support
Last Post: Yash
04-03-2024, 09:26 AM
» Replies: 2
» Views: 5,986
|
[RESUELTO] - Tipo de impu...
Forum: Administrator Support
Last Post: joebordes
04-01-2024, 10:39 PM
» Replies: 12
» Views: 7,627
|
PRODUCTS IN ACCOUNTS BY O...
Forum: User Support
Last Post: joebordes
03-31-2024, 11:04 PM
» Replies: 1
» Views: 315
|
Attachment in e-mail not ...
Forum: User Support
Last Post: julikarole
03-13-2024, 05:59 AM
» Replies: 2
» Views: 1,084
|
Mail Manager - Options Se...
Forum: Administrator Support
Last Post: joebordes
03-06-2024, 11:52 PM
» Replies: 16
» Views: 18,118
|
Intermittent issues after...
Forum: User Support
Last Post: joebordes
03-06-2024, 11:44 PM
» Replies: 9
» Views: 1,532
|
Custom Columns in Mail Ma...
Forum: Modules/Extension Support
Last Post: joebordes
03-06-2024, 11:42 PM
» Replies: 1
» Views: 2,064
|
|
|
CUSTOM QUERY IN POPUPS |
Posted by: inspectorflint - 06-19-2023, 03:55 PM - Forum: Administrator Support
- Replies (4)
|
|
Hello:
I am developing a system for a textile company.
We have created a custom module module (Brands), which is relating to Products. The client wants that when a salesman is creating a new salesorder, depending on the brand that is selected in the sales order, the popup only shows the products of this concrete brand. (There are salesman who have several brands assigned ).
It is possible edit the query in the popup? Or do it using business maps?
Thank You!
|
|
|
administrator don´t see all products |
Posted by: inspectorflint - 05-01-2023, 06:59 AM - Forum: Administrator Support
- Replies (5)
|
|
Hello:
In a new corebos instalation, there are several users ( two administrators, one CEO al 13 sales man) . When one of the administrators try to edit a sales order, adding one existing produt, in the popup don´t appears all of this, also a part of then.
This is the popup query:
SELECT vtiger_crmentity.crmid, vtiger_crmentity.smownerid, vtiger_crmentity.description, vtiger_products.*, vtiger_productcf.*
FROM vtiger_products INNER JOIN vtiger_crmentity as vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_products.productid
INNER JOIN vtiger_productcf ON vtiger_products.productid = vtiger_productcf.productid
LEFT JOIN vtiger_vendor ON vtiger_vendor.vendorid = vtiger_products.vendor_id
LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid
LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid
WHERE vtiger_products.productid>0 AND vtiger_crmentity.deleted = 0 and vtiger_products.discontinued<>0
AND vtiger_products.productid
NOT IN (SELECT distinct topdo FROM vtiger_productcomponent INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_productcomponent.productcomponentid WHERE vtiger_products.productid>0 AND vtiger_crmentity.deleted = 0) LIMIT 0,20
The query returns 7 products, but in the products listview appears 13
I think that an adminstrator user can work with all the records, or I am wrong? It is necessary change anything in thepermmisions of roles or profiles?
Also, when I try to upload a pdf file appears this warning: "Imagen inválida: contiene elementos potencialmente maliciosos "
Thanks
|
|
|
loadRelatedListBlock is not defined in new instalation |
Posted by: inspectorflint - 04-21-2023, 07:01 AM - Forum: Administrator Support
- Replies (5)
|
|
Hello:
I Just install the last version of corebos, but the related list dont work.
When I try to open a related module (with contacs, for example), the block don´t open, and in the console appears this message:
Uncaught ReferenceError: loadRelatedListBlock is not defined
<anonymous> javascript:loadRelatedListBlock('module=Contacts&action=ContactsAjax&file=DetailViewAjax&record=8578&ajxaction=LOADRELATEDLIST&header=Documents&relation_id=27&actions=add,select','tbl_Contacts_Documents','Contacts_Documents');:1
loadRelatedListBlock('module=Contacts&action=ContactsAjax&file=DetailViewAjax&record=8578&ajxaction=LOADRELATEDLIST&header=Documents&relation_id=27&actions=add,select','tbl_Contacts_Documents','Contacts_Documents');:1:1
Also, it happens in the rest of the related modules.
I have made the instalation in two different hostings, wiht the same result
Thank you
|
|
|
assing an account to several users |
Posted by: inspectorflint - 03-31-2023, 01:53 PM - Forum: Administrator Support
- Replies (1)
|
|
Is it possible that an account is assigned to several users? I am developing a crm and the client works with brands, and each of its sales representatives manages a specific brand, but clients can buy products from different brands, so the same client should be associated with two or more users.
The client does not want the sellers to see all the accounts, but only the ones that they create or manage. It's possible?
Thank you
|
|
|
|