Forum Index

No notifications
Notifications

Favorites

No favorites found
Practical Exercises Support Q&A
KnowledgeKube Training > Practical Exercises Support > Problem with DB connection View modes: 
User avatar
Member
Member
Ivana Rajda - 29/05/2019 08:22:38
   
RE:Problem with DB connection
Hi Keiran,
Harry mentioned maybe we can try to integrate our Solar Panel Case Study with Sandbox but we don't know what exactly he meant by that.
Thanks,
Ivana Rajda

User avatar
KnowledgeKube Staff
KnowledgeKube Staff
keiran.martin - 28/05/2019 08:15:38
   
RE:Problem with DB connection
Hi Milica,

A simple way of getting a count of the rows is to use the GetDatasourceRow() expression:
NumberOfResults:=GetDataSourceRow("string DatasourceName","string FilterName","Boolean returnRowCount","Boolean refresh");
set the third parameter to
"True"
to return the number of results for the specified filter.

Could you please provide more information on what you are trying to do with Sandbox integrations?

Thanks

Keiran

User avatar
Valued member
Valued member
Milica Milin - 23/05/2019 15:50:38
   
RE:Problem with DB connection
Hi Keiran,

There was a little misunderstanding, we found out how to save the data in database, but we don't know how to count the number of rows in the DB, to be more specific, we find a way how to calculate that, but we don't know how to do that with just one function. Also, can you help us with the sandbox integrations, if you can sent us some steps how to do that?

Thanks,
Milica Milin

User avatar
KnowledgeKube Staff
KnowledgeKube Staff
keiran.martin - 22/05/2019 14:18:42
   
RE:Problem with DB connection
Hi Milica,

To get rows of data into the data designer the best way is to use the write data function Writing away data

With regards to Do not accept default response there is currently a bug with the validation of this field type. You can work around this by using a validator expression to validate the response. Creating a Validator

Let me know if you need anymore help

Thanks

Keiran

User avatar
Valued member
Valued member
Milica Milin - 16/05/2019 12:07:23
   
RE:Problem with DB connection
Hi Keiran,

Can you show us how to get a number of rows into the data table, we are connected to the data base through the data designer? We also have an issue with the multiple choice question, when we select some response to be the default and we check option 'Do not accept default response if this is mandatory question' , we can still save that default response in DB. Do you have a suggestion on how to set this?

Thanks,
Milica

User avatar
Valued member
Valued member
Milica Milin - 15/05/2019 12:25:27
   
RE:Problem with DB connection
Hi Keiran,

Thanks for this response. We've looked at the Data Designer Training and have managed to have a play with the tools. We are looking forward to receiving the requirements doc from your side so that we can finally build you something.

Thanks,
Milica

User avatar
KnowledgeKube Staff
KnowledgeKube Staff
keiran.martin - 14/05/2019 14:16:59
   
RE:Problem with DB connection
Hi Milica,

Unfortunately you can not currently edit a property type, this functionality is going to be released in the next version of the platform. We anticipate this to be in the next few weeks. In the meantime you can access details about the data designer via the training site Data Designer Training

Thanks

Keiran

User avatar
Valued member
Valued member
Milica Milin - 14/05/2019 13:43:11
   
RE:Problem with DB connection
Hi Keiran,

We used the data designer, we included tables and worked with them, but we have one more question. Is it possible to edit the property type without deleting the property and creating a new one? Do you have some documentation about working with the data designer?

Thanks,
Milica

User avatar
KnowledgeKube Staff
KnowledgeKube Staff
keiran.martin - 07/05/2019 08:44:24
   
RE:Problem with DB connection
Hi Milica,

Was planning on discussing as part of our planned meeting on Thursday.

Thanks

Keiran

User avatar
Valued member
Valued member
Milica Milin - 07/05/2019 08:40:14
   
RE:Problem with DB connection
Hi Keiran,
Do you still want to plan a short call early this week about our DB issue or will we include it in the planned meeting on Thursday?

Thanks,
Milica

1 2
RSS Feed