Assuming return is required, the following 182 results were found.
-
clients set their due dates differently. How? The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are. void fn_ReturnCurrentPaymentTerms() { v_BooksOrgID = "12345678901"; r_PaymentTerms =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
v_Grammar = if(v_CountDuplicates == 1,"","s"); info v_CountDuplicates + " record" + v_Grammar + " are duplicates!"; // // return a distinct list l_Customers2.removeAll(l_Customers1); // // loop through and output to user for each v_DistinctCustomer in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
// get the ID of this record var v_ThisRecordID = $Page.record_id; // get the full name of this contact (not sure why this returns both first and last) var v_ContactName = ZDK.Page.getField('Last_Name').getValue(); // get the email of this contact var...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
HH:mm:ssXXX") message :"Please see the attached file" Attachments :file:f_AllProducts ] // return v_TotalProducts + " product(s) in " + v_TotalCategories + " categories across " + v_Page + " page(s)."; Additional: Total product count may differ from the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
build up related list rows l_RelatedListData = List(); for each m_DataRow in l_DataRows { // double-check in case books has returned 1st page rather than filtered rows if(m_DataRow.get("SO ID") == v_SalesOrderID) { m_Details = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
to a new variable name, it will fail. In other words: m_NewTag = m_Tag.remove("id"); // yields null m_Tag.remove("id"); // returns m_Tag map without the ID key-value pair The use-case This is a snippet that gets the tags of a contact and copies it over...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Action."); } info v_Debug + l_DebugNotes.toString(". "); } if(l_UniqueProducts.size() == 0) { break; } } return "Deleted " + v_CountDeleted + " of " + v_CountTotal; }
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Users 12. Go to Extensions > Module Manager 13. Tick next to CB Login, CB Workflows, CB Online and click Enable 14. Return to Components > Community Builder > Configuration 15. Click on the 'Registration' tab 16. Change Allow User Registration to Yes,...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
-- If you select the part of each expression from the SELECT and run these -- to see what results are returned, it is reading only and not making any -- changes. It will show you what data the query is planning to migrate. -- EXAMPLE: -- SET...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
site. The good news is that it's only the core files and component files. Here are some tips when restoring the site to return it to as it was. The error refers to a function used by the core framework. Comment it out and you get an error referring to...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
4. Declare a PHP function to send requests using cURL A standard function that is skipping the SSL checks and returns a PHP array function send_request($url, $header, $data, $method="GET") { $ch = curl_init(); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
certificate is working change the protocol in the address bar from http to https. https://www.example.com/store and press return. If it has been installed correctly the store should reload and a padlock will appear in the status bar of your browser...
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
this: But we didn't want to do this. How? As a proof of concept, I created one lookup task that executes a SQL query which returns all the joined tables and displays the decode name. Let's pretend the info we want is rather simple: SELECT [sequenceID],...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
displays on my chart because of values that are not matched (not assigned to a current individual) in the joining tables: Return to the Design interface (F8) Right-click on your dataset (in my case: DataSet1) Select 'Dataset Properties' Add a condition...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
which kinda defeats the purpose of having anything there. I want my end-users to have faith in my report. The report just returning blank can also mean "I don't know". I want the report to either return the correct value or say "No data found". My...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
table Inserts a row into an audit table I need the report to run the stored procedure, then based on the errorlevel, return a message. How? We use a database account with read-only privileges to list all the details. On the last report, the one to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
us as SSRS performance is always rubbish anyway. Here's a breakdown of the MDX expressions and how I tweaked each one to return the final result: -- to get just the time value =( CDate(Last(Fields!REPORTENDTIME.Value, "Dataset2")) -...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
is specified (type=2) then datasources and folders will also show. The Side-by-Side Table As you know, most datasets will return the rows as... rows. My pic above shows my 4 reports results side by side. To do this, I had to insert a Matrix rather than...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
( p_STUDENT_ADNAME IN varchar2, l_CURSOR OUT sys_refcursor ) IS BEGIN -- going to declare variables that are to be returned in SSRS but not -- mentioned in the above OUT variables: DECLARE p_STUDENT_REF number(8); p_STUDENT_DETAILS varchar2(255); --...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB