Nama ERP DocsNama ERP Docs
Home
Namasoft.com
Data Model
GitHub
Home
Namasoft.com
Data Model
GitHub
  • Home

    • Search
    • Getting Started
    • Platform Features

      • Utility Links
      • Keyboard Shortcuts
      • اختصارات لوحة المفاتيح
      • Screen Modifier
      • List Views
      • التحكم في إقفال الفترات المحاسبية (Fiscal Period Control)
      • Approvals
      • الصلاحيات والأمان
      • Entity Flows
      • Reports
      • Business Intelligence
      • Notifications
      • Virtual Entities — Reusable SQL Building Blocks for Reports & Dashboards
      • Field Filter with Criteria
      • أسئلة شائعة حول فلترة الحقول
      • تعديل الترجمات في نظام نما
      • Criteria Based Validation
      • Criteria from Text Parser (Text Criteria Guide)
      • Scheduled Tasks (Task Scheduler)
      • أعدادات الحقول و الشاشات - Generic Reference Overrider User Guide
      • .
    • Modules

      • الفواتير والضرائب والخصومات
      • Supply Chain
      • Manufacturing
      • Human Resources
      • Point of Sale
      • Real Estate
      • Mobile Applications
      • e-commerce Integration
      • .
    • External Integrations
    • System Administration

      • Troubleshooting
      • Reprocessing Transactions
      • .
    • Developer Reference
    • AI Generated Entity Flows Documentation

      • Core
      • Accounting Module
      • AI Module
      • Contracting Module
      • CRM Module
      • EGTax Reader Module
      • Freight Management System Module
      • Hospital Management System Module
      • HR Module
      • e-commerce Integration Module
      • Manufacturing Module
      • POS Module
      • Real Estate Module
      • Service Center Module
      • Supply Chain Module
      • .
    • Release Notes

      • 2016
      • 2017
      • 2018
      • 2019
      • 2020
      • 2021
      • 2022
      • 2023
      • 2024
      • 2025
      • 2026
      • .
    • Video Tutorials

      • Supply Chain Videos
      • Report Wizard Videos
      • Human Resources Videos
      • .

Criteria Based Validation

You can display error line numbers by including the following in the error message template:

LineNumber - Error Line Number - Criteria Based Validation Error Lines

 The error happened at Line Number {$map.errorLines}

Check old data:

Example:

select case when {remarks}<>{oldData.remarks} then 1 else 0 end

Don't ignore spaces: Example:

select case when {remarks}<>{oldData.remarks} and coalesce({oldData.remarks},'')<>'' then 1 else 0 end
Edit On github
Last Updated:: 6/4/26, 9:58 PM
Prev
تعديل الترجمات في نظام نما
Next
Criteria from Text Parser (Text Criteria Guide)