Question 4 Replies 1336 Views × Close popover Shruti Gupta (ShrutiG6684) Bank of America Bank of America US View Profile Send Message ShrutiG6684 Member since 2019 5 posts Bank of America Posted: July 18, 2019 Last activity: July 25, 2019 Posted: 18 Jul 2019 21:44 EDT Last activity: 25 Jul 2019 10:53 EDT Closed How do we determine if a property is optimized or not? We index and exposed embedded properties as columns. How do we determine if any property is optimized or not. Is there any way in dev studio where we check given a property if it is optimized or not. ***Edited by Moderator: Lochan to update platform capability tags*** Case Management × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 1 year ago Posted: 18 Jul 2019 23:01 EDT × Close popover Praveen Palagani (palas3) PEGA Principal Technical Solutions Engineer Pegasystems Inc. IN View Profile Send Message palas3 PEGA replied to ShrutiG6684 Hi Shruti, Thanks for posting the query. You can use the modify schema wizard to check the optimized properties. 1. Go to the Designer-studio-->System-->Database-->Modify Schema. 2. Select the database where your work table is present. 3. Select the work table that got mapped to corresponding work class. 4. Click on the columns link inside the grid to view the properties. 5. The properties which were already exposed will be greyed-out. Posted: 1 year ago Posted: 19 Jul 2019 0:27 EDT × Close popover Siddharth Bharkatya Bharkatya (bhars1) PEGA Senior Technical Solutions Engineer Pegasystems Inc. IN View Profile Send Message bhars1 PEGA replied to ShrutiG6684 Hi Shruti, In Exposing we will be creating a dedicated column in the database table and map the corresponding property to the database column. You can check in the corresponding Mapped table whether those exposed properties are present or not in the table. Thanks Posted: 1 year ago Posted: 19 Jul 2019 2:07 EDT × Close popover Uday Kumar Reddy Teegala (teegu) PEGA Senior Technical Solutions Engineer Pegasystems Inc. IN View Profile Send Message teegu PEGA replied to ShrutiG6684 we have function Utilities • isDBColumn() With help of this you can check if the column exist. if it exists than we can say it is optimized Posted: 1 year ago Posted: 25 Jul 2019 10:53 EDT × Close popover Shruti Gupta (ShrutiG6684) Bank of America Bank of America US View Profile Send Message ShrutiG6684 Bank of America replied to ShrutiG6684 Thank you all for your inputs.