Welcome, Guest
You have to register before you can post on our site.

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 539,599
» Latest member: 23winreviews
» Forum threads: 1,745
» Forum posts: 9,084

Full Statistics

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

Print this item

  [Warning]: cron Task(s) exceed time threshold
Posted by: rslemer - 02-01-2019, 11:03 AM - Forum: Administrator Support - Replies (17)

After I moved my installation to another server, system send this message many times, and when I go to Scheduler Manager in admin panel, Workflow shows Running, but task is marked as inactive

How I can solve that?

Print this item

  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.generalledgers14) AS SIGNED) > 8099 AND 
                             
CAST(SUBSTRING(vtiger_products.generalledgers14) AS SIGNED) < 8200
                         
) OR 
                         
CAST(SUBSTRING(vtiger_products.generalledgers14) AS SIGNED) = 8997
                 

                 AND 
CAST(SUBSTRING(vtiger_products.generalledgers14) AS SIGNED) != 8198 
                 
AND crment_so.deleted 
                 
AND crment_id.deleted 
                 
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?

Print this item

  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 &gt'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.

Print this item

  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

=)

Print this item

  Doubt - Days beteween two dates
Posted by: rslemer - 01-24-2019, 01:37 PM - Forum: Administrator Support - Replies (1)

I wish calculate a nr of days between a specific date and today

How I can use a workflow to do that?

Print this item

  [ solved ] open list item in new tab
Posted by: rslemer - 01-23-2019, 03:57 PM - Forum: Administrator Support - Replies (2)

I set global variable for open item in new tab, works in almost list

Only at To Do system not open a task in new tab



Attached Files Thumbnail(s)
   
Print this item

  [ solved ] Fresh install - Dashboard without a add button
Posted by: rslemer - 01-22-2019, 11:12 AM - Forum: Administrator Support - Replies (3)

I do a new ( fresh ) install, system not shows a (+) add, button on dashboard, even for admin user

Print this item

  [ 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?

Print this item

  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 ...

Print this item