Welcome, Guest |
You have to register before you can post on our site.
|
Online Users |
There are currently 3 online users. » 0 Member(s) | 1 Guest(s) Bing, Google
|
Latest Threads |
Finetuning the way you se...
Forum: coreBOS Development
Last Post: alexandy40d
12-06-2024, 07:38 AM
» Replies: 4
» Views: 8,140
|
MariaDB Version
Forum: Administrator Support
Last Post: joebordes
11-01-2024, 11:49 AM
» Replies: 1
» Views: 629
|
Product Catalog / parts c...
Forum: Modules/Extension Support
Last Post: joebordes
09-15-2024, 09:40 AM
» Replies: 1
» Views: 1,107
|
Challenges and Best Pract...
Forum: coreBOS Development
Last Post: wishforbes
08-30-2024, 04:21 PM
» Replies: 0
» Views: 720
|
PRODUCTS IN ACCOUNTS BY O...
Forum: User Support
Last Post: jonathanmoore858
08-03-2024, 04:14 PM
» Replies: 4
» Views: 2,766
|
Zapier | Integration
Forum: Modules/Extension Support
Last Post: bernardgbailey
07-29-2024, 11:45 PM
» Replies: 7
» Views: 9,848
|
Versión PHP recomendada
Forum: International
Last Post: joebordes
07-04-2024, 05:42 PM
» Replies: 7
» Views: 3,329
|
Could Someone Give me Adv...
Forum: Open Discussions
Last Post: joebordes
06-27-2024, 08:32 AM
» Replies: 1
» Views: 1,705
|
RESTRICTED FILE
Forum: Administrator Support
Last Post: inspectorflint
06-22-2024, 08:08 AM
» Replies: 7
» Views: 5,659
|
GENDOC imágenes
Forum: Open Discussions
Last Post: joebordes
06-02-2024, 05:11 PM
» Replies: 4
» Views: 2,038
|
|
|
[ solved] Fisrt login issue |
Posted by: rslemer - 02-05-2019, 01:29 PM - Forum: Administrator Support
- Replies (2)
|
|
When I create a new user, normaly I choose a simple password, like as "firstnameofuser@12"
But when user try login system shows, the message " user or password is wrong "
For working, I need login with admin user again, and change your password
After this user can login normaly
|
|
|
SQL report, can't filter |
Posted by: Guido1982 - 02-01-2019, 09:05 AM - Forum: Administrator Support
- Replies (5)
|
|
I have this query that I used to produce an SQL report:
PHP Code: SELECT vtiger_salesorder.salesorder_no AS 'SalesOrder_SalesOrder_No', vtiger_salesorder.pl_net_total AS 'SalesOrder_Net_Total_(aGD)', vtiger_salesorder.subject AS 'SalesOrder_Subject', CONCAT(vtiger_users.first_name, ' ', vtiger_users.last_name) AS 'Users_User_Name', DATE_FORMAT(crment_so.createdtime, '%d-%m-%Y') AS 'SalesOrder_Created_Time', vtiger_products.productname AS 'Products_Product_Name', vtiger_products.generalledgers AS 'Products_General_Ledger_Accounts', vtiger_inventorydetails.quantity AS 'InventoryDetails_Quantity', vtiger_inventorydetails.extnet AS 'InventoryDetails_ExtNet', vtiger_inventorydetails.cost_gross AS 'InventoryDetails_Cost_Price', vtiger_account.accountname AS 'Accounts_Account_Name', vtiger_inventorydetails.inventorydetailsid AS 'LBL_ACTION' FROM vtiger_inventorydetails INNER JOIN vtiger_salesorder ON vtiger_inventorydetails.related_to = vtiger_salesorder.salesorderid INNER JOIN vtiger_account ON vtiger_salesorder.accountid = vtiger_account.accountid INNER JOIN vtiger_crmentity crment_so ON vtiger_salesorder.salesorderid = crment_so.crmid INNER JOIN vtiger_crmentity crment_id ON vtiger_inventorydetails.inventorydetailsid = crment_id.crmid INNER JOIN vtiger_users ON vtiger_users.id = crment_so.smownerid INNER JOIN vtiger_products ON vtiger_inventorydetails.productid = vtiger_products.productid AND ( ( CAST(SUBSTRING(vtiger_products.generalledgers, 1, 4) AS SIGNED) > 8099 AND CAST(SUBSTRING(vtiger_products.generalledgers, 1, 4) AS SIGNED) < 8200 ) OR CAST(SUBSTRING(vtiger_products.generalledgers, 1, 4) AS SIGNED) = 8997 ) AND CAST(SUBSTRING(vtiger_products.generalledgers, 1, 4) AS SIGNED) != 8198 AND crment_so.deleted = 0 AND crment_id.deleted = 0 AND crment_so.createdtime > '2016-01-01 00:00:00' ORDER BY vtiger_salesorder.salesorder_no ASC
It produces the report all right, but filtering doesn't work. I tried filtering the created time but ended up with either an empty report or an unfiltered one. I created the report both on SalesOrders and on InventoryDetails as the main module. Is this a query too complicated?
|
|
|
Pasting a Query in SQL report HTML encodes characters |
Posted by: Guido1982 - 02-01-2019, 09:00 AM - Forum: Administrator Support
- Replies (2)
|
|
When I create an SQL report and include a condition like:
PHP Code: crment_so.createdtime > '2016-01-01 00:00:00'
It gets saved to the database as
PHP Code: crment_so.createdtime > '2016-01-01 00:00:00'
Is this a bug or do I need to change a setting?
EDIT
Ironically, the character of course get decoded here so you will see a right arrow in both code examples and I don't know how to correct that, but trust me, it gets HTML encoded in the database.
|
|
|
Suggest | Special variable MyGroups |
Posted by: rslemer - 01-30-2019, 02:50 PM - Forum: Administrator Support
- Replies (3)
|
|
I suggest like as special variable current_user, a metatag like as "MyGroups"
Because I wish created a filter, displayed only users with with my groups
The scenario is a supervisor has more than on time/group, and with a filter for see the productivity, one team at a time
=)
|
|
|
[ solved ] Filter not displayed correctly |
Posted by: rslemer - 01-21-2019, 07:22 PM - Forum: Administrator Support
- Replies (2)
|
|
Because my picklist displayed special characters not corretly I changed all itens for non special characters
Now, same filters not dipslayed correctly a value for this
Example "Cartão de Crédito" was changed to "Cartao de Credito" but filter not listed any more
Same if I change the same way in filter condition
How I can solved that?
|
|
|
Special character in field name ( pick list ) |
Posted by: rslemer - 01-21-2019, 07:19 PM - Forum: Administrator Support
- Replies (9)
|
|
Now, name of picklist and itens in picklist, with a special characteres is not displayed correctly
In my config.inc.br set UTF-8
Only picklist and itens in pickist displayed wrong ..
How I can solved that?
But values for default system, is showed correctly, only my new values is showed wrong ...
|
|
|
|