Home / Tag Archives: Information Design Tool

Tag Archives: Information Design Tool

Tech Tip: DATETIME field format – Dealing with Milliseconds

InfoSol Blog Tech Tip

Tip: Error found at 00 Trick: Truncating datetime to seconds We recently worked with a customer to provide a solution to a datetime field in their PI SQL database (OSI) that was returning a SQL parsing error when using it in a query filter.  Specifically, the error stated “Error found ...

Read More »

Tech Tip: How to Document IDT Universe Information

InfoSol Blog Tech Tip

Tip: How to Document IDT Universe information Trick: Use Save as One of the features of IDT is to document all available setups that were performed on the business layer and data foundation of a .unx universe. In our example, we are going to document E-fashion Universe’s Business Layer. Prerequisites: ...

Read More »