sqlalchemy-datatables

sqlalchemy-datatables copied to clipboard

Search by single column wrong with different order from the backend

1

Hi, thanks for the work done. I am using fastapi and have integrated your project, everything works except if the order of the front end is different from the backend,...

SimoneGalati21

How to wary rendered column data according to condition?

1

I noticed that it is possible to do custom rendering for column with `ColumnDT("" + User.id + "")`. How can I differ how the data is rendered according to a...

lehtone1

argument must be a string, a bytes-like object or a number, not 'NoneType'

7

``` @app.route("/data", methods=['GET']) def data(): columns = [ ColumnDT(Customer.id), ColumnDT(Customer.Email), ] query = db.session.query(Customer) params = request.args.to_dict() rowTable = DataTables(params, query, columns) print(query , file=sys.stdout) return jsonify(rowTable.output_result()) ``` and i...

evollution

[Question] How to specify column name for front end

2

maigaobridge

FYI, the link to the Flask example is broken in the center page text. The link on the left nav works fine though

tmcfar

Escape results before output

3

Ability to escape data before output, to prevent JS/HTML injections.

vsevolod-kolchinsky

Error during search with oracle: ORA-00932: inconsistent datatypes: expected - got CLOB

1

I am getting the following error when I try to perform a global search while using an oracle database. I'm not sure if this is an issue with sqlalchemy-datatables, sqlalchemy,...

nkgilley

Gazetteer based filtering / Filter dependent on another class

1

Hi, I'm listing the following table in my datatable (simplified version): ``` class MainTerm(db.Model): __tablename__ = 'main_term' id = db.Column(db.Integer, primary_key=True) text = db.Column(db.String) ``` Further I have gazetteers that...

maxtrem

Fix #131: A mapper function to map the frontend columns data with backend. A new yadcf_data params. Some small improvements.

5

**Regarding this [issue](https://github.com/Pegase745/sqlalchemy-datatables/issues/131), I have come up with a ```_map_columns_with_params ``` private method in DataTables class in datatables.py module.** This method compares columns data with the parameters data and map...

kartikeyas00

use of self.columns index rather than mData value problematic

10

I'm having trouble lining up the self.columns index with the index which comes from datatables(js) in the search item. My indexes don't match sometimes because I have to post process...

louking