Search found 40 matches

by ngillet
Thu Mar 24, 2022 7:36 am
Forum: General
Topic: Database Mapping and TransactionType of order
Replies: 14
Views: 11102

Re: Database Mapping and TransactionType of order

Ok.I am waiting for solution from your side.
Thanks!
by ngillet
Wed Mar 23, 2022 7:54 am
Forum: General
Topic: Document History
Replies: 28
Views: 295002

Re: Document History

Could you please provide the database mapping of "Attachment" tab of SoftPro Currently in our project if any new document goes to Document History tab then a information email goes for that newly added document to their corresponding users ,but if someone drag and drop the document in &quo...
by ngillet
Wed Mar 23, 2022 5:16 am
Forum: General
Topic: Database Mapping and TransactionType of order
Replies: 14
Views: 11102

Re: Database Mapping and TransactionType of order

Currently when I run the script which you provided it gives me 18 rows but there are 43 marketing reps in SoftPro dropdown.
I think this is happening because some marketing reps are not assigned in any order.
I want all marketing reps list either they are having order or not having any order
by ngillet
Tue Mar 22, 2022 8:52 am
Forum: General
Topic: Database Mapping and TransactionType of order
Replies: 14
Views: 11102

Re: Database Mapping and TransactionType of order

when I run "SELECT * FROM [NVES4].[SelectDb].[core].[PositionAssociation]
where PositionID = 'ECFABA37-FB08-4BA9-8250-4EF30ADECF72' " this query I got 74 rows .But in SoftPro we are having 9 marketing reps.

This query should return 9 rows not 74 rows.
by ngillet
Thu Mar 17, 2022 1:19 am
Forum: General
Topic: Database Mapping and TransactionType of order
Replies: 14
Views: 11102

Re: Database Mapping and TransactionType of order

I just want list of all marketing reps either they are having any order as marketing reps or not having .If someone is marked as marketing reps and currently he/she is not assign to any order as marketing reps so there is no data present in contact table for that marketing reps. So in that case how ...
by ngillet
Wed Mar 16, 2022 1:52 am
Forum: General
Topic: Document History
Replies: 28
Views: 295002

Document History

For some user when they drag and drop a document under attachment tab in an order that document also showed in document history tab but when I added documents in attachment it does not go under Document History tab. I also find that some document source is "Attached" and some source is &qu...
by ngillet
Wed Mar 16, 2022 1:15 am
Forum: General
Topic: Database Mapping and TransactionType of order
Replies: 14
Views: 11102

Re: Database Mapping and TransactionType of order

Please find the image of checkbox of marketing reps whose mapping I want
by ngillet
Wed Mar 16, 2022 1:10 am
Forum: General
Topic: Database Mapping and TransactionType of order
Replies: 14
Views: 11102

Re: Database Mapping and TransactionType of order

I want to know mapping of this check box of marketing reps which I showed in image
by ngillet
Tue Mar 15, 2022 3:44 am
Forum: General
Topic: Database Mapping and TransactionType of order
Replies: 14
Views: 11102

Re: Database Mapping and TransactionType of order

1)I want to know the mapping of checkbox of marketing reps in database either that marketing rep have any order or not in thier account. Please provide me which table column is storing this checkbox information. 2)The order "Transaction type" is set 2 in [SelectDb].[pfm].[Order] Table , I ...
by ngillet
Mon Mar 14, 2022 9:23 am
Forum: General
Topic: Database Mapping and TransactionType of order
Replies: 14
Views: 11102

Database Mapping and TransactionType of order

I have explore nves4 server database to find that which table has mapping for Marketing Representative checkbox of SoftPro but I do not find any database table which has mapping for these check boxes And second, when I create any order in SoftPro so many times its TransactionType is 2 in [SelectDb]....