Retrieve list of documents in Lotus Notes database

Retrieve list of documents in Lotus Notes database

This task use java to retrieve list of documents in Lotus Notes database.

Filter documents with aliases

1. Create getDocuments method as following
2. Call getDocuments method as following

Call method

---

try {
    String idfile = "path to your id file";
    String password = "your password";
    // <server>!!<filepath> | <filepath>
    String filename = "path to database file";
    String form = "your form";
    String filter = "your document filter";
    NotesThread.sinitThread();
    Session s = NotesFactory.createSessionWithFullAccess();
    s.createRegistration().switchToID(idfile, password);
    Database d = openDatabase(s, filename);
    DocumentCollection dc = getDocuments(d, form, filter);
    logger.info(dc.getCount());
    d.recycle();
    s.recycle();
} catch (Exception e) {
    logger.info("", e);
}
    

formattedraw

1	try {
2	String idfile = "path to your id file";
3	String password = "your password";
4	// <server>!!<filepath> | <filepath>
5	String filename = "path to database file";
6	String form = "your form";
7	String filter = "your document filter";
8	NotesThread.sinitThread();
9	Session s = NotesFactory.createSessionWithFullAccess();
10	s.createRegistration().switchToID(idfile, password);
11	Database d = openDatabase(s, filename);
12	DocumentCollection dc = getDocuments(d, form, filter);
13	logger.info(dc.getCount());
14	d.recycle();
15	s.recycle();
16	} catch (Exception e) {
17	logger.info("", e);
18	}

try {
    String idfile = "path to your id file";
    String password = "your password";
    // <server>!!<filepath> | <filepath>
    String filename = "path to database file";
    String form = "your form";
    String filter = "your document filter";
    NotesThread.sinitThread();
    Session s = NotesFactory.createSessionWithFullAccess();
    s.createRegistration().switchToID(idfile, password);
    Database d = openDatabase(s, filename);
    DocumentCollection dc = getDocuments(d, form, filter);
    logger.info(dc.getCount());
    d.recycle();
    s.recycle();
} catch (Exception e) {
    logger.info("", e);
}

getDocuments method

---

public DocumentCollection getDocuments(Database database, String form, String filter) throws Exception {
    if (filter.trim().length() == 0) {
        return database.search(grabFormCond(database, form));
    } else {
        return database.search(grabFormCond(database, form) + " & (" + filter + ")");
    }  
}  
  
private String grabFormCond(Database database, String form) throws Exception {
    String target = "((Form='" + form + "')";
    try {
        Vector aliases = database.getForm(form).getAliases();
        for (int i = 0; i < aliases.size(); i++) {
            target += "|(Form='" + aliases.get(i) + "')";
        }
    } catch (Exception e) {
        logger.error("", e);
    }
    return target + ")";
}
    

formattedraw

1	public DocumentCollection getDocuments(Database database, String form, String filter) throws Exception {
2	if (filter.trim().length() == 0) {
3	return database.search(grabFormCond(database, form));
4	} else {
5	return database.search(grabFormCond(database, form) + " & (" + filter + ")");
6	}
7	}
8
9	private String grabFormCond(Database database, String form) throws Exception {
10	String target = "((Form='" + form + "')";
11	try {
12	Vector aliases = database.getForm(form).getAliases();
13	for (int i = 0; i < aliases.size(); i++) {
14	target += "|(Form='" + aliases.get(i) + "')";
15	}
16	} catch (Exception e) {
17	logger.error("", e);
18	}
19	return target + ")";
20	}

public DocumentCollection getDocuments(Database database, String form, String filter) throws Exception {
    if (filter.trim().length() == 0) {
        return database.search(grabFormCond(database, form));
    } else {
        return database.search(grabFormCond(database, form) + " & (" + filter + ")");
    }  
}  
  
private String grabFormCond(Database database, String form) throws Exception {
    String target = "((Form='" + form + "')";
    try {
        Vector aliases = database.getForm(form).getAliases();
        for (int i = 0; i < aliases.size(); i++) {
            target += "|(Form='" + aliases.get(i) + "')";
        }
    } catch (Exception e) {
        logger.error("", e);
    }
    return target + ")";
}

Lotus Notes Java