Question

date diff with calender in storedproc

Forum|Forum|1 year ago
December 7, 2024
4 replies
0 views

Hi Everyone,

I have a use case where I need to get the date difference between two dates ; but using the calender available in Appian. Due to some performace issues, all date differences I am doing in stored procedure and calling the same from Appian to get the value. But If I have to consider Appian calender, how to pass to the stored proc, so it will provide me the correct date difference considering the calender.

Regards,

Ghanashyam

calendar

stefanhelzle0001

I do not see a direct way to extract the off-times from an Appian calendar. Did you consider to create a separate table in DB that stores this calendar data and use that?

G

ghanashyam905071Author

Yeah I thought of a table..But the issue is we need to maintain the same data in multiple places like in Appian and DB which client is hesitant for.

mathieud0001

You have two options:

1. Process the data in Appian and use the Appian provided calendar functions.

2. If you can't get around the Stored Procedure requirement, there are databases that allow you call to call REST apis, you could expose the Appian calendar functions via an API.

Is there any specific reason you need to use a stored proc for this rather than just creating an Appian process?

G

ghanashyam905071Author

Yeah, the due to volume of data, the performance is being impacted whenever I am doing that in Appian. Stored proc is pretty faster than Appian orchestration. So thought of moving the logic in SP instead of Appian.

Sign up

Login with SSO

Login to the community

Login with SSO