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
Discussion posts and replies are publicly visible
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?
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?
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.
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.