FAQ
11min
how do i find out the translation of an interpreted temporal value? sometimes, it can be difficult to understand how interpreted temporal values behave therefore, we've prepared a simple tutorial to help you figure it out 1\) go to https //onlinephp io/ you will see something like this 2\) replace all the text with the following , replacing \<enter temporal value here> with whatever you need to try out be sure to keep the double quotes " ! php \<?php $dt = new datetime("\<enter temporal value here>"); echo "year " $dt >format('y') "\n"; echo "month " $dt >format('m') "\n"; echo "day " $dt >format('d') "\n"; echo "hour " $dt >format('h') "\n"; echo "minute " $dt >format('i') "\n"; echo "second " $dt >format('s') "\n"; here's an example 3\) press "execute code" and you will see the result of your interpreted temporal value appear bellow i'm trying to type a query, but any character i type immediately gets deleted this is usually caused by a trailing space at the end of the query press the right arrow \[→] repeatedly to get to the end of the query, and remove any trailing spaces if this doesn't help, delete the entire query and type it from scratch my query is taking awfully long to execute this is a technical problem that can usually be solved by setting up appropriate database indexes please contact your sugarcrm partner or representative and describe the issue to them, including the exact query you used they will know what to do how does quickquery interact with regular sugar filters? when you use both, the conditions are connected with and and for example, the following searches for accounts whose name starts with "abc", and and whose billing country billing country is "usa" "usa" how do i find the id of a record? the id of a record, which can then be used when useful examples docid 4z206vs3o6oyffkvfwr1l , can always be found in the address bar when you are viewing the record however, it depends on whether the module is "new style" or "old style" old style (a k a backward compatibility, bwc) modules for reference, this is what an "old style" module looks like the address in the address bar always starts with #bwc in modules like these, when you open up a specific record, the id will be located right after record= , as seen in the picture below new style (a k a sidecar) modules for reference, this is what a "new style" module looks like the address bar does not start with #bwc , but rather #\<module name> , e g #accounts in modules like these, when you open up a specific record, the id will be located right after the #\<module name> part, as seen in the picture below i got an error when using quickquery, and now i can't open up the module at all! while exceedingly unlikely, a situation may arise where some specific query causes an error to occur inside sugar when that happens, sugar displays an error page similar to the following since, like regular filters, the last query is saved and executed whenever a module is open, this will cause the module to be unopenable, as opening the module will immediatelly trigger the query and cause the error if such a situation occures, use the clear and refresh button located in your profile actions menu this will cause quickquery to temporarily forget the last query entered in all modules be aware that this only lasts until you refresh the page , unless you overwrite the old query with a new query therefore, after using this button, apply any kind of valid query (in quickquery) to the module the error occurred in this will overwrite the query which was causing the error after that, refresh the page , which will restore the last queries in other modules