Search found 22 matches

by cgriffin
Tue Jun 11, 2019 11:56 am
Forum: Crystal Report Development
Topic: My Work Items
Replies: 3
Views: 3103

Re: My Work Items

Thank you for this information. Unfortunately, it only provides what is assigned. I really need to find orders that are in queues, and have yet to be assigned to any particular user. How do I go about retrieving that information?
by cgriffin
Fri Jun 07, 2019 6:14 pm
Forum: Crystal Report Development
Topic: My Work Items
Replies: 3
Views: 3103

My Work Items

How do I retrieve from the database - the view of My Work Items? Specifically the information in the tabs under my work items. For the queues, and then My Orders/Tasks.

Thank you,
Colin.
by cgriffin
Fri Aug 19, 2016 10:47 am
Forum: Crystal Report Development
Topic: pfm.Entity Table - XML
Replies: 1
Views: 2390

pfm.Entity Table - XML

Good morning, We currently have 89 million records in our pfm.Entity table. We created a custom field for our closed date, as the standard field, if someone was to accidentally set the order back to "In Progress" and then you Close it, it automatically sets the date back to the current dat...
by cgriffin
Mon Jun 13, 2016 3:16 pm
Forum: Crystal Report Development
Topic: SP Image/Attachments
Replies: 3
Views: 2729

Re: SP Image/Attachments

Good afternoon Bob, Just to clarify, we are not looking for the attachments themselves, just the Name, Description, Type, Source, Size, Last Modified on, Last Modified by , or at the very least just the description of the attachment. Therefore, we are only looking to retrieve the metadata. Please se...
by cgriffin
Tue Jun 07, 2016 2:36 pm
Forum: Crystal Report Development
Topic: SP Image/Attachments
Replies: 3
Views: 2729

SP Image/Attachments

For pre 3.0 files, I am able to return data for attachments with the following: SELECT O.Number, DI.Description, DI.FileType FROM core.Blob cb RIGHT JOIN pf.[Order] O ON o.Guid = cb.ID JOIN dbo.DocumentImage DI ON DI.OrderID = O.Guid WHERE O.Number = "I would place a pre 3.0 file number here.&q...
by cgriffin
Fri May 20, 2016 5:46 pm
Forum: General
Topic: Title Insurance Calculations/Underwriter
Replies: 10
Views: 2076

Re: Title Insurance Calculations/Underwriter

Hi Bob,

I work with Dave, the answer to your question is - no.

Thanks,
Colin.
by cgriffin
Thu May 05, 2016 9:29 am
Forum: General
Topic: CDF Fees
Replies: 4
Views: 1258

Re: CDF Fees

I have a similar question, how do I get this information for Section B/C and H. I need to get to the Payee Grid and see the Payee Name. As you aware, the Payee can be different on the CDF Line, compared with the Payee Grid. I can get the contact information on the main line, but not "behind&quo...
by cgriffin
Mon Jan 18, 2016 4:48 pm
Forum: Integration Development
Topic: Custom Business Rules
Replies: 9
Views: 1563

Re: Custom Business Rules

Good afternoon,

May I please have an update?

Thank you,
Colin.
by cgriffin
Fri Jan 15, 2016 12:21 pm
Forum: Integration Development
Topic: Custom Business Rules
Replies: 9
Views: 1563

Re: Custom Business Rules

Good morning,

I was wondering if anyone had an opportunity to review my response?

Thank you,
Colin.
by cgriffin
Wed Jan 13, 2016 11:45 am
Forum: Integration Development
Topic: Custom Business Rules
Replies: 9
Views: 1563

Re: Custom Business Rules

Good morning,

I was wondering if anyone had an opportunity to review my response?

Thank you,
Colin.