Convert Report to WQL Fails: This Field Is Missing an Adhoc Alias
The error This field is missing an adhoc alias
What does "Convert Report to WQL Fails: This Field Is Missing an Adhoc Alias" mean in Workday Extend?
A calculated field in the report has no alias that WQL can refer to it by. Calculated fields can be used in WQL, but only through the alias Workday exposes for them, so the conversion has no name to emit for that field and stops.
Quick fix
Give the calculated field an alias and re-run Convert Report to WQL. If you only need the result once, remove the calculated field from the report and compute the value after the query instead.
Permanent fix
Make assigning an alias part of creating any calculated field intended for reporting or query use, so reports built on it stay convertible. Before publishing a report meant to be consumed through WQL, confirm every calculated field it contains has an alias.
Troubleshooting
- Identify which field the conversion stopped on. It will be a calculated field rather than a delivered one.
- Open that calculated field and check its additional information for the alias Workday exposes for query use.
- If no alias is shown, the field has never been given one, which is exactly what the message is reporting.
- Re-run the conversion once the alias exists, and refer to the field by that alias rather than by its display name in any WQL you then write by hand.
Was this helpful?