Wildcards. Do they exist in Relevance language?

Content Authoring
21

Any results from the following query?

Q: exists key "filemaker.exe" of key "HKLM\Software\Microsoft\Windows\CurrentVersion\App Paths" of Registry
A: True
22

Tried this with no luck:
Q: if (name of operating system starts with “Win”) then if exists file “C:\Program Files (x86)\FileMaker\FileMaker Pro *\FileMaker Pro” then version of file “C:\Program Files (x86)\FileMaker\FileMaker Pro *\FileMaker Pro” as string else “Not Installed” else if (name of operating system starts with “Mac”) then if exists file “/Applications/FileMaker Pro */FileMaker Pro.app” then version of regapp “FileMaker Pro.app” as string else “Not Installed” else "Not Installed"
A: Not Installed
T: 0.265 ms

I tried a few options, but none worked.
Q:exists key “filemaker pro” of key “HKLM\Software\Wow6432Node\Microsoft\Windows\CurrentVersion\App Paths” of Registry
A: False
T: 0.167 ms

I also tried this, placing the actual folder in the path just to try and get a result. I, of course, have to find all versions of FileMaker, not just 13.
Q:version of file “FileMaker Pro.exe” of folders “FileMaker Pro” of folders “FileMaker Pro 13” of folders "C:\Program Files (x86)"
E: Singular expression refers to nonexistent object.

23

Keep in mind that the “App Paths” keys are the file names of the Executable files themselves, so most of them will end in “.exe”

Another option might be to try the following Relevance …

Q: exists key whose (name of it as lowercase contains "filemaker") of key "HKLM\Software\Microsoft\Windows\CurrentVersion\App Paths" of Registry
24

I thought “regapp” looked at the App Paths registry key described at https://msdn.microsoft.com/en-us/library/windows/desktop/ee872121(v=vs.85).aspx

… which is a completely optional method for an application to define an executable’s path without having to add its directory to the system’s PATH variable.

25

Client might be confused due to wow6432 redirection. Besclient.exe is a 32-bit binary so you sometimes need to specify whether to use 64- or 32-bit paths.

Try:

Q:version of file "FileMaker Pro.exe" of folders "FileMaker Pro" of folders "FileMaker Pro 13" of program files x32 folder
26

One of the beauties of App Paths is that it seems to be the same under both the 32bit and 64bit branches of the Registry on a 64bit system.

27

Same deal… Nothing.

Q:version of file "FileMaker Pro.exe" of folders "FileMaker Pro" of folders "FileMaker Pro 13" of program files x32 folder
E: Singular expression refers to nonexistent object.
28

Can you take each part of that relevance and put it in QnA and post the results?

Q: program files x32 folder

Q: folders of program files x32 folder

q: folders "FileMaker Pro 13" of program files x32 folder

Q: folders of folders "FileMaker Pro 13" of program files x32 folder

Q: folders "FileMaker Pro" of folders "FileMaker Pro 13" of program files x32 folder

Q: files of folders "FileMaker Pro" of folders "FileMaker Pro 13" of program files x32 folder

Q: files "FileMaker Pro.exe" of folders "FileMaker Pro" of folders "FileMaker Pro 13" of program files x32 folder

Q: version of files "FileMaker Pro.exe" of folders "FileMaker Pro" of folders "FileMaker Pro 13" of program files x32 folder
29

Its my understanding that if you want an application to open its own files you have to register in App Paths

30 
Q: program files x32 folder
A: C:\Program Files (x86)
T: 179.733 ms

Q: folders of program files x32 folder
A: C:\Program Files (x86)\Adobe
A: C:\Program Files (x86)\Apple Software Update
A: C:\Program Files (x86)\ArcGIS
A: C:\Program Files (x86)\BigFix Enterprise
A: C:\Program Files (x86)\Bonjour
A: C:\Program Files (x86)\Common Files
A: C:\Program Files (x86)\Elaborate Bytes
A: C:\Program Files (x86)\FileMaker
A: C:\Program Files (x86)\Google
A: C:\Program Files (x86)\GUM1CD3.tmp
A: C:\Program Files (x86)\InstallShield Installation Information
A: C:\Program Files (x86)\Intel
A: C:\Program Files (x86)\Internet Explorer
A: C:\Program Files (x86)\iTunes
A: C:\Program Files (x86)\Java
A: C:\Program Files (x86)\Microsoft Analysis Services
A: C:\Program Files (x86)\Microsoft Help Viewer
A: C:\Program Files (x86)\Microsoft Office
A: C:\Program Files (x86)\Microsoft SDKs
A: C:\Program Files (x86)\Microsoft Silverlight
A: C:\Program Files (x86)\Microsoft SQL Server
A: C:\Program Files (x86)\Microsoft SQL Server Compact Edition
A: C:\Program Files (x86)\Microsoft Visual Studio 11.0
A: C:\Program Files (x86)\Microsoft.NET
A: C:\Program Files (x86)\MIT
A: C:\Program Files (x86)\Mozilla Firefox
A: C:\Program Files (x86)\Mozilla Maintenance Service
A: C:\Program Files (x86)\MSBuild
A: C:\Program Files (x86)\MSECache
A: C:\Program Files (x86)\MSXML 4.0
A: C:\Program Files (x86)\Notepad++
A: C:\Program Files (x86)\NuGet
A: C:\Program Files (x86)\Oxford University Press
A: C:\Program Files (x86)\Pathways4
A: C:\Program Files (x86)\Penn Apps 2010
A: C:\Program Files (x86)\Pharos
A: C:\Program Files (x86)\PharosSystems
A: C:\Program Files (x86)\QuickTime
A: C:\Program Files (x86)\Reference Assemblies
A: C:\Program Files (x86)\Sassafras K2
A: C:\Program Files (x86)\Scientific Viewer
A: C:\Program Files (x86)\Skype
A: C:\Program Files (x86)\Stata14
A: C:\Program Files (x86)\Symantec
A: C:\Program Files (x86)\Turning Technologies
A: C:\Program Files (x86)\Uninstall Information
A: C:\Program Files (x86)\Vernier Software
A: C:\Program Files (x86)\VideoLAN
A: C:\Program Files (x86)\Windows Defender
A: C:\Program Files (x86)\Windows Kits
A: C:\Program Files (x86)\Windows Mail
A: C:\Program Files (x86)\Windows Media Player
A: C:\Program Files (x86)\Windows NT
A: C:\Program Files (x86)\Windows Photo Viewer
A: C:\Program Files (x86)\Windows Portable Devices
A: C:\Program Files (x86)\Windows Sidebar
A: C:\Program Files (x86)\WinSCP
A: C:\Program Files (x86)\Zoom
T: 8.595 ms

