Page 1 of 1

File Warnings and Messages from Errors and Warnings Panel.

Posted: Mon Jul 06, 2020 2:50 pm
by danvanf
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

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

Posted: Mon Jul 06, 2020 3:59 pm
by BobRichards
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.

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

Posted: Mon Jul 06, 2020 8:28 pm
by danvanf
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.

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

Posted: Tue Jul 07, 2020 9:47 am
by BobRichards
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?

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

Posted: Wed Jul 08, 2020 6:25 pm
by danvanf
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.

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

Posted: Wed Jul 08, 2020 9:54 pm
by BobRichards
Thanks for the well thought out reasoning. I will forward it to a Select team manager.