You can also filter BEFORE query. for simplicity: Query([table];[table]client_ID = $Current_Client_ID) Query selection([table])
This will open 4D's query editor, and apply the query the user does to the selection you created before hand. On Mon, 31 Jul 2017 11:34:12 -0700 (MST), jarosz via 4D_Tech wrote: > I have a table which contains records for 10 different clients. > I'd like to give a client the ability to search the table for only his > records and not be able to see any of the other clients' records. > > Is it possible to do this using the standard 4D Query editor by always > applying an additional search criteria eg clientID=xxx? > > Or do I need to build my own custom query editor? > I'm using 4D 15.4. > > I'd be interested to hear how others have approached this... > > Many thanks > > Michael Jarosz > > > > > -- > View this message in context: > http://4d.1045681.n5.nabble.com/Restricting-a-query-tp5753437.html > Sent from the 4D Tech mailing list archive at Nabble.com. > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************