richard-churchman 2a3e1e981f Bug fixes relating to Inline Script enhancements in GitHub Issue #95 ...

* Renamed GetModelFieldByEntityAnalysisModelIdParseTypeIdQuery to GetEntityAnalysisModelFieldByEntityAnalysisModelIdParseTypeIdQuery to align with database model naming.
* Fixed bugs where Inline Scripts were not being matched correctly in Completions and Soft Parsing because EntityAnalysisModelInlineScript.Id was being used instead of EntityAnalysisInlineScript.Id (affecting three areas).
* Swapped Latitude and Longitude matching in Activation Watcher processing for Activation Rules.
* Updated the Sandbox code for Inline Scripts to be less brittle and a more reliable example for client use.

2026-01-13 08:59:52 +02:00

..

Parser.cs

Bug fixes relating to Inline Script enhancements in GitHub Issue #95

2026-01-13 08:59:52 +02:00

Rule.cs

Minor changes to the query GetModelFieldByEntityAnalysisModelIdParseTypeIdQuery.cs used by CompletionsController.cs - which is responsible for looking up available values for the JQuery Builder - to cast from a string rather than JSONB value (->> not ->) as it was causing issues in sql query parameterization. Created a parser for the server side creation of sql while also performing verification of the fields passed, including the translation to its sql fragment rather than relying on the value being passed from the client. The parser creates the required sql while ensuring that the it is properly parameterized, with the required tokens being extracted as .Net types based on the specification of the field (e.g. a Date is parsed and typed DateTime). Parameter values available alongside the sql for execution. It is not now possible to pass values in sql without them subject to a parameterized prepare step. Refactored the SessionCaseSearchCompiledSqlController.cs controller to bring it all together. No sql is parsed on the client now, and this has been removed from the dto altogether. Some improvement in the reliability of the query builder and inclusion of like and not like operators.

2024-05-04 11:53:26 +02:00