changing a one to one left join to a many to one ?

[jamie]

yeah greater ablity to switch between types would be amazing, luckly this time i could just delete it...

[jamie]

i enabled MySQL slow tracking and then used the SQL command EXPLAIN on the slow query and found that one left join had 12000 records, we didn't need that...

[jamie]

Is this sort of thing even possible?

In the past, someone set up the relationship, and we now have a lot of data relying on it, but our...

[jamie]

never mind i tracked it down with mysql slow functionality...

[jamie]

Does anyone have experience or advice on how to track what causes an api call to go ultra slow?...

[jamie]

shalmaxb i know it can look scary though its really a lot easier then it looks, just follow the instructions and you'll come right, if not drop me a line...

[jamie]

shalmaxb yrui's solution is easy, powerful and probably exactly what you want, but most thanks for sharing what you have done...

[jamie]

yuri that is even more than what i need, thanks Sorry, i should have read the docs first, though my more experienced workmate thought there wasn't...

[jamie]

That's what we have been doing, but now with about 50 templates, I fear the day we want to change our logo or phone number

[jamie]

But no plans for the future? I'd hate to implement something that will be included in the near future

Anywhere I can look for examples on...

[jamie]

Hey man, you're just the best! Thanks for taking the time to explain it to

[jamie]

has anyone figured out a good way to get all the pdfs to use the same header and footer template file?...

[jamie]

might this be something you'll be adding in the future?...

[jamie]

rabii too cool! but how will espo know what folder to look in? sorry i am well new to espo as i am sure you can tell, feel free to talk to me like a total...

[jamie]

Steps to Reproduce:

1. Attempt to create or update any record in EspoCRM with a value that violates a unique constraint (e.g., duplicate number, email,

...

[jamie]

rabii well if i add or edit the system files with the next espo upgrade, they will be removed. it would be much better to have a list of my own translations...

[jamie]

rabii o, sweet, that does help, it's inverted from what I thought.

Though I am looking to do my own translations, for example, to send...

[jamie]

wow some amazing changes, thanks!

[jamie]

Hi,

Just wondering how one would use translations inside the formula scripts? language\translate(LABEL, CATEGORY, SCOPE) doesn't give a whole...

[jamie]

victor ahh yes, i think you have helped me track this down to just the "limited admin" group provided by Eblasoft i shall raise the issue directly...