I am doing my first Patch command in a while (since CDS v1 and now I am working with CDS v2) and experiencing weird behavior.
When I use the following command on an unmodified CDS entity ('Plant Inventories") everything is good.
Patch('Plant Inventories'),
plant,
{
'Plant Description': txtPlantDescription.Text,
'Location Description': txtLocationDescription.Text
}
)
I load the record"plant" up when I navigate to a new screen with the Save button using this code and use it in the Patch function to identify the record to be updated. Before I do the AddColumns command below, this record does not have the two columns from the AddColumns command as you would expect.
Navigate(AddEditPlants,ScreenTransition.Fade, {editMode: true, plant: galSearchPlants.Selected})
When I add the more complex AddColumns statement below to the Gallery to provide multi-field Search across both standard Text and Lookup (to another Entity) columns, then my Patch statement fails with a strange result "the specified column "PlantFullCategoryName" does not exist." (the message is just hiding the Save button) that I have yet to decipher. When the 'plant' record is instantiated after I execute the AddColumns, these two columns are dutifully added to 'plant' and I am suspecting that is the root of the problem somehow.
SortByColumns(
Search(
AddColumns(
'Plant Inventories',
"PlantFullName",
'Plant Name'.cr571_plantname,
"PlantFullCategoryName",
'Plant Category '.cr571_plantcategoryname
),
txtSearchString.Text,
"PlantFullName",
"PlantFullCategoryName",
"cr571_description",
"cr571_locationdescription"
),
"PlantFullName",
If(
SortDescending1,
Ascending,
Descending
)
)
Now we know it exists in the "plant" object because it is being shown in the blue highlighted field (as is the other one) but I suspect that it is warning me that this doesn't exist in the 'Plant Inventories' CDS object (since I AddColumns on it). My first instinct was to DropColumns on 'plant' but that didn't work (or I didn't do it right).
It was good just to write this out to clearly state what is happening and I would appreciate anyone with experience Patching to a CDS object that as had an AddColumns operation done to it chiming in with some assistance. Should I retry DropColumns on both the 'Plant Inventories" CDS object and the temporary record 'plant'? just one or the other? Am I doing something else wrong?
Also, when I solve this little problem, I will be looking for the correct syntax to update a LookUp field to another CDS object. I have an old example from 3 years ago on CDS V1 that I suspect is woefully out of date and haven't found another one for CDS v2.
Thanks,
Mark
206-679-3277
