New idea

ISheet Advance search date and time

Hi,

 I am trying to do advance date time search on the HighQ System-generated field which is a Modified date column which has a date format DD MMM YYYY 

{
    "data": {
        "column": [{
                "attributecolumnid": "9584", 
                "rawdata": {
                         "fromdate": "15 Nov 2022 16:20"
                          
                }
            }
       

    }
}

The search works only taking the date and not the time.  Note that the time I search is 16:20 which is greater than the response which is 16:17 . But if I change the date to 16 Nov then below data is not displayed as there is no dates greater than 16 Nov. So the date part works not the time stamp

 

{

                            "sequence": "4",

                            "attributecolumnid": "9584",

                            "displaydata": {

                                "value": "15 Nov 2022 16:17"

                            },

                            "rawdata": {

                                "date": "2022-11-15",

                                "time": "16:17:29"

                            }

                        }

Even the advance search with 

"date":"string",

"time","string"  

 does not work.

I am thinking it could be setup issue on the  HighQ System-generated columns date format

Question: How to setup or modify the System-generated columns date format from DD MMM YYYY to DD MMM YYYY HH:MM:SS

]]>
Balamurali Bheeman

  • Balamurali Bheeman, it is not a setup issue. The two system-generated date fields (Created Date and Modified Date), whilst capturing date and time, can only be searched by the date component. The isheet search API mirrors the functionality of the Collaborate (website) Advanced Search, where you can only search by dates from and to.