Yes, you can. You can use the available sorter property available on the List. It lets you specify all the required details. For e.g. −I have specified the employee collection to be sorted on the basis of the name of the employee and specified that the sorting should be in ... Read More

It’s a very basic operation that you do in database. You can try using DateAdd function available and use the date overload of the function. You need to pass one date as negative so in actual the difference is calculatedSELECT DATEADD(d, -[dateTwo], [dateOne]) AS 'Difference in Dates' FROM [TABLE]Here‘d’ refers ... Read More

Yes, it is  possible to use a view in Business one client and you can use it too. Please find below a sample format that you should be using to query the view in business one environment −SELECT FROM [dbo].[]I have done the same and it is working for me.Read More

You can try and create a URL in your code which you can read from config or XML.Here is a sample code snippet −String uri = // Can read from config or anywhere string odQuery = "?$format=json" var req = WebRequest.Create(uri+"/"+ odQuery); req.Method = "GET"; var streamreader = new StreamReader(stream: ... Read More

There are different Image format options available:

The SAP HANA cockpit for offline administration is accessible at https://:1129/lmsl/hdbcockpit//index.html or http://:1128/lmsl/hdbcockpit//index.html. You can also navigate to the SAP HANA cockpit for offline administration from the standard SAP HANA cockpit.With use of SAP HANA cockpit for offline administration, it displays content as tiles that function as entry points to individual applications.Read More

When you open SAP HANA Cockpit for offline administration, following tiles are available:

You can also stop HANA system by setting date and time and this comes under Soft stop.In case you don’t shut down the system before the specified timeout, it is shut down forcefully.

Stop...The service is stopped normally and then typically restarted.Kill...The service is stopped immediately and then typically restarted.

In Services tab under Landscape, you can right click on any service name and select Start Missing Service. This service activates any inactive service in your HANA system.