Search found 27 matches

by JHew
Mon Jul 03, 2023 8:43 am
Forum: General discussion and questions about Aware IM
Topic: Stored Procedure EXEC_SP: Internal error. Error converting data type nvarchar to int.
Replies: 4
Views: 4992

Re: Stored Procedure EXEC_SP: Internal error. Error converting data type nvarchar to int.

Do I have the wrong syntax? EXEC_SP 'usp_ForecastPIR' WITH '@PartNumber' =ForecastInput.PartNumber ,'@StartDate' = ForecastInput.StartDate , '@EndDate' = ForecastInput.EndDate , '@RunRate' = ForecastInput.RunRate , '@Frequency' = ForecastInput.Frequency , '@Reference' = ForecastInput.Reference , '@I...
by JHew
Thu Jun 29, 2023 11:05 am
Forum: General discussion and questions about Aware IM
Topic: Stored Procedure EXEC_SP: Internal error. Error converting data type nvarchar to int.
Replies: 4
Views: 4992

Stored Procedure EXEC_SP: Internal error. Error converting data type nvarchar to int.

I have a process calling a SP which looks like this: Process ENTER NEW ForecastInput USING Main EXC_SP_ForecastPIR Sub Process - EXC_SP_ForecastPIR EXEC_SP 'usp_ForecastPIR' WITH '@PartNumber' =ForecastInput.PartNumber ,'@StartDate' = ForecastInput.StartDate , '@EndDate' = ForecastInput.EndDate , '@...
by JHew
Fri Feb 03, 2023 1:10 pm
Forum: General discussion and questions about Aware IM
Topic: "Pre" filtering a query
Replies: 3
Views: 5397

Re: "Pre" filtering a query

What would be the syntax for not null or is defined? I have a column where some records have a date and others are blanks, i'd like to pre filter out the blanks but i cant workout what the operator and value should be set to. var grid = widget; var ds=grid.dataSource; ds.filter( { logic: "and", filt...
by JHew
Tue Aug 16, 2022 7:34 am
Forum: General discussion and questions about Aware IM
Topic: Shift Data from one column to another within a Child BO
Replies: 4
Views: 1167

Re: Shift Data from one column to another within a Child BO

Thank you, its working perfectly now!

I did try something similar to this before, but I put 'IF SEARCH_COUNT > 0' at the beginning of the second process which made it not work.
by JHew
Mon Aug 15, 2022 1:09 pm
Forum: General discussion and questions about Aware IM
Topic: Shift Data from one column to another within a Child BO
Replies: 4
Views: 1167

Shift Data from one column to another within a Child BO

I have a parent and child business objects, LabourReviewProductCell (Parent) and LabourReviewAllocation (Child). In the Child BO users add records of people and then allocate X amount of hours for the next three weeks. This is set up by having three different columns to represent the current and nex...
by JHew
Thu Aug 04, 2022 11:50 am
Forum: General discussion and questions about Aware IM
Topic: Process not looping though all records
Replies: 1
Views: 723

Process not looping though all records

I have the following process that runs each morning to take the records from a SQL persisted database and transfer them to an AwareIM one. The database is around 2500 rows and has around 20 columns. In the past couple of week the process seems to be randomly stopping without updating all the records...
by JHew
Thu Jul 14, 2022 8:37 am
Forum: General discussion and questions about Aware IM
Topic: [Solved] Find records with the same identifier that exist the same BO and update the other records
Replies: 2
Views: 762

[Solved] Find records with the same identifier that exist the same BO and update the other records

I have a business object where users will change the dates of a field using inline editing within a query. Some of these records will also have related records in the same BO, which will also needed to be updated if a user makes a change. Whist these are related, they still need to act as individual...
by JHew
Tue Mar 01, 2022 10:34 am
Forum: General discussion and questions about Aware IM
Topic: Round down condition without using an IF?
Replies: 1
Views: 2310

Round down condition without using an IF?

I'm trying to create a piece of code which will define each three working days as a different period from the first date of each month given the current date as the input. This will need to be used in a process to assign a value to an attribute and will also need to be used to filter a query dynamic...
by JHew
Tue Feb 01, 2022 2:42 pm
Forum: General discussion and questions about Aware IM
Topic: Parent and Child BO 'Was Changed' Rule
Replies: 4
Views: 1756

Re: Parent and Child BO 'Was Changed' Rule

Thanks All. Jobens Solution worked as required.
by JHew
Mon Jan 31, 2022 11:59 am
Forum: General discussion and questions about Aware IM
Topic: Parent and Child BO 'Was Changed' Rule
Replies: 4
Views: 1756

Parent and Child BO 'Was Changed' Rule

I have made a parent BO and a child BO which both have a yes/no attribute called ‘Plan Slot’. I’m trying to make it so that If the user changes the Plan Slot value in the parent BO, it updates all instances of the child BO to the same value. I’ve tried using the below but had no luck. Can anyone tel...
by JHew
Tue May 11, 2021 12:19 pm
Forum: General discussion and questions about Aware IM
Topic: Snap into camera function on web browser
Replies: 6
Views: 3565

Re: Snap into camera function on web browser

Thanks, thats looks like exactly what we would need. How do we go about getting costings for this to be developed?
by JHew
Thu May 06, 2021 10:36 am
Forum: General discussion and questions about Aware IM
Topic: Snap into camera function on web browser
Replies: 6
Views: 3565

Re: Snap into camera function on web browser

On a Desktop, ideally we would be able to use an external webcam for the user to take pictures which would be saved directly into the form. A bit of context to what we are trying to achieve, we have a form called 'missing and damaged' which is linked to a customer order, when we receive the order fr...
by JHew
Wed May 05, 2021 7:09 pm
Forum: General discussion and questions about Aware IM
Topic: Snap into camera function on web browser
Replies: 6
Views: 3565

Snap into camera function on web browser

We have a requirement for users to be able to quickly take multiple pictures and add them to forms. I can see there is an option to do this via creating a mobile app but this is not the way we want to go. Is there any way to get this working on a browser based application?
by JHew
Mon Mar 08, 2021 3:00 pm
Forum: General discussion and questions about Aware IM
Topic: Loop through two business objects and copy one to the other if not present in the list
Replies: 6
Views: 3763

Re: Loop through two business objects and copy one to the other if not present in the list

The long term plan is for the validation data to come from a different piece of software and feed into AwareIM. Once this is set up, the only requirement will be to do this check so it seemed cleaner to keep them separate.