microsoft / microsoft/Dynamics-365-FastTrack-Implementation-Assets
CDM - GetTableMaxFieldLength - Parametrize query for retrieval of string length
Nobody has claimed this yet.
- Dominant language
- Jupyter Notebook
- Stars
- 494
- Forks
- 296
- Avg merge
- 1d 10h
- Merged PRs (30d)
- 5
Description
Method uses a fixed select statement versus the Information_Schema.Columns view to retrieve the string length of a specified table/column ...
With Dynamics 365 the Information_Schema is not available for use ...
If the sql statement could be configurable, the column definition could be redirected to another source (for instance a copy of the SQLDictionary on an Azure SQL Database exposed via Data Export)
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating the GetTableMaxFieldLength method and its fixed query against Information_Schema.Columns. Read how the method receives its table and column inputs, then trace the available configuration or query entry point. Done means the string-length lookup can use an alternate source such as a SQLDictionary copy on Azure SQL Database while preserving the existing lookup behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100