Search found 5 matches

by DKane-Element
Mon Mar 25, 2019 3:23 pm
Forum: Standard/Enterprise Development
Topic: SQL Query Help
Replies: 7
Views: 1073

Re: SQL Query Help

I'm starting to get the impression that a lot of what I'm looking for is stored in the physical PFD for the FirmFile and not in the database.
by DKane-Element
Mon Mar 25, 2019 3:21 pm
Forum: Standard/Enterprise Development
Topic: SQL Query Help
Replies: 7
Views: 1073

Re: SQL Query Help

Next stumper... Parcel ID number? I have access to the Brief Legal description (BLegal), but need to be able to query on the Parcel ID.
by DKane-Element
Mon Mar 25, 2019 2:24 pm
Forum: Standard/Enterprise Development
Topic: SQL Query Help
Replies: 7
Views: 1073

Re: SQL Query Help

So this is the situation I'm running into, from a lookup perspective... On the Search table, it stores in the LenName field the Name1 from the Lender lookup. Unfortunately there are about 10 rows in the Lender Lookup that all have the same Name1. How do you determine which LENDER.CODE or LENDER.ID w...
by DKane-Element
Mon Mar 25, 2019 2:13 pm
Forum: Standard/Enterprise Development
Topic: SQL Query Help
Replies: 7
Views: 1073

Re: SQL Query Help

Thank you for the information.
by DKane-Element
Fri Mar 22, 2019 10:27 am
Forum: Standard/Enterprise Development
Topic: SQL Query Help
Replies: 7
Views: 1073

SQL Query Help

New to the forum and new to SoftPro. Working on an ENT 31.0.2 version. I'm trying to develop a SQL query to extract information from SoftPro so that it can be used with an iManage Work DMS. The biggest issue I'm having is the lack of relational links between tables/databases and finding unique data....