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
public static str ChecklistVariableName()
{
return SysComputedColumn::returnField(tableStr(AvaEntAssetChecklistCounterReportView), identifierStr(EntAssetCounterType), fieldStr(EntAssetCounterType, CounterTypeId));
}
Comments
Post a Comment