Aware IM User Forums

BLOMASKY wrote: ↑Sun Jan 29, 2023 6:19 pm

BobK wrote: ↑Fri Jan 27, 2023 8:16 pm Out of curiosity, how would you do that in SQL?

Update BO set Arrival = DateADD(mi, dateDiff(mi, oldPickup, pickup), Arrival)

Bruce

Thanks

Out of curiosity, how would you do that in SQL?

karelh, I am not sure this is possible with AwareIM out of the box. I expose a web service that allows users to send us a picture, and the data for that picture needs to be in a certain format. See forum post: https://www.awareim.com/forum/viewtopic.php?f=1&t=11766 I am exposing a web service and yo...

Also, this is my first entry in this forum. If there is a better place to ask questions such as this, please let me know. This is the place and welcome. ...does the process of importing child records automatically create the requisite parent record? No. I am not sure this will work but you might tr...

You can use Validation on the import. This will cause the BO rules to execute.

If you are using the IMPORT action in a rule, add
WITH VALIDATION
to your rule.

if you are using the Import menu option, select the Validate option.

See the User Guide for more details

obt123, Are you still looking for an answer to this? Whether you are or not, here is my answer. I think the error you are getting C:\\Users\\Administrator\\Downloads\\Imports\\Contact.csv was not found is coming from your s4 parameter. Try putting null in that parameter. For you s2 parameter, you sh...

if you decide to remove those characters, the following will do it: ExecutiveSummary.Narrative=REPLACE_PATTERN(REPLACE_PATTERN(ExecutiveSummary.Narrative, '[\x00-\x1F]', ''), '[\x7F-\xFF]', '') That will remove the 'xF0\x9F\x87\xBa\xF0\x9F' that were in you gif plus any other formatting or control c...

PointsWell wrote: ↑Thu Jun 23, 2022 6:03 am The whole area of Time is inconsistently managed.

There's no WEEK_ADD or YEAR_ADD either.

There has been a few times I wish there was a START_OF_DAY (similar to START_OF_WEEK) that returned a timestamp with HOURS, MINUTES and SECONDS all set to 00

I would convert minutes to hours. I don't think the minutes function exists. To convert minutes to hours use fractions. example: TIME_ADD('2022-06-23 08:30:00', 0.50) returns '2022-06-23 09:00:00' Note: I think it was fixed several builds back, but there was a time when subtracting fractions (-0.50...

Having multiple levels should not be an issue.

Can you post the details of your set up.

Thanks Jaymer, I will take a look at the new-ish fields and options you mentioned.

No. There are multiple fields prompting for a value but not all of them require a default value.

I just choose the date field as an example and because for dates, the default will change daily.

When executing a query that uses (Ask at run-time) is it possible to default the value so that the user does not need to enter it? Specifically, if the query is searching a data field and the majority of the time the date being searched for is the current date, I would like the date field on the que...

I am just guessing, but here is what I think is causing your error. Subtracting a TimeStamp from a TimeStamp (Work.EndTime - Work.Starttime) gives you a Duration. Subtracting your third TimeStamp (Work.PauzeTime) from the Duration gives you your error. What does PauzeTime represent? A point in time ...

I occasionally have this issue too. Aware thinks processes are running which prevents BSV from being published. The processes in question are not running and I have not been able to determine why Aware thinks they are still running. In my case, I just reset Aware and publish the BSV. Any users activ...