Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Patricia Allen]

?I am trying to create a view that uses the dimensionattributevaluecombination table as the primary datasource, but only include the records where the  length of the displayvalue  field in the  dimensionattributevaluecombination  table 15 characters long.
I would appreciate help.

——————————
Patricia Allen
County Auditor
Walker County Texas
Huntsville TX
——————————

[Mark Prouty]

?Can you use 15 question marks: ???????????????  ?

——————————
Mark Prouty
Programmer / Analyst
ANGI Energy Systems
Janesville WI
——————————
——————————————-

[Patricia Allen]

?That worked.  Thanks

——————————
Patricia Allen
County Auditor
Walker County Texas
Huntsville TX
——————————
——————————————-

[Rick Pierson]

You could try the following (use at your own risk, test this out in DEV before touching TEST or PROD, blah blah blah).

1) Create a new custom table to store the length of the DisplayValue.
Name the table something like AaaDAVCExtension (where Aaa is a 3-letter code for your company).
The new table would (at this point) have only 2 fields: RefRecId and DisplayValueLength

2) Use eventing on the DimensionAttributeValueCombination table’s insert method to call code that populates AaaDAVCExtension fields DisplayValueLength and RefRecId.
Test the eventing code to make sure it works.

3) Write a one-time-use AX job to while select through DimensionAttributeValueCombination and store the length of DisplayValue in the new table.  Run the job over night and check results.

4) Relate the new table back to DimensionAttributeValueCombination using an exactly 1-to-exactly 1 “relation”.   
So newTable.RefRecId = DimensionAttributeValueCombination.RecId

5) Modify the view to include the new table, inner joined to DimensionAttributeValueCombination.

If you do the above, then adding a query range (on the new table) would be easy and should be far more performant than calculating the length of each DimensionAttributeValueCombination record’s DisplayValue on the fly for each execution of the view.

——————————
Rick Pierson
Braun Intertec
Bloomington MN
——————————
——————————————-