Re^2: mongodb dynamic filter

Unfortunately the post data come from datatables.net js table manager library, i can't easy change it.

When i said it never work for me i mean mongo library fail to use my filter, usually i got an exception in dancer2.

I will play with suggestion i had receive now.

Comment on Re^2: mongodb dynamic filter

Replies are listed 'Best First'.
Re^3: mongodb dynamic filter by 1nickt (Canon) on Nov 08, 2017 at 13:16 UTC
Hi again, Please describe what "it never work for me" means. When i said it never work for me i mean mongo library fail to use my filter, usually i got an exception in dancer2 Unfortunately this is not very much more useful than the first statement you made. In order to be useful information for anyone (including yourself) who is trying to debug the issue, you would better describe it something like: When I pass the constructed filter string to MongoDB using DBI (or Dancer2::Plugin::Database, or whatever you are in fact using), I get a fatal exception, noted in the Dancer2 error log as: `Full text of the error from the log` [download] The error message is, after all, trying to tell you what's going on. ( Regarding the fact that DataTables is making the query to your Dancer2 app ... Here is not the place to debug the Jquery part of your project, but I'll just say that if the built-in DataTables functionality does not fit (e.g. if you are using Editor and "cannot easily" change the query), it's not difficult to create a callback on a row or cell and regain complete control over the requests made to the server. ) The way forward always starts with a minimal test.	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: mongodb dynamic filter
by 1nickt (Canon) on Nov 08, 2017 at 13:16 UTC

Hi again,

Please describe what "it never work for me" means.

When i said it never work for me i mean mongo library fail to use my filter, usually i got an exception in dancer2

Unfortunately this is not very much more useful than the first statement you made. In order to be useful information for anyone (including yourself) who is trying to debug the issue, you would better describe it something like:

When I pass the constructed filter string to MongoDB using DBI (or Dancer2::Plugin::Database, or whatever you are in fact using), I get a fatal exception, noted in the Dancer2 error log as:
   Full text of the error from the log
[download]

The error message is, after all, trying to tell you what's going on.

( Regarding the fact that DataTables is making the query to your Dancer2 app ... Here is not the place to debug the Jquery part of your project, but I'll just say that if the built-in DataTables functionality does not fit (e.g. if you are using Editor and "cannot easily" change the query), it's not difficult to create a callback on a row or cell and regain complete control over the requests made to the server. )

The way forward always starts with a minimal test.

[reply]
[d/l]