Announcement

Collapse
No announcement yet.

Filter and select related record and their data for printing in PDF

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Filter and select related record and their data for printing in PDF

    Hello, I wanted to ask if someone knows whether it would be possible to somehow select (filter based on some conditions) related record to print it's data in the PDF? Similar idea to how you would use do SQL queries.
    In our case we want to select a meeting related to an contact, that has a specific phrase in it's name and print it's information in the PDF. PDF itself needs to be based on the contact entity since meeting can have multiple related contacts.
    To illustrate it in SQL query form it should look something like this:
    SELECT dateStart
    FROM Meetings
    WHERE name LIKE '%SomePhrase%'
    ORDER BY ABS(DATEDIFF(dateStart, CURDATE()))
    LIMIT 1;​

  • #2
    Have you tried this?
    Imagine you have a float field, and you will print only fieldFloat > 0 <!-- {{#if fieldFloat_RAW [>] 0.0}} --> {{fieldFloat}} <!-- {{/if}} --> the tips is [>] Please, don't respond.... so only tips is "post" .. :D


    Personally I use to filter my Contact's Asset. For example: Bank Account, License, etc

    Comment

    Working...
    X