Thanks for the input Mervin, I appreciate your insight. I have tried it both with the DB field name and with the binding expression with businessData set to true and I am still seeing the same error in the log.
With the increased log detail I can now see the SQL query which has this line:
TaskSearchAll: sql = …JOIN (SELECT TASK_ID, “company”, “daysAssigned”, “diaryDate”, “lastUpdated”, “lastUpdated2”, “newCustomID”, “progress”, …
I am attempting to search by daysAssigned, and have put it verbatim as the field value in the search query, and now that I see it referencing the indexed table which has the same DB name for the field I am starting to wonder if it something to do with the actual indexing of fields.
The following lines are shown after the above sql query:
2013-08-13 09:46:06 EDT (task:WARN) [WS:1065] - Query Task Paged fails to search for: “daysAssigned”
2013-08-13 09:46:06 EDT (task:INFO) [WS:1065] - Query Tasks Paged Task Search Query V2 [from:0; to:2147483647; sortBy: null; sortOrder: asc searchTerms: {taskTypeID in [5513E349-C313-C0CB-04AC-0A42C76590F9, 8A02099E-7EC5-91C9-6A36-E707D9841BE1, FAB7B3B9-9EEE-D75D-57C1-5686C130BE8B]; “daysAssigned” = 2} completed in 24ms
and produces the correct result despite the warnings, so it must be referencing the index fields correctly. Any thoughts?
#webMethods-BPMS#webMethods#MWS-CAF-Task-Engine