72) How to show 2 field data in 1 field using union query

  I had a scenario where I need to show the 2 field data in 1 field on form.


So to achieve this requirement what i create i create a 2 query 1 for table A and 2nd for table B. filed name mush be same in both view.


after that will create a UNION view and drag this data sources :- 


Step 1 Create a view :- 



ADd the property and run


  
Step 3 :- Create a display method on the view and assigned in fields:- 

public static str ChecklistVariableName()
    {
        return SysComputedColumn::returnField(tableStr(AvaEntAssetChecklistCounterReportView), identifierStr(EntAssetCounterType), fieldStr(EntAssetCounterType, CounterTypeId));
    }


Comments

Popular posts from this blog

Customization on Sales invoice Report in D365 F&O

75) COC - Create a coc of the table modified method

46) D365 FO: SHAREPOINT FILE UPLOAD USING X++