Q: folders "FileMaker Pro 13" of program files x32 folder
T: 0.635 ms

Q: folders "FileMaker Pro" of folders "FileMaker Pro 13" of program files x32 folder
T: 0.335 ms

Q: files of folders "FileMaker Pro" of folders "FileMaker Pro 13" of program files x32 folder
T: 0.695 ms

Q: files "FileMaker Pro.exe" of folders "FileMaker Pro" of folders "FileMaker Pro 13" of program files x32 folder
T: 0.678 ms

Q: version of files "FileMaker Pro.exe" of folders "FileMaker Pro" of folders "FileMaker Pro 13" of program files x32 folder
E: Singular expression refers to nonexistent object.

Thanks for the help!

31

What does this return:

Q: folders "FileMaker" of program files x32 folder

Q: folders of folders "FileMaker" of program files x32 folder

Q: folders "FileMaker Pro" of folders "FileMaker" of program files x32 folder

Q: files of folders "FileMaker Pro" of folders "FileMaker" of program files x32 folder
32

I think that to open its associated files the handler must be registered in HKLM\Software\Classes or HKCU\Software\Classes .

Registering under App Paths allows you to execute the program without specifying its path, from the Run button or Start command in a command prompt.

33

You did catch there that the folder name is not Filemaker Pro, it’s Filemaker, right?

A: C:\Program Files (x86)\FileMaker

Adjust your other relevance queries accordingly…

1 Like
34 
Q: folders "FileMaker" of program files x32 folder
A: C:\Program Files (x86)\FileMaker
T: 0.329 ms

Q: folders of folders "FileMaker" of program files x32 folder
A: C:\Program Files (x86)\FileMaker\FileMaker Pro 13
T: 0.510 ms

Q: folders "FileMaker Pro" of folders "FileMaker" of program files x32 folder
T: 0.363 ms

Q: files of folders "FileMaker Pro" of folders "FileMaker" of program files x32 folder
T: 0.823 ms
35

Try

Q: folders whose (name of it contains "FileMaker Pro") of folders "FileMaker" of program files x32 folder

Q: files of folders whose (name of it contains "FileMaker Pro") of folders "FileMaker" of program files x32 folder
36 
Q: folders whose (name of it contains "FileMaker Pro") of folders "FileMaker" of program files x32 folder
A: C:\Program Files (x86)\FileMaker\FileMaker Pro 13
T: 0.493 ms

Q:versions of files of folders whose (name of it contains "FileMaker Pro") of folders "FileMaker" of program files x32 folder
A: 5.1.1.0
A: 13.0.1.54899
A: 10.1.0.7
A: 10.1.0.2
A: 10.1.0.15
A: 10.1.0.3
A: 10.1.0.3
A: 10.1.0.2
A: 10.1.0.2
A: 10.1.0.7
A: 10.1.0.2
A: 10.1.0.23
A: 10.1.0.3
A: 1.3.0.1
A: 10.0.1.5
A: 13.0.1.194
A: 13.0.1.54899
A: 13.0.1.54899
A: 13.0.1.54899
A: 4.0.0.0
A: 4.0.0.0
A: 13.0.1.54899
A: 7.21.6.0
A: 1.0.1.5
A: 2.1.23.0
A: 4.1.6.0
A: 4.1.6.0
A: 4.1.6.0
A: 13.0.1.0
A: 1.0.1.5
A: 13.0.1.54899
A: 11.2.2.0
A: 13.0.1.54899
A: 13.0.1.1
A: 1.11.0.0
A: 3.0.1.0
A: 13.0.1.194
A: 13.0.1.194
A: 1.1.0.0
T: 17.120 ms

I tried a little versioning, but it just brought everything

37

try:

(versions of it, names of it) of files of folders whose (name of it contains "FileMaker Pro") of folders "FileMaker" of program files
38

Q: (versions of it, names of it) of files of folders whose (name of it contains “FileMaker Pro”) of folders “FileMaker” of program files
E: The operator “program files” is not defined.

39

Sorry…
Q: (versions of it, names of it) of files of folders whose (name of it contains “FileMaker Pro”) of folders “FileMaker” of program files x32 folder

40

You’d want the singular so:

Q: (version of it, name of it) of files of folders whose (name of it contains "FileMaker Pro") of folders "FileMaker" of program files x32 folder
1 Like