What?
A quick article on how to use the where clause in a joomla database query.
Why?
In response to a member, I use the old form where I can include the whole SQL statement:
$db->query('SELECT ...
What?
I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room.
The Problem?
When I select specifying the statement "WHERE IN (c.RoomImages)", ...
... multi-line field called "Content" and change the properties on creation to allow 32000 characters.
Keep the email field called "Email"
Return to the Context Handler Function IDE (page where you ente ...
... sometimes works but sometimes yields:
// Me,Myself,I\na,b,c
Works on systems where the above doesn't work:
l_CsvFileRows = List();
l_CsvFileRows.add("Me,Myself,I");
l_CsvFileRows.add("a,b,c");
//
v_CSVFilename ...
... and respond with the responses I programmed it to answer with. Any variations of the questions it did not understand, it would return a response similar to Siri or Ask Google where it includes the keywords ...
...
Now click outside of the option box at the end (in between where it says +1 more)
Type the word "value" and press
Now type the string of words/phrases that you want to store against this custom paramete ...
What?
This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit.
Why?
We're creating a custom module ...
... into the penultimate step of the migration where you watch another but different progress animation which is possibly all your data being mapped, associated, and imported... I personally had to refres ...
... se Order ID"
WHERE poi2."Item Name" IN ( 'delivery' , 'Delivery' )
GROUP BY po2."Purchase Order ID"
) pshipping ON pshipping."PO ID" = po."Purchase Order ID"
LEFT OUTER JOIN( SELECT
po3."Purc ...
... the line items from a package slip taken from Zoho Inventory. I'd prefer if it was included in the list view or a Zoho Creator report.
How?
We would think it similar to a picklist/dropdown where ...
... the function this worked as expected. Now put it on a workflow where the settings were:
When an invoice is "Created or Edited"
Execute the workflow when "When any field is updated"
Filter the triggers ...
... option Account and Lists which should show somewhere along the top right of the home screen.
Under Account and Lists, look for Your devices and content > Manage Devices.
You will get to see the list ...
... it and click on the ellipsis/3 dots
Select the REST API
Enable REST API
Note the REST API function and you can now call it from wherever.
Done
Additional Caveat(s)
This currently does ...
... on the O11 Dynamic Mini and air flow isn't perfectly balanced. I'd opt for the O11 Air Mini (newer one) where fans can be mounted to the front and it supports an ATX Power supply.
I bought 9 Coolmoon ...
... app without building a JS Widget or using Nodejs... Or we can make do with the tools provided. The brief was similar to the Zoho Bookings interface where their Creator app is to present the user with ...
... the Location of your product variant (where "1234567890" is the location ID) to get the recent 10 products updated today:
{
productVariants(
first: 10
reverse: true
query: "updated_at:>'2022-02-14T00:00:00+0000'"
...
... are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function.
How?
If we're not going to use loops, then the next best thing ...
What?
A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this).
Why? ...
... replacements
m_HtmlEntity = Map();
m_HtmlEntity.put("&","&");
m_HtmlEntity.put(" "," ");
//
// loop through each of the above replacing where found
for each v_HtmlKey in m_HtmlEntity.keys()
{
v_StringToDecode ...
What?
A very quick article to remind me how to send a text message using Twilio API in Zoho Deluge.
Why?
The use-case here is that we want local sense dialing where specific numbers are used both ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.