samonpress's Replies | ww.wp.xz.cn

Forum Replies Created

Viewing 7 replies - 1 through 7 (of 7 total)

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Hide Published Table

Thread Starter samonpress
(@samonpress)

5 years, 8 months ago

Hi Peter!

I tried with this code in Table Options advance column. It gives an error as follows:

Parse Error on Line 1:
{“initComplete”:
_^
Expecting ‘STRING’, ‘}’, got ‘undefined’

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Hide Published Table
Thread Starter samonpress
(@samonpress)

5 years, 8 months ago
Thank you for the response Peter!

I thought of solving it by checking if the user is logged in, if yes then show table else hide. (Because if Yes – then there must be some data).

I was trying to use Table Option (advance) within Data Publisher. From another topic I learned that I’ve to disable JSON validation and toggled it to textarea without JSON validation to avoid the error message.

For the beginning I am only trying to hide the table in advance option but nothing seems to be happening. Here’s the code and I’m sure I might be doing something wrong. Can you please help.
```
$(document).ready(function() {
     $("#tdwholesome21_wrapper).hide();
});
```
- This reply was modified 5 years, 8 months ago by samonpress.
Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Computed Columns

Thread Starter samonpress
(@samonpress)

5 years, 8 months ago

Thank you! That worked.

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Using Analytics/SQL Server Functions

Thread Starter samonpress
(@samonpress)

5 years, 8 months ago

Resolved it by using inner join method which worked just fine. Used this link
https://www.youtube.com/watch?v=Xj4aEHIhk6A&t=264s

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Computed Columns
Thread Starter samonpress
(@samonpress)

5 years, 9 months ago
Hi Peter!

Looking forward to that feature! For now, can creating a trigger be an alternative solution to this situation?

Actually, I want to save the computed value because the numbers used for calculation will change time to time. However, the computed number which shows up on the day will be our promise to the other party.

I’ve been trying to use this trigger statement which is not going through.
```
CREATE OR REPLACE TRIGGER grand_trigger
BEFORE INSERT ON termsheet_db
FOR EACH ROW
WHEN INSERTING THEN
INSERT INTO termsheet_db(grand_totalamt) VALUES (NEW.grandtotal_amt+100),
END;
```
Need help!
Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Creating View by Inner Joining 3 Tables Together, is it Possible?

Thread Starter samonpress
(@samonpress)

5 years, 9 months ago

Advance Look up Table

I’ll quote a script from support page for example. I downloaded WPDA_SAS project and tried to run this script to create view

create viewwpda_sas_course_lookup_with_filter` as
select wpda_sas_course.course_id as course_id
, wpda_sas_module.module_name as module_name
, wpda_sas_class.student_id as student_id
from wpda_sas_class left join wpda_sas_course on
wpda_sas_class.course_id = wpda_sas_course.course_id
left join wpda_sas_module on
wpda_sas_course.module_id = wpda_sas_module.module_id;
`
named the file upload_project.sql and imported the script. It returned me the following error “ERROR: Import plotdetails_sheet.sql failed [check import file]”

Forum: Plugins
In reply to: [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards] Creating View by Inner Joining 3 Tables Together, is it Possible?

Thread Starter samonpress
(@samonpress)

5 years, 9 months ago

Sure! It’ll be great if I can share these scripts in private.

Viewing 7 replies - 1 through 7 (of 7 total)