Assuming than is required, the following 169 results were found.
-
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(); m_Details.put("po_date",m_DataRow.get("PO...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
FROM "Accounts" ORDER BY "Modified Time" DESC /**** Pseudo: Select Modified Time of Record If Modified Time is greater than yesterday's date (today) Use URL of the image representing OK Else If Modified Time is greater than 5 days ago Use URL of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
What I'm trying to have is a generic function that will work on any CRM and possibly be quick to adapt to a module other than products. This function will also try to delete the duplicate but if the duplicate is the one used in a transactional module...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
just not matching... either way, your client will likely only accept the previous solution. I wanted to use a regex rather than treat the number as a string and truncate it that way. Given the possible options of numbers given, it has to work with every...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
headers:m_Header connection:"ab_analytics" ]; info r_DelRow; Error(s) Encountered {"status":"failure","summary":"LESS_THAN_MIN_OCCURANCE","data":{"errorCode":8504,"errorMessage":"The parameter CONFIG is not proper(Has not been sent or is less than...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
invoices - along with their Contacts and Items (accounts/contact & products respectively). Why? This took me so much longer than I thought it would. It was meant to be based on the pull from invoices article I wrote earlier but with quotes from Xero,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Profile - JoelLipman.Com Plugin" JOELLIPMAN_BOOLEANYES="Yes" JOELLIPMAN_BOOLEANNO="No" JOELLIPMAN_ALLERGYTIMEOPTION0="Less than 6 months" JOELLIPMAN_ALLERGYTIMEOPTION1="Less than a year" JOELLIPMAN_ALLERGYTIMEOPTION2="1 year"...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
\modules\mod_rokajaxsearch\mod_rokajaxsearch.xml Stage 1: Add Relevance [Mandatory Stage] We want to order by more than just popularity and/or date, but also by our own relevance heuristics. The following change would give radically high relevance to...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
from my article on how to download videos from a session on TrainerCentralSite.com. How? OpenAI's ChatGPT doesn't like more than a 500Mb file attachment; and no more than 10 files at a time. I have a 1.5 Gb video which has a duration of 5.5 hours. I...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
of the variables and responses for debugging purposes. I can also unset multiple branches of variables with fewer commands than unsetting specific variables. Let's specify the output page to be in JSON format: // set content type of this page...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
has worked in nearly all cases, is to use the "conditional split" task and test one of the columns for a length of greater than 1: Almost! A problem not covered by many sites was happening to me when I had blank rows in a flat file, where it appeared to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
image. We would like something similar for SSRS. Solution #2: Alternative image if file does not exist More of a workaround than a solution but by asking some colleagues who developed the previous version (using 3rd-party components other than Microsoft...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
).ToString & " second(s)" // yields // Time Taken: 00:00:02.15443570 second(s) -- What if the report actually took more than a minute... more than an hour ="Time Taken: " & ( (Mid( CStr( ( CDate(Last(Fields!REPORTENDTIME.Value, "Dataset2")) -...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
VALUE IF TIME WAS IN GIVEN VALUE IF @DateMatch=1 BEGIN -- SET YEAR RANGE (1912 - 1994: for Birthdate specifically: Older than 18 but younger than 100) SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ago from today SET @MaxYear =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
VALUE IF TIME WAS IN GIVEN VALUE IF @DateMatch=1 BEGIN -- SET YEAR RANGE (1912 - 1994: for Birthdate specifically: Older than 18 but younger than 100) SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ago from today SET @MaxYear =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
but after much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...with ODBC to... MySQL v5+...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
look at ways of reducing the load on the server and the solution was to separate both tables (activities and users) rather than trying to join these, and to let PHP do a bit more of the work: User Query $t_value = $the_team_id_that_i_want_to_look_at;...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
I don't usually write an article on another site but I came across it and rather than just add it to my weblinks section, I thought I'd give it a little more credit. "Motive is a web design and development agency based in Wellington, New Zealand...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *