Deleting a Query Item

[cogman]

Hi

I am using a view as source and got all the columns in to framework manager.Now i want to delete a single column in view and framework manager.I can edit the view and delete the column.How can i do it in framework manager.When i delete the column in view and test the query subject in framework manager it gives an error.Can anyone help me to  how to delete a query item in FM or any other alternative ?

Thks for the Help

[Draoued]

It depends :-) I likes answer which starts like that.

one way:
Delete the field in the view in database.

Then if you are following the best practices in Framework manager you have a database namespace.
Database namespace includes all the tables/views , and if you edit the view  you have something like:
select * from My_view;

Then when closing the view editor, the field will disappear automatically.
Then you go to your business namespace, and you simply select the field and hit the delete on your keyboard.

[cogman]

Thks ;D ;D

[kvuppala]

Hi,

Also there is another way. Click on the database object which has to be modified and then go to "Tools -> Update Object". Updates the database related query subject and then follow the second part of Draoued's reply.

This is just for information so that we could know the ways to solve one problem.  :)

Thanks!