Code:
"registrationNumberSiteNumber": { "type": "varchar", "notStorable": true, "readOnly": true, "trim": true, "select": { "select": "CONCAT:(rmc.registrationNumber,'-',siteNumber)", "joins": [ [ "RadiationMachineCertificate", "rmc", { "radiationMachineLocation.radiationMachineCertificateId:": "rmc.id", "rmc.deleted": false } ] ] }, "order": { "order": [ ["rmc.registrationNumber","{direction}"], ["siteNumber","{direction}"] ], "joins": [ [ "RadiationMachineCertificate", "rmc", { "radiationMachineLocation.radiationMachineCertificateId:": "rmc.id", "rmc.deleted": false } ] ], "additionalSelect": ["rmc.registrationNumber","radiationMachineLocation.siteNumber"] }, "where": { "LIKE": { "joins": [ [ "RadiationMachineCertificate", "rmc", { "radiationMachineLocation.radiationMachineCertificateId:": "rmc.id", "rmc.deleted": false } ] ], "whereClause": { "CONCAT:(rmc.registrationNumber,'-',siteNumber)*": "{value}" }, "distinct": true }, "NOT LIKE": { "joins": [ [ "RadiationMachineCertificate", "rmc", { "radiationMachineLocation.radiationMachineCertificateId:": "rmc.id", "rmc.deleted": false } ] ], "whereClause": { "CONCAT:(rmc.registrationNumber,'-',siteNumber)!*": "{value}" }, "distinct": true }, "=": { "joins": [ [ "RadiationMachineCertificate", "rmc", { "radiationMachineLocation.radiationMachineCertificateId:": "rmc.id", "rmc.deleted": false } ] ], "whereClause": { "CONCAT:(rmc.registrationNumber,'-',siteNumber)": "{value}" }, "distinct": true }, "<>": { "joins": [ [ "RadiationMachineCertificate", "rmc", { "radiationMachineLocation.radiationMachineCertificateId:": "rmc.id", "rmc.deleted": false } ] ], "whereClause": { "CONCAT:(rmc.registrationNumber,'-',siteNumber)!=": "{value}" }, "distinct": true }, "IS NULL": { "joins": [ [ "RadiationMachineCertificate", "rmc", { "radiationMachineLocation.radiationMachineCertificateId:": "rmc.id", "rmc.deleted": false } ] ], "whereClause": { "CONCAT:(rmc.registrationNumber,'-',siteNumber)=": null }, "distinct": true }, "IS NOT NULL": { "joins": [ [ "RadiationMachineCertificate", "rmc", { "radiationMachineLocation.radiationMachineCertificateId:": "rmc.id", "rmc.deleted": false } ] ], "whereClause": { "CONCAT:(rmc.registrationNumber,'-',siteNumber)!=": null }, "distinct": true } } }
Leave a comment: