APAC SD Team
Category
Report Builder
Product Version
7.2
"Validate SQL" Only Once on Calculated Field window
Idea Logged
Today, upon pressing "Validate" to check if there's an error or not, once we press on "Save" or "OK" button - it validates the field again! Agonizing. :)
I like this idea 
Hi Tal,
there is actually a way to turn off the validation that occurs automatically when you click the Save button.
Just follow the instructions from the following Community Knowledge Base article:
https://community.yellowfinbi.com/knowledge-base/article/turn-off-validation-of-calculated-fields-when-saving
and you will no longer get that 2nd unwanted validation!
regards,
David
Hi Tal,
there is actually a way to turn off the validation that occurs automatically when you click the Save button.
Just follow the instructions from the following Community Knowledge Base article:
https://community.yellowfinbi.com/knowledge-base/article/turn-off-validation-of-calculated-fields-when-saving
and you will no longer get that 2nd unwanted validation!
regards,
David
Hey Dave!
This is great however can be a bad idea since we want users to get the correct queries every time they create a calculated field.
However, we have a better idea, not sure if you guys will agree to that.
How about a process which saves an indicator that say "Validated already" and upon pressing "Save" - it will read the indicator and will just save.
If there will be no indicator, meaning the user didn't press "Validate" , it will validate the query before saving.
Bests
Dor & Tal
Hey Dave!
This is great however can be a bad idea since we want users to get the correct queries every time they create a calculated field.
However, we have a better idea, not sure if you guys will agree to that.
How about a process which saves an indicator that say "Validated already" and upon pressing "Save" - it will read the indicator and will just save.
If there will be no indicator, meaning the user didn't press "Validate" , it will validate the query before saving.
Bests
Dor & Tal
Hi Tal,
yes, I can understand that you don't trust your users to remember to click the Validate button every time...sometimes they will forget and then perhaps save an invalid calculated field that will break a report.
OK, well your idea sounds good to me (I was only suggesting the VALIDCALCONSAVE idea because it is already implemented, much better than waiting for the product team to evaluate your Idea) so I have raised an internal enhancement request (YFN-8794), now let's see what the product team eventually decide...
regards,
David
Hi Tal,
yes, I can understand that you don't trust your users to remember to click the Validate button every time...sometimes they will forget and then perhaps save an invalid calculated field that will break a report.
OK, well your idea sounds good to me (I was only suggesting the VALIDCALCONSAVE idea because it is already implemented, much better than waiting for the product team to evaluate your Idea) so I have raised an internal enhancement request (YFN-8794), now let's see what the product team eventually decide...
regards,
David
you're welcome Tal!
regards,
David
you're welcome Tal!
regards,
David
Hey Dave !
Is there any update on this idea ?
Hey Dave !
Is there any update on this idea ?
Replies have been locked on this page!