latest posts

Okay, but in the old version it was possible to see it in the designer. Was very helpful for bugfixing.

Thanks!
Klaus

Okay, now I understand what you're asking :)
The second version from the designer studio will not show you the information because you don't have the data saved that you have in the first screenshot.

You have to assume that the action you are performing dynamically retrieves this data during the execution of the action, so it will work well for you on the form - the designer will not substitute the data you expect, but the action will retrieve the data during execution - test it :)

Hi Slawek,

depending on what you want to achieve another option is to take a look at the
dbo.UsersCals
dbo.SingleSolutionCals

in the Config database.

The UsersCals contain the different license types.
I don't have in mind which integer value of the column UCL_LicenseType maps to which type.

Best regards,
Daniel

Hi Krystian,

thank you for the answer.
In case it is an integer value it should work without quotes, right?
What do you mean with "you don't have the first attribute"?

Here two pictures that show it a bit better:
pic 1: the item has been saved, the values are visible in the query editor
pic 2: there are values in the field, but the instance has not been saved since; the field is empty in the query

Kind regards,
Klaus

Karolina, create a text business rule and then insert it into JSON - grid.

Send us a screenshot and we'll explain it if necessary.

Hi,
Do you have an error?
You can use unsaved data, but it must be in quotes '{Field}', and you don't have the first attribute - maybe that's causing the error?

Hi
You don't need to install drivers on the WEBCON server if you want to connect to the ORACLE database. Make the configuration in data sources -> Connections -> Oracle Database -> enter the connection details for the Oracle instance and account.
Remember to ensure that the IP network connection and port are accessible between the WEBCON server and ORACLE.

Hi Sławek,
I've been trying to find the place that gives same numbers as reports in designer studio, and after checking i think every table which could have it I've connected with Webcon via support.
There is and API endpoint which is used by Designer Studio to fetch info about used licenses: /studio/db/1/getsimplelicencereport, you can use the same endpoint.

1. Register API Application with any scope (Admin.Licenses.Read is suggested, but in that case it doesn't really matter).
2. Assing that API user Administrator Privileges on Studio
3. Login to the API via OAuth
4. Call /studio/db/1/getsimplelicencereport endpoint.

This will return you a json structure as in attached file.

It doesn't answer directly your question, as this is not in the database, but that's how you get same numbers as those displayed on reports tab in designer studio :)

Hi,
How can I add a static value to JSON - grid? I don't want to add Source field. I have a value that will not change. Furthermore, I wolud like to put it in there the easiest way possible. Pls help :)

Hi,
check the view [V_ADMIN_Licenses].

Regards,
Jacek