How to Get List of Documents Using List of Document Names?

1

In javascript I have a list of document names for a known doctype. I want to do db.get_list() to fetch all documents matching my list of document names.

How is this done?

2

You can use this as an example.

frappe.call({
  method: 'frappe.client.get_list',
  async: false,
  args: {
      'doctype': 'Purchase Taxes and Charges',
      'parent': 'Purchase Taxes and Charges Template',
      'filters': {
          'parent': tax_template,
          'parenttype': 'Purchase Taxes and Charges Template'
      },
      'fields': [
          'add_deduct_tax',
          'included_in_print_rate',
          'rate',
          'account_head',
          'description'
      ]
  },
  callback: function(r) {

  }
});
3

I’m not sure you understood my issue.

Assume I have a list of names for documents of type ‘Purchase Taxes and Charges’. I want to retrieve all of the documents with those names.

How do I do that?

4

You may want this.

frappe.get_list('Purchase Taxes and Charges', {'name': document_name});
5

Create a server script with a type of API where the response is the data that you want
then call it on your client script via frappe.call().

6 
const doc_list = await frappe.db.get_list("Item", {
    fields: ["item_group", "item_name"],
    filters: {
        "name": ["in", ["itemname1", "itemname2"]]
    }
})

This essentially converts to backend SQL query:

select item_group, item_name 
from `tabItem` 
where name in ("itemname1", "itemname2") 
--- + some permission checking code

get_list only gives you fields on that doc, if you want full doc objects use get_doc

2 Likes
7

Your Try like this also

image
image1113×650 51.7 KB

this is the output while print

image
image1201×480 41.1 KB

this is list

image
image1133×405 33.6 KB

8

image
image1159×561 49.5 KB

1 Like
9

try frappe.db.get_value or get_doc as per use case

docList = ['Input GST Out-state','Input GST In-state']
for i in docList:
    list_taxes = frappe.db.get_value('Purchase Taxes and Charges Template', i, 'name')
    frappe.msgprint(list_taxes)
10

@ankush

Thank you!

This is exactly what I needed. There aren’t any documented get_list examples demonstrating the use of sql ‘in’ or even passing an array of values. It’s good to see this is fully supported.

2 Likes