How to cross compile a windows executable from linux wiht vcpkg

[sat0sh1c]

I tried to compile the libraries, I need with the x64-windows-static triplet, but build failed with the following error:

error: in triplet x64-windows: Use of Visual Studio's Developer Prompt is unsupported on non-Windows hosts.
Define 'VCPKG_CMAKE_SYSTEM_NAME' or 'VCPKG_CHAINLOAD_TOOLCHAIN_FILE' in the triplet file.

[sat0sh1c]

So the problem with the given approach was the fact that in order to cross-compile a binary you need to select not the tripets with the windows prefix, but the ones with mingw prefix, like the following ones:

community/x64-mingw-static
community/x64-mingw-dynamic

Note that for those to work, you need to have mingw-w64 installed, you find more info here.
After installing those, you might need to do some other things depending on the library you want to link with your executable, for instance I had the following problem with the OpenSSL

/usr/lib/gcc/x86_64-w64-mingw32/15.1.0/../../../../x86_64-w64-mingw32/bin/ld: attempted static link of dynamic object `/usr/lib/libssl.so'
collect2: error: ld returned 1 exit status

That is because somehow CMake was looking for default installation paths, while literally having the following line:
in the CMakeLists.txt file:
set(OpenSSL_DIR "${PROJECT_SOURCE_DIR}/vcpkg_installed/x64-mingw-static/share/openssl")
So the solution for the following error was explicitly to set the environment variable for OpenSSL in the
CmakeLists.txt file:
set(ENV{OPENSSL_ROOT_DIR} "${PROJECT_SOURCE_DIR}/vcpkg_installed/x64-mingw-static")