Nouha Mhadhbi added a comment - 28/Aug/25 3:06 PM The ticket has been resolved, and a batch will be released for it. Please find the script below to apply. Best regards, Nouha INSERT INTO DB_VIEW_CONF (VIEW_NAME, ATTRIBUTE_NAME, VALUE) VALUES ('REDLINE_VIEW','VERSION_NAME','put your version'); -------------------------------------------------------------------------------------------------------------------------- CREATE OR REPLACE FORCE EDITIONABLE VIEW REDLINE_VIEW ( "VENDOR", "IDU_NAME", "LABEL", "IDU_ID", "LOCATION", "IDU_TYPE", "NE_ID", "SITE_ID", "SITE_NAME", "LOCATION_REGION","LOCATION_CITY") AS WITH SELECTED_VERSION AS (SELECT VERSIONID VERSION_ID FROM VERSION WHERE NAME = (SELECT VALUE FROM DB_VIEW_CONF WHERE VIEW_NAME = 'REDLINE_VIEW' AND ATTRIBUTE_NAME = 'VERSION_NAME')) select m.name vendor, i.name IDU_NAME, i.name || ' '||i.objectid LABEL, i.objectid IDU_ID, c.wilayah_name LOCATION, type.name IDU_TYPE, i.neid NE_ID, s.objectid SITE_ID, s.name SITE_NAME, c.governate_name LOCATION_REGION, c.city_name LOCATION_CITY FROM IDU i left join SELECTED_VERSION v on v.VERSION_ID=i.versionid left join site s on s.siteid=i.siteid left join FN_CITY_VIEW c on c.city_id=s.zone_id left join IduType type on i.IduTypeID=type.IduTypeID left join Manufacturer m on m.ManufacturerID=type.ManufacturerID where m.name='REDLINE';

Abir Messaikeh added a comment - 01/Sep/25 2:27 PM DB view delivered