Thank you for the reply.
I have created around 60 documents but it is not displaying beyond 20 lists.
And I altered the code by not checking duplicate values but still same results.
@Bhargav_N In that case, how about you change the field to Autocomplete…
The code will need a small modification and everything will be fine…
How can that be achieved ? Should I have to change the field type ?
Should I have to delete all the document that i have created ?
Thank you.
Yes, from Select to Autocomplete.
No. The value of the field should be fetched normally, since the value of both Select and Autocomplete are stored as text in database.
The js code that you need to use is the following…
frappe.ui.form.on('Tool Setup and Program Control Plan', {
onload: function(frm) {
// Cache for setting_name options
frm._setting_names = {};
},
refresh: function(frm) {
frm.trigger('load_process_names');
},
component: function(frm) {
frm.trigger('load_process_names');
},
load_process_names: function(frm) {
var select = frm.get_field('setting_name'),
val = frm.doc.setting_name || null,
// The select list options with the default first option
list = [{label: __('Select Process...'), value: ''}];
// If the component field is empty, then empty the select list
if (!frm.doc.component) {
// Adding the old value of setting_name (if there is any) to the select list
if (val) list.push({label: val, value: val});
// Adding the list of options to the select field
select.set_data(list);
// Selecting the old value of setting_name if there is any
if (val) frm.set_value('setting_name', val);
return;
}
// A function to add the list of options to the select field
var setOptions = function(optList) {
// Adding the list of process names to the select field
select.set_data(optList);
// Selecting the old value of setting_name if there is any
if (val) frm.set_value('setting_name', val);
};
// If cache exist, the get options from cache
if (frm._setting_names[frm.doc.component]) {
setOptions(frm._setting_names[frm.doc.component]);
return;
}
// Getting the process name values
frappe.db.get_list('Item Process Table', {
fields: ['pn'],
filters: {
parent: frm.doc.component,
parenttype: 'Item Process List',
parentfield: 'ipt'
}
}).then(function(data) {
// Sorting the process name from A-Z
data = frappe.utils.sort(data, 'pn');
// Making sure that the list of process name doesn't have duplicate values
let check = [];
data.forEach(function(v) {
if (check.indexOf(v.pn) < 0) {
check.push(v.pn);
list.push({label: v.pn, value: v.pn});
}
});
// Storing list in Cache
frm._setting_names[frm.doc.component] = list;
setOptions(list);
});
}
});
There is no field type called AutoComplete in ERP next version 13
In frappe v13 it exists. Maybe it doesn’t exist in the field type select field but it’s there…
Can I know the name of the field that I have to change?
Sorry, not name. Field type?
@Bhargav_N The fieldtype should be changed to Autocomplete…
In frappe v14, this fieldtype exists, but not v13…
So if you are using v13 then I should find another solution for you…
@Bhargav_N How about we give Select fieldtype another chance…
Because I found out that the 20 limit is set by get_list method so below I set the limit to 100…
frappe.ui.form.on('Tool Setup and Program Control Plan', {
onload: function(frm) {
// Cache for setting_name options
frm._setting_names = {};
},
refresh: function(frm) {
frm.trigger('load_process_names');
},
component: function(frm) {
frm.trigger('load_process_names');
},
load_process_names: function(frm) {
var select = frm.get_field('setting_name'),
val = frm.doc.setting_name || null,
// The select list options with the default first option
list = [{label: __('Select Process...'), value: ''}];
// If the component field is empty, then empty the select list
if (!frm.doc.component) {
// Adding the old value of setting_name (if there is any) to the select list
if (val) list.push({label: val, value: val});
// Adding the list of options to the select field
select.df.options = list;
// Selecting the old value of setting_name if there is any
select.set_options(val);
return;
}
// A function to add the list of options to the select field
var setOptions = function(optList) {
// Adding the list of process names to the select field
select.df.options = list;
// Selecting the old value of setting_name if there is any
select.set_options(val);
};
// If cache exist, the get options from cache
if (frm._setting_names[frm.doc.component]) {
setOptions(frm._setting_names[frm.doc.component]);
return;
}
// Getting the process name values
frappe.db.get_list('Item Process Table', {
fields: ['pn'],
filters: {
parent: frm.doc.component,
parenttype: 'Item Process List',
parentfield: 'ipt'
},
// The number of rows to get
limit: 100,
}).then(function(data) {
// Sorting the process name from A-Z
data = frappe.utils.sort(data, 'pn');
// Making sure that the list of process name doesn't have duplicate values
let check = [];
data.forEach(function(v) {
if (check.indexOf(v.pn) < 0) {
check.push(v.pn);
list.push({label: v.pn, value: v.pn});
}
});
// Storing list in Cache
frm._setting_names[frm.doc.component] = list;
setOptions(list);
});
}
});
Thanks a lot I will check and share you the result.
Same, it is listing only 20
Thanks a lot its working.
@Bhargav_N So it’s working without the 20 options limit?
If so, that’s great…
And are you ok with the 100 options limit?
Yes! Thanks a lot
1 Like
‘frappe.db.get_list’ is not allowing to fetch details from child table of the doctype except for Administrator. Is there any method via script that permission is passed to certain user roles?
(its working fine of admin but not working any users after upgrading to version 14 )
Thanks in advance.
@Bhargav_N Can you add a server script (Python) or not?
If you can, then you can get the child table data from a custom whitelist method using frappe.call…
import frappe
@frappe.whitelist()
def get_item_process_list(component, limit = 100):
if not component or not isinstance(component, str):
return []
limit = limit if limit and isinstance(limit, int) else 100
try:
data = frappe.get_all(
"Item Process Table",
fields=["pn"],
filters={
"parent": component,
"parenttype": "Item Process List",
"parentfield": "ipt",
},
limit_page_length=limit,
)
return data if isinstance(data, list) else []
except Exception:
return []
Thanks a lot for support.
I saved this script in ‘Server Script’ and script type as: ‘Permission query’ and I’m Getting below error.
App Versions
{
"erpnext": "14.10.1",
"frappe": "14.19.1",
"hrms": "1.0.0",
"india_compliance": "14.0.5",
"payments": "0.0.1"
}
Route
List/Inspection Report/List
Trackeback
Traceback (most recent call last):
File "apps/frappe/frappe/app.py", line 69, in application
response = frappe.api.handle()
File "apps/frappe/frappe/api.py", line 54, in handle
return frappe.handler.handle()
File "apps/frappe/frappe/handler.py", line 45, in handle
data = execute_cmd(cmd)
File "apps/frappe/frappe/handler.py", line 83, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File "apps/frappe/frappe/__init__.py", line 1590, in call
return fn(*args, **newargs)
File "apps/frappe/frappe/__init__.py", line 784, in wrapper_fn
retval = fn(*args, **get_newargs(fn, kwargs))
File "apps/frappe/frappe/desk/reportview.py", line 29, in get
data = compress(execute(**args), args=args)
File "apps/frappe/frappe/desk/reportview.py", line 65, in execute
return DatabaseQuery(doctype).execute(*args, **kwargs)
File "apps/frappe/frappe/model/db_query.py", line 172, in execute
result = self.build_and_run()
File "apps/frappe/frappe/model/db_query.py", line 187, in build_and_run
args = self.prepare_args()
File "apps/frappe/frappe/model/db_query.py", line 226, in prepare_args
self.build_conditions()
File "apps/frappe/frappe/model/db_query.py", line 535, in build_conditions
match_conditions = self.build_match_conditions()
File "apps/frappe/frappe/model/db_query.py", line 783, in build_match_conditions
doctype_conditions = self.get_permission_query_conditions()
File "apps/frappe/frappe/model/db_query.py", line 873, in get_permission_query_conditions
condition = script.get_permission_query_conditions(self.user)
File "apps/frappe/frappe/core/doctype/server_script/server_script.py", line 121, in get_permission_query_conditions
safe_exec(self.script, None, locals)
File "apps/frappe/frappe/utils/safe_exec.py", line 72, in safe_exec
exec(compile_restricted(script), exec_globals, _locals) # pylint: disable=exec-used
File "<unknown>", line 1, in <module>
ImportError: __import__ not found
Request Data
{
"type": "POST",
"args": {
"doctype": "Inspection Report",
"fields": "[\"`tabInspection Report`.`name`\",\"`tabInspection Report`.`owner`\",\"`tabInspection Report`.`creation`\",\"`tabInspection Report`.`modified`\",\"`tabInspection Report`.`modified_by`\",\"`tabInspection Report`.`_user_tags`\",\"`tabInspection Report`.`_comments`\",\"`tabInspection Report`.`_assign`\",\"`tabInspection Report`.`_liked_by`\",\"`tabInspection Report`.`docstatus`\",\"`tabInspection Report`.`idx`\",\"`tabInspection Report`.`item_code`\",\"`tabInspection Report`.`process_name`\",\"`tabInspection Report`.`cb`\"]",
"filters": "[]",
"order_by": "`tabInspection Report`.`modified` desc",
"start": 0,
"page_length": 20,
"view": "List",
"group_by": "`tabInspection Report`.`name`",
"with_comment_count": true
},
"freeze": false,
"freeze_message": "Loading...",
"headers": {},
"error_handlers": {},
"url": "/api/method/frappe.desk.reportview.get"
}
Response Data
{
"exception": "ImportError: __import__ not found"
}