Ok. I guess I was hallucinating or something. It works today with one exception. If I change the name of a field (to remove spaces in field names…..), the new field name doesn’t work in an orda query. I get this error:
The "Account_Name" attribute cannot be found in The "Deposits" datastore class This is where I have to reboot the server as the only way to update the datastore, right? Thanks for the list of possible errors and troubleshooting options Miyako. I will use them! Sannyasin Siddhanathaswami On Mar 9, 2020, 6:47 PM -1000, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com>, wrote: Hello, When I do a ds.Table.query() using a field/attribute of a non-indexed field, I get an error. that has not been my experience. v18, Client/Server, non-indexed field, ORDA query has always worked just fine. --- are sure definitely sure that indexing is causing the problem? for instance, could it be that the table does not have a primary key? what is the field type? is it an object? what does the query string look like? does it include "linked" queries? (e.g. attr[a].attr = :1 and attr[a].prop = :2) can you reproduce the problem on a fresh DB? Of course, I can add an index, but then I seem to have restart the server for it to work. This is super inconvenient, obviously and in may cases not possible at that moment. Is there a command to run that reloads whatever list the ds.Table.query() uses to find field/attributes? Or Should I just index all fields? What do you all do? ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************