Product Logo

CNS Query

Query your databases without relationships.


Introduction

What is CNS Query?

While we were developing CNS Audit, we created several internal helper functions for running queries against FileMaker® Pro databases. We needed the ability to Add Tables; Find, Add, and Update Records; match Table, Layout, and Field names to their internal IDs; and many other tasks. After a while, we took a step back and thought, “we could make a plug-in out of these helper functions.” CNS Query was born. (Actually, MMQuery was born, but we later renamed it to CNS Query.)

This plug-in provides you with many easy-to-use functions to work with your data from any calculation and without creating any extraneous relationships. You can add, remove, and update tables, fields, and records. Get or Set the value of any field by name. Extract information about fields like name, id, and type. Extract information about layouts like name, id, and what fields are on the layout. Check whether a field, layout, or table exists. List and concatenate information from one or more fields from any table without defining a relationship to that table. We have even provided a function for direct SQL access if you are fluent in SQL.

Not only can CNS Query work under FileMaker Pro, but you it also works on your FileMaker Server. The Server Edition can be installed on FileMaker Server to be used with Scheduled Scripts, Perform Script on Server, Web Direct, and Custom Web Publishing.

So, if you are ready to have access to your data like never before, download CNS Query today and begin your adventure!

FileMaker Client Requirements

14.x (32Win), 14.x (64), 15.x (32Win), 15.x (64), 16.x (32Win), 16.x (64), 17.x (32Win), 17.x (64), 18.x (32Win), 18.x (64)

FileMaker Server Requirements

13.x, 14.x, 15.x, 16.x, 17.x, 18.x, 12.x

Mac Requirements

10.9, 10.10, 10.11, 10.12, 10.13, 10.14

Win Requirements

Vista, 7, 8, 10, Microsoft .NET Framework 4.5.x, Microsoft Visual C++ 2017 Redistributable Package

General

A general knowledge of FileMaker scripting and using the calculation engine is needed to use a FileMaker plug-in.


Current Version

3.0.0