/** CaseID 65862, 67863, 67862, 67861 Create, edit, execute, delete query in Advanced search */
@Test
public void test03_04_05_CreateQueryInAdvancedSearch() {
String node1 = "test03Create";
String nameQuery = "Query test03";
String query =
"select * from nt:base where jcr:path like '/sites/%' order by exo:dateCreated DESC";
String edit =
"select * from nt:base where jcr:primaryType like 'nt:file' order by exo:dateCreated DESC";
By bNode1 = By.xpath(siteExp.ELEMENT_SE_NODE.replace("{$node}", node1));
info("Create, edit, execute, delete query in Advanced search");
actBar.goToAddNewContent();
cTemplate.createNewFile(node1, node1, node1);
// CaseID 65862 - Create query
aSearch.goToNewQuery();
aSearch.addQuery(nameQuery, "SQL", query);
// CaseID 67863 - Edit query
aSearch.goToEditQuery(nameQuery);
aSearch.editQuery("", "SQL", edit);
// CaseID 67862 execute query
aSearch.executeQuery(nameQuery);
waitForAndGetElement(aSearch.ELEMENT_SEARCH_RESULT_TEXT.replace("${result}", node1));
btn.closeWindow();
// CaseID 67861 - Delete query
aSearch.deleteQuery(nameQuery);
// Delete data
click(siteExp.ELEMENT_SIDEBAR_FILE_EXPLORER);
cMenu.deleteDocument(bNode1);
}
/** CaseID 85825 Advanced search Step 1: Advanced search */
@Test
public void test01_AdvancedSearch() {
String node1 = "test01AdvancedSearch";
String des = "test01 desc";
By bNode1 = By.xpath(siteExp.ELEMENT_SE_NODE.replace("{$node}", node1));
info("Advanced search");
// Create document
actBar.goToAddNewContent();
cTemplate.createNewFile(node1, node1, node1, des);
// Advance search
aSearch.goToAdvancedSearch();
click(aSearch.ELEMENT_CONSTRAINT_FORM);
aSearch.selectDocumentType("nt:file");
aSearch.searchContent(node1);
waitForAndGetElement(aSearch.ELEMENT_SEARCH_RESULT_TEXT.replace("${result}", node1));
btn.closeWindow();
// Delete data
click(siteExp.ELEMENT_SIDEBAR_FILE_EXPLORER);
cMenu.deleteDocument(bNode1);
}