Welcome, Guest |
You have to register before you can post on our site.
|
Online Users |
There are currently 210 online users. » 2 Member(s) | 208 Guest(s)
|
Latest Threads |
CUSTOM CHECK FIELD
Forum: Modules/Extension Support
Last Post: unitedrefrigerants
09-19-2023, 02:27 PM
» Replies: 3
» Views: 127
|
Gendoc odt with image lin...
Forum: Administrator Support
Last Post: momomonet
09-12-2023, 09:56 AM
» Replies: 8
» Views: 1,099
|
Issue in Emails::createE...
Forum: coreBOS Mail
Last Post: joebordes
09-03-2023, 10:58 PM
» Replies: 10
» Views: 7,476
|
Remitente de correo admin...
Forum: Spanish
Last Post: joebordes
08-26-2023, 11:25 AM
» Replies: 1
» Views: 319
|
error al cargar imagen de...
Forum: Spanish
Last Post: joebordes
08-26-2023, 11:22 AM
» Replies: 1
» Views: 123
|
GenDoc Error al crear arc...
Forum: International
Last Post: joebordes
08-26-2023, 11:22 AM
» Replies: 3
» Views: 290
|
como manejar github en un...
Forum: International
Last Post: joebordes
08-24-2023, 05:50 PM
» Replies: 1
» Views: 138
|
How to change exported od...
Forum: User Support
Last Post: xhilda.shazivari
08-07-2023, 02:09 PM
» Replies: 5
» Views: 940
|
Quote with crmid and quot...
Forum: Administrator Support
Last Post: joebordes
08-05-2023, 06:51 AM
» Replies: 4
» Views: 837
|
Italian email
Forum: Administrator Support
Last Post: joebordes
08-04-2023, 04:58 PM
» Replies: 1
» Views: 259
|
|
|
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
|
|
|
|