Book a Demo

Author Topic: Printing events in project calendar  (Read 4970 times)

amenedo

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Printing events in project calendar
« on: October 02, 2015, 08:12:14 pm »
Hi everybody!

I'm using the project calendar to record meetings and a brief summary of their contents. But now I am not able to print in any way a summary of all project meetings. Is there any functionality to get it?

Thanks in advance and best regards.

KP

  • EA Administrator
  • EA Expert
  • *****
  • Posts: 2919
  • Karma: +55/-3
    • View Profile
Re: Printing events in project calendar
« Reply #1 on: October 05, 2015, 09:48:06 am »
This should get you started:

Code: [Select]
SELECT * FROM t_document WHERE ElementType='calendar'
The Sparx Team
[email protected]

amenedo

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: Printing events in project calendar
« Reply #2 on: October 05, 2015, 09:45:35 pm »
Thanks for your useful answer!!!

After researching about "Custom Queries" in Reports now I´ve discovered a new powerfull utility in EA Reports.

But still dont know how to get the notes written down in my Project Events

Code: [Select]
SELECT DocName, ??? FROM t_document WHERE ElementType='calendar'
Any suggestions?

Best regards.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Printing events in project calendar
« Reply #3 on: October 05, 2015, 11:05:55 pm »
Doesn't DocName, Notes work for you? Or maybe you try with StrContent instead of Notes.

q.
« Last Edit: October 05, 2015, 11:07:56 pm by qwerty »

amenedo

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: Printing events in project calendar
« Reply #4 on: October 06, 2015, 08:24:33 pm »
As you said, the info that I need is in the field StrContent but it has a XML structure and don´t know how to manage it.

Thanks for your interest.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Printing events in project calendar
« Reply #5 on: October 06, 2015, 09:49:46 pm »
The only way is to do that programmatically. I guess you are talking about document generation, so I can't offer much help in that direction.

q.