File Warnings and Messages from Errors and Warnings Panel.

Discussions related to Crystal Reports development.

Moderator: Lisa Ennis

Post Reply
danvanf
Posts: 45
Joined: Fri Nov 07, 2008 10:45 am
Location: Dayton, Ohio
Contact:

File Warnings and Messages from Errors and Warnings Panel.

Post by danvanf » Mon Jul 06, 2020 2:50 pm

Hello,

Is there anywhere in the database that stores each file's Warnings or Messages as they appear in the Select Errors and Warnings panel? Errors of course wouldn't be there since the file can't be saved. We are trying to see the condition of the files based on that information.

Thanks for the assist,
-Dan
I blog at http://DanVanFleet.com on SoftPro and other things

BobRichards
Posts: 1006
Joined: Wed Jan 15, 2014 3:50 pm
Location: Raleigh, NC
Contact:

Re: File Warnings and Messages from Errors and Warnings Panel.

Post by BobRichards » Mon Jul 06, 2020 3:59 pm

Errors/warnings/information in the Errors and Warnings window are not stored in the SQL database. They are only available in code from the API.
Bob Richards, Software Developer, SoftPro

danvanf
Posts: 45
Joined: Fri Nov 07, 2008 10:45 am
Location: Dayton, Ohio
Contact:

Re: File Warnings and Messages from Errors and Warnings Panel.

Post by danvanf » Mon Jul 06, 2020 8:28 pm

Thanks, Bob. Can I ask that it be added to the feature requests? As the file is saving, it is all known information, delete the old records, add new ones. I expect as companies use Validation in python code it would be useful to know pieces of those 2 things.
I blog at http://DanVanFleet.com on SoftPro and other things

BobRichards
Posts: 1006
Joined: Wed Jan 15, 2014 3:50 pm
Location: Raleigh, NC
Contact:

Re: File Warnings and Messages from Errors and Warnings Panel.

Post by BobRichards » Tue Jul 07, 2020 9:47 am

I'm not sure of your business case, though. Custom Order Rule (Python CORs) validation code can access the API directly. CORs cannot (and definitely should not) reach the database. Especially since that would slow the user interface.

How would you use the information and where would you expect it to be?
Bob Richards, Software Developer, SoftPro

danvanf
Posts: 45
Joined: Fri Nov 07, 2008 10:45 am
Location: Dayton, Ohio
Contact:

Re: File Warnings and Messages from Errors and Warnings Panel.

Post by danvanf » Wed Jul 08, 2020 6:25 pm

I am thinking the opposite of the COR reaching out to the database. I'd never do something that obtuse, well I hope not. <smile>

The reason I'm thinking about it is for manager level reports that give a snapshot of the health of the data in the database over a specific search criteria based on the Errors and Warnings Panel. Say we have 20 COR's written to make sure people do things to keep the data clean and we don't want to stop them from saving the file. If when a user save happens Select would save the results of the Error and Warnings Panel to the {{Order}} context this option could be exploited. It would be a list of messages. The COR developer could insert information in the message text for the report developer to filter by.

One of the things we do other than make black marks on paper is to train users. Validation CORs are an excellent methodology to do that, but the management part is missing. We don't really know which of those CORS are being ignored until something else happens. Ie. erroneous data shows up on a report that "Mary" doesn't want to see. Where Mary is one of "those" people.

Thanks for giving it thought if I didn't paint the picture well enough let me know. As I thought through the process it seemed cool, but also niche being COR related. Even for the Mom and Pop shop, I'll bet there are some useful canned Select messages that go unnoticed which would be useful to the decision maker.
I blog at http://DanVanFleet.com on SoftPro and other things

BobRichards
Posts: 1006
Joined: Wed Jan 15, 2014 3:50 pm
Location: Raleigh, NC
Contact:

Re: File Warnings and Messages from Errors and Warnings Panel.

Post by BobRichards » Wed Jul 08, 2020 9:54 pm

Thanks for the well thought out reasoning. I will forward it to a Select team manager.
Bob Richards, Software Developer, SoftPro

Post Reply