Page History

DROP VIEW user_search;
ALTER TABLE SyncopeUser DROP COLUMN workflowId;
CREATE VIEW user_search AS SELECT u.id as any_id, u.* FROM SyncopeUser u;


DROP VIEW group_search;
ALTER TABLE SyncopeGroup DROP COLUMN workflowId;
CREATE VIEW group_search AS SELECT r.id as any_id, r.* FROM SyncopeGroup r;

 DROP VIEW anyObject_search;
 ALTER TABLE AnyObject DROP COLUMN workflowId;
 CREATE VIEW anyObject_search AS SELECT a.id as any_id, a.* FROM AnyObject a;