• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
  • New Query Add Filter

    Hello Sri, Poorinma,

    I downloaded OS 1.0.1 from the installable zip file. I tried now to use the query/advanced query features and I have some questions:

    -So I could use the simple query, but I cannot save it? Is this how it is set up?

    -When I click New query, there is an Add Filter, in the demo OS, it has the following Filters:

    Collection Protocol
    Participant
    Specimen Collection Group
    Specimen
    Order
    Shipping

    My OS copy does not have any Filter under the Add Filter Section. What do I need to do to add those Filters?

    Thanks

    Nadia

    Hello @Nan_Halabi

    1. Yes, at present there is no option to save simple queries. (Since they are simple, they can be recreated easily when needed :P)

    2. It seems post deployment, you have not run post_upgrade target. Given below are instructions to get query forms/entities below Add Filter

    Pre-requisite: OpenSpecimen should be running

    2.1 If you are deploying from source

    ant -f deploy.xml post_upgrade -Dusername=

    2.2 If you are deploying from install zip

    ant post_upgrade -Dusername=

    Let us know how it goes.

    Thanks.

    We had the same problem with the missing filters and running the post_upgrade ant target worked.

    Hello Bob, Vinayak,

    Thanks a bunch for your responses. I will try that.

    Regards

    Nadia

    Hello Bob, Vinayak

    I run the post ant command listed above and I started Jboss, I still see no change. I redirected the output to a test file and I see build success, but there is an error message, not sure what it meant by Please verify the Correct URL is specified


    create_loggger_properties_file:
    [copy] Copying 1 file to C:\OpenSpecimen
    [echo] Create Form !!
    [java] ERROR execute, Encountered error performing the action
    [java] java.lang.RuntimeException: Please verify the Correct URL is specified & the server is running
    [java] at edu.common.dynamicextensions.utility.HTTPSConnection.getServletWriter(HTTPSConnection.java:200)
    [java] at edu.common.dynamicextensions.utility.HTTPSConnection.uploadFileToServer(HTTPSConnection.java:142)
    [java] at edu.common.dynamicextensions.client.AbstractClient.performAction(AbstractClient.java:89)
    [java] at edu.common.dynamicextensions.client.AbstractClient.execute(AbstractClient.java:72)
    [java] at edu.common.dynamicextensions.nui.client.CreateAQFormClient.main(CreateAQFormClient.java:26)
    [java] Caused by: java.net.ConnectException: Connection refused: connect
    [java] at java.net.PlainSocketImpl.socketConnect(Native Method)
    [java] at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
    [java] at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
    [java] at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
    [java] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
    [java] at java.net.Socket.connect(Socket.java:529)
    [java] at java.net.Socket.connect(Socket.java:478)
    [java] at sun.net.NetworkClient.doConnect(NetworkClient.java:163)
    [java] at sun.net.www.http.HttpClient.openServer(HttpClient.java:411)
    [java] at sun.net.www.http.HttpClient.openServer(HttpClient.java:525)
    [java] at sun.net.www.http.HttpClient.(HttpClient.java:208)
    [java] at sun.net.www.http.HttpClient.New(HttpClient.java:291)
    [java] at sun.net.www.http.HttpClient.New(HttpClient.java:310)
    [java] at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:987)
    [java] at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:923)
    [java] at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:841)
    [java] at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1031)
    [java] at edu.common.dynamicextensions.utility.HTTPSConnection.getServletWriter(HTTPSConnection.java:196)
    [java] … 4 more
    [java] Exception in thread “main” java.lang.RuntimeException: java.lang.RuntimeException: Please verify the Correct URL is specified & the server is running
    [java] at edu.common.dynamicextensions.client.AbstractClient.execute(AbstractClient.java:81)
    [java] at edu.common.dynamicextensions.nui.client.CreateAQFormClient.main(CreateAQFormClient.java:26)
    [java] Caused by: java.lang.RuntimeException: Please verify the Correct URL is specified & the server is running
    [java] at edu.common.dynamicextensions.utility.HTTPSConnection.getServletWriter(HTTPSConnection.java:200)
    [java] at edu.common.dynamicextensions.utility.HTTPSConnection.uploadFileToServer(HTTPSConnection.java:142)
    [java] at edu.common.dynamicextensions.client.AbstractClient.performAction(AbstractClient.java:89)
    [java] at edu.common.dynamicextensions.client.AbstractClient.execute(AbstractClient.java:72)
    [java] … 1 more
    [java] Caused by: java.net.ConnectException: Connection refused: connect

    Please advice.

    Thanks

    Nadia

    Unlike the deploy ant target, this one is supposed to be run with the JBoss server up and running. Was JBoss up when you ran it?

    Hello Bob

    Thanks for your response back. No Jboss was not up and running when I run the ant command.

    It is funny though, I run the ant command again (while Jboss was down) , and this time I could see the options under the Add Filter. But when I click on any one of the options, I see the following message: Loading form fields, Please wait for a moment. and then I do not see anything.

    Ok I will re-do it, then test it.

    Thanks

    Nadia

    Hello Bob,

    It worked, yeah! But I had to run the ant command twice, not sure why. First time, it did not show the options under the Add Filter in the New Query.

    Thanks for your help and tip.

    Regards

    Nadia