hey guys.
when trying to re-write a filter i have to do something similar but a bit else,
i encounter the following error while trying to save the filter's query:
Filter 'Filter luns for DS by name prefix in a specific volume' returned attributes does not contain all natural keys. Filter's returned attributes '[id, name, num_part]' , dictionary entry natural keys '[array.ip, name]'
i tried the containing query in a query builder in Toad and it returned data fine.
ideas?
| SELECT storage.lun.name, storage.volume.id, SUBSTRING_INDEX(storage.lun.name, '${lun_name_prefix}', -1) AS num_part FROM storage.volume, storage.lun WHERE storage.lun.volume_id = storage.volume.id AND storage.lun.name LIKE '${lun_name_prefix}%' ORDER by num_part desc |
thanks!
solal.