locked
display list of Received File For More Than 3 Days RRS feed

  • Question

  • User442781244 posted
     REGSQL = "select '<a href=""filetrack.aspx?fname='||chg_filename||'||"">'||chg_filename||'</a>' as ""File No"",file_subject as ""File Subject"",(select RECEIPT_DATE from FILETRANS where filemaster.file_serial_no = FILETRANS.file_serial and filemaster.file_year=FILETRANS.file_year and filetrans.RECEIPT_DATE between trunc(sysdate-6)+(15/24) and least( trunc(sysdate)+(15/24), sysdate) and rownum=1) as ""Received Date"",(select department_name from departments where department_code=filemaster.department_code and rownum=1) as ""Dept"",(select section_name from sections where section_cd=filemaster.section_code and rownum=1 and dept_cd=filemaster.department_code) as ""Section"" from filemaster " End Select
    hi masters...i have this query in my application. I am not getting anyoutput. my work is to display list of Received File For More Than 3 Days
    plz suggest modification in that code.
    i have 1 table name filemaster and it has colum
    DEPARTMENT_CODE
    SECTION_CODE
    FILE_SERIAL_NO
    FILE_YEAR
    FILE_SUBJECT
    CREATION_DATE
    OTHER_DETAILS
    USER_CODE
    CHG_FILENAME
    ID
    LEDIT
    2nd table name FILETRANS and has columns
    FILE_LETTER
    FILE_DEPARTMENT
    FILE_SECTION
    FILE_YEAR
    FILE_SERIAL
    LETTER_OFFICE_CODE
    LETTER_DIARY_NO
    PREV_OFFICE_CODE
    PREV_OFFICE_DIARY_NO
    DIARY_NO
    OFFICE_CODE
    RECEIPT_DATE
    RECEIPT_TIME
    RECEIPT_FLAG
    TRANSIT_FLAG
    NEXT_OFFICE_CODE
    DESP_DATE
    DESP_TIME
    DESP_FLAG
    NEXT_OFFICE_RECEIPT_STATUS
    RECEIPT_DATE_TIME
    DESPATCH_DATE_TIME
    IS_NEW
    AD_FILE_CODE
    NS_FILE_CODE
    DELETED_REC
    R_USER_CODE
    ID
    LEDIT
    REMARKS
    LETTER_FILEID
    PUTUP_DATE
    FILEID
    COM
    Thursday, August 1, 2013 11:04 PM

All replies

  • User197322208 posted

    i have this query in my application. I am not getting anyoutput.

    Do you have any error?
    Do you have any data that satisfies the query criteria?

    Friday, August 2, 2013 1:28 AM
  • User442781244 posted

    my work is to data : Received File For More Than 3 Days. query is not givng any result. plz help

    Friday, August 2, 2013 1:48 AM
  • User442781244 posted

    plz see my post again. i ve modifed some things .plz help

    Friday, August 2, 2013 2:21 AM
  • User197322208 posted

    you have put all kind of columns there, but you did not answer to the question: there are some data that satisfies the criteria?

    Friday, August 2, 2013 2:24 AM
  • User442781244 posted

    yes there are some data.....

    Friday, August 2, 2013 2:26 AM
  • User442781244 posted

    if u need anymore information then plz let me know.plz help

    Friday, August 2, 2013 2:53 AM
  • User197322208 posted

    there are some data.....

    How do you know that the data satisfies the search criteria?

    Friday, August 2, 2013 7:39 AM
  • User442781244 posted

    from requirement you can understand what i want to acheive. u can see above query. so plz assist.u ve tables and query. plz assist in modification.

    Friday, August 2, 2013 10:14 AM
  • User442781244 posted

    if you need  any more information then plz let me know.

    Friday, August 2, 2013 10:20 AM
  • User197322208 posted

    1.

    If you need  any more information then plz let me know.

    Yes, you did not answer my question:

    How do you know that the data satisfies the search criteria?

    2.

     Your initial question was:

    i have this query in my application. I am not getting anyoutput.

    Now it is:

    from requirement you can understand what i want to acheive. u can see above query. so plz assist.u ve tables and query. plz assist in modification.

    you want to make the query for you. This is a different thing.  I do not solve homework. Nor programmer tasks. I do help with answers - but the work you must do yourself. Otherwise, it is my work - and I take money for this.

    Saturday, August 3, 2013 1:40 AM