+14
I am trying to create an External Search URL. I have no problem with parameters except the date parameter. I have tried the link below. They did not work. Results look random. But when I erase the date parameter. The result comes true. How can I do it?
| ifsapf:tbwLaborOperationHistory?EXTERNAL_SEARCH=WORK_CENTER_NO=D0011&DATED=04/01/2021 |
| ifsapf:tbwLaborOperationHistory?EXTERNAL_SEARCH=WORK_CENTER_NO=D0011&DATED=04%2F01%2F2021 |
+7
Hi
Please use date type in one of the below format.
YYYY-MM-DD
YYYY-MM-DD-HH24:MI:SS
If you are using IFS Application 9 UPD 7 or lower version you might need to upgrade the binary level as well.
Thanks and Regards,
Avindu Hendawitharana
+14
Hi
Thank you. But it didn’t work.
Regards,
Hasan
+7
Hi
I had further checked and found that the data in the DATED column is stored in Date time format. So you want the correct data you might need to input detail with timestamp as well.
For me below executed without any issue.
ifsapf:tbwLaborOperationHistory?EXTERNAL_SEARCH=DATED=2011-10-04-15:42:26
But it will not be a practical solution. Is there any other date column you can consider for the query like Transaction_date or date_applied. They only contain date values in the DB level and the search works without issue.
In above case you need to use below format
ifsapf:tbwLaborOperationHistory?EXTERNAL_SEARCH=DATE_APPLIED=20111004
Thanks and Regards,
Avindu Hendawitharana
+14
The link throwed an error. If it is work on your app. I think there should be problem with region settings. Can you send your region settings?
+7
Hi
Please find the regional settings as below.
Thanks and Regards,
Avindu Hendawitharana
+14
Regards,
Hasan
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.