Assuming select is required, the following 239 results were found.
-
widget: Open a MacOS Terminal sudo npm install -g zoho-extension-toolkit (this also updates existing install) sudo zet init select Zoho CRM enter a unique Project Name cd to the new project name To give permissions to write sudo chmod -R 777 . open the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
and clicks on "View Report" Report passes parameter to dataset which gets formatted by the database Report retrieves (select) formatted parameter as a field value to use Report loads with changes based on returned value. The Gist Add database level...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
#1 listed here and then just built on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases and you have their full schemas. Use a comparison...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
in turn we export to Excel: Note that as this is from within a web application, there are no extra options or dialogs to select. The export had to work from this point on. I can't take any credit for the below as it was copied from...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
button Re-Tick the filter to add it back to the report Move this added field to the Report Filter section (click on it and select "Move to Report Filter") Advanced Sorting So the above works which is great but what if you have a list of month names?...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
error when having to use an ORDER BY clause in a subquery within an Oracle 11g environment. How? Consider the following: SELECT ps.person_id, ps.person_name, ( select pa.person_reference as personid, pa.person_text as txt from Person_Academia pa where...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
Create a project In the terminal, type zet init You will be given a list of Zoho services, use the arrow up/down keys to select “Zoho Creator” and press the return/enter key. Give the project a name: eg. “joels_awesome_app” (without the double-quotes...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
in Zoho CRM that I hadn't used much but definitely worth an article. The ability to block field picklist options from being selected based on the profile of a user. Why? There were several alternatives we considered beforehand which still didn't fit the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
a sales person. It adds to the effect on loading the page that a widget has clearly defined values based on the filters I select on a dashboard. First you will need a table or query that has a bunch of columns and rows with one of the columns containing...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
= v_PageFactor * v_PerPage; // // get unique product names (v2 up to 200, v6 up to 10k, v7 up to 100k) m_Params = {"select_query":"select Product_Name, COUNT(id) 'Frequency' from Products where Product_Name is not null group by Product_Name limit " +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
report you can't change. Enter Zoho Analytics... well almost, Analytics will sync with Zoho People but I wasn't able to select the performance modules (Client Review and Placement Tech Survey having been disabled)... How? So this might seem obvious but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
introtext // + 40 pts if in fulltext $sql_keyword = strtolower(trim($db->Quote($db->escape($text, true), false))); $query->select(' (1000*((LENGTH(TRIM(a.title)) - LENGTH(REPLACE(LOWER(TRIM(a.title)), '.$sql_keyword.',\'\'))) /...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Viewing Articles in the Administrator panel: INSERT INTO `#_workflow_associations` (`item_id`, `stage_id`, `extension`) SELECT `id`, 1, "com_content.article" FROM `#_content`; UPDATE `#_content` SET `checked_out`=NULL, `checked_out_time`=NULL; Viewing...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
to the computer, ie via the Settings > General > Software > Update option) Right-click on your iTunes shortcut and select "Run as Administrator". Plug both phones into the computer. In iTunes, right-click on the old phone and select "Transfer...
- Type: Article
- Author: Joel Lipman
- Category: iOS
- Language: *
-
to (note that some of the images have been censored due to this project containing sensitive data): Script Component Task: Select Type Script Component Task: Transformation: Data Viewers Script Transformation Editor: Input Columns Additional "Features"...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
are assigned to (Labels - series fields) Months the incident(s) were closed (X-axis - category fields) My SQL Query is: SELECT _SMDBA_.Incident.[Incident #] ,_SMDBA_.Incident.[Group Name] ,_SMDBA_.Incident.[Close Date & Time] ,_SMDBA_.Incident.[Assigned...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Problem The last report will execute the stored procedure without any problems. I added a second dataset on this report to select the updated data that this stored procedure commits but unfortunately SSRS process both the Stored Procedure and the SELECT...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
another_file_in_this_folder.doc How? For Windows XP: Open an instance of Windows Explorer and click on "Tools" Select "Folder Options..." Select the "(NONE) Folder" option Click on "Advanced" Click on "New..." Enter the New Action as per the following:...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
the same principle to a specific user account (the Guest account): Open the registry editor with administrative privileges Select HKEY_USERS Go to the menu File and select Load Hive Navigate to that user's profile folder, usually C:\users\username in...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *