I am trying to change the data source of a BIRT report (e.g. rptdesign file used by assyst Report Wizard) from our on premise database to the cloud Saas Database, I was using Database URL “jdbc:sqlserver://W-99999-D5E:1523;databaseName=PDRPSQGCG;”and the connection was working fine.But now I was told to use “jdbc:sqlserver://cac-99301-axios.secondary.database.windows.net:1433;database=99301;” as an example but it fails the connection. I tried various combinations but still no success.IFS Support was not able to help other than we were able to test the connection tot he database using SSMS so all indication points to the BIST data source to be incorrectly specified.Does anyone have the proper info to setup the the connection?
I trying to extract the value of a custom field with property type “l: system lookup”.The lookup_VAL_ID does not seem to match anything in the jptsys_web_lkup_dataAlso what is weird is we are on 11.6.3 and table jptsys_web_cust_prop is not supposed to be removed 11.5 but it is there and it is populated with something!!!here is the SQL that I use to get the “Lookup_val_ID”:(select max(convert(varchar,jc.LOOKUP_VAL_ID)) from jptsys_web_cust_prop_cont (NOLOCK) jc left join jptsys_web_cust_prop (NOLOCK) j on jc.jptsys_web_cust_prop_id=j.jptsys_web_cust_prop_id left join jptsys_web_lkup_data (nolock) drop_dwn_val on drop_dwn_val.jptsys_web_lkup_data_id = jc.LOOKUP_VAL_ID left join jptsys_web_lkup (NOLOCK) lkup on drop_dwn_val.jptsys_web_lkup_id = lkup.jptsys_web_lkup_id where i.incident_id=jc.entity_id and j.jptsys_web_cust_prop_sc='REGION' ) AS "Region / Région",
Trying to get a discontinued item.but when I use GET "https://????/assystREST/v2/items?shortCode=abcitem” it fails if the item “abcitem” is discontinued but succeed if it is not.
I am trying to write a report that extract a custom field with custom property type of ‘l’ which is no longer listed but was part of 5.5 for system fields.In any case it fills a “LOOKUP VALUE ID” which I am trying to look up but the data schema only say“The value of a Custom System lookup field.Introduced in assyst10 SP5.5.” What table(s) are associated with custom System Lookup?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.