I think it is fine to optimise the pyStatusWorkTimestamp. You can choose which application you want to optimise it. This is available from the wizard.

However, I could see that there is a Index-TrackStatus is already available OOTB. You could try to use this. This index makes tracking work status changes easier to report on.

Could you elaborate more on your business requirement, such that we could suggest an alternative?

I had optimized an embedded property present under Work class . The optimization was successful but still could not access the property directly from Work class like Work-. <propname> in my report definition.

What could be the root cause

This comment/reply has been branched into a new post