Gururaj Basavaraj a Siebel Unleashed reader shared a very useful tip for very commonly faced problem.
Whenever the user queries on the MVF Field on list applet and try to export the result records. The Siebel instance used to hang or it was taking too long time to export the records.
After investigating I found that the query on the MVF Field was not taking as “EXISTS(=<Value>)” as it is MVF Field but taking as “=<value>” because of which it was returning only those record in which that Query Value was Primary and export was making system to hang.
For example if you queried on MVF Field for the term ‘Siebel’ instead of executing it as EXISTS(‘Siebel’) it being executed as = ‘Siebel’.
There is a System preference “Default MVG Exists Query” which decides whether the query on MVF Field will default as “EXISTS(=<Value>)” or not. I made it “TRUE” and then the export hanging issue got resolved. To check or change the value of this preference follow the below given steps
- Click on Site Map Icon
- Choose Administration Application –> System Preferences
- Query for Default MVG Exists Query
- Change the Value to TRUE if FALSE
Please do provide your feedback if this tip has helped you.