Frappe Framework Enhancements

[LifeP]

Inviting developers to create roadmap for framework level enhancements -
Here are a few -

1. Reports - Dynamic Reporting (with group by), charts creation
2. Reports - Hierarchical Filtering (eg. Warehouse, Item group, Sales team)
3. Kanban board - with drag feature to change status or field. (inspired by odoo)
4. Proxying fields from one doctype on another one (like contact details on another form/doctype… you can only have readonly fields, that are real table fields and not automatically updated when source doctype is edited…)
5. Conditional workflows based on fields
6. Ability to Automate workflows based on triggers

[rmehta]

Awesome! How about adding GitHub Issues and starting pull requests. Will be happy to pitch in when I can.

[almeidapaulopt]

Hi,

Here my ideas:

7. Doctype inheritance
8. Group by (with multi level) on edit tables (example be able to group by a field in item table of a quotation)
9. Add contrast in base theme
10. Enhance user experience
11. Multi doctype workflows (be able to design a process workflow for a company)

I know, some of this are really challenging.
I can detail better my ideas if you liked to.

[James_Robertson]

Those are all good ideas. I really like the one about reports. Having the ability to create custom reports in the platform with a “report builder” feature would be huge. Right now I am having to build reports externally in jasper reports and ms excel. I know if you are a “coder” you can create your own reports, but most administrators like me are not.

I also created a number of git issues awhile back that I would like to be considered

https://github.com/frappe/frappe/issues/3183

https://github.com/frappe/frappe/issues/2567

https://github.com/frappe/frappe/issues/2502

https://github.com/frappe/frappe/issues/2506

[James_Robertson]

I was looking over some git issues in the erpnext repo and I think they might be more frappe related. File security is an area that needs some attention as well.

https://github.com/frappe/erpnext/issues/9127

https://github.com/frappe/erpnext/issues/9014

[tmatteson]

At the framework level, one of the enhancements I’d like to see is a link docfield that can accommodate data that occurs in many-to-one, one-to-many and many-to-many types. The Frappe team has nailed the one-to-one link and being able to trigger on that opens up a lot of possibilities; this request is a superset of that.

[wale]

Reports Pleeeeaaasssseeeee!

The current report builder is nice but only works with a single table (DocType). We can build more useful and meaningful reports via sql queries and scripts but ONLY if we are not hosted on FrappeCloud. I think this is a very big disadvantage and probably one of the most significant drawbacks to hosting on FrappeCloud

Having a more dynamic report builder that can work with multiple tables and filters would make a world of difference!

Thanks

[LifeP]

Hierarchical user Permissions -
Possible solution →

@Pau_Rosello

I want to share my take on this

I mostly doing the same as you but using Redis as cache, improving permission performance by 100x more or less without too much hassle. I am managing a set of 14.000 territories with 4 different levels and it is working as of now

def generate_territory_cache():
conn = redis.from_url(frappe.local.conf.redis_cache)
prefix = frappe.conf.redis_territory + “_”
##Set a key in order to indicate that the cache has been initialized
conn.set(prefix + “cache”, 1)

top = frappe.get_list("Territory", fields=["name"], user="Administrator")
for item in top:
    conn.set(prefix + item.name, ";".join(get_all_children(item.name)))

def get_children_from_cache(territory):
##configure cache by site
conn = redis.from_url(frappe.local.conf.redis_cache)
prefix = frappe.conf.redis_territory + “_”

##If the cache is not initialized, we create it
if not conn.exists(prefix + "cache"):
    generate_territory_cache()

try:
    return conn.get(prefix + territory).decode("utf-8").split(";")
except AttributeError:
    generate_territory_cache()
    return get_all_children(territory)

def territory_query_conditions(user):
if user == “Administrator”:
return “”
else:
territory = frappe.db.get_value(“User”, user, [“territory”])
##with cache, improved by 100x
child_territories = get_children_from_cache(territory)
##without cache
##child_territories = get_all_children(territory)

    return u"""(territory  in ({territories}))""".format(
        territories='"' + '", "'.join(child_territories) + '"